As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions supporting our Health Solutions practice.
As an Analyst, you will be a member of Aon’s National Analytics team, supporting advanced analytics and reporting in the servicing of existing clients and prospects.
Aon is in the business of better decisions
At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.
As an organization, we are united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed.
What the day will look like
Be part of a dynamic team of analysts, actuaries and business experts focused on designing and building healthcare data and analytics products;
Build strong working relationships and collaborate effectively on cross functional teams with colleagues, clients and carriers;
Manage data requirements, gather information on client requirements, analyze and report on data;
Develop and maintain on-premises and cloud-based data warehouse/data lakes such as Snowflake and Databricks;
Develop and maintain SQL databases, Entity diagrams (ED), including ETL, SSIS and SQL Jobs;
Implement automation and efficiencies wherever possible to streamline the process, minimizing the need for manual intervention;
Evaluate, design, and implement advanced analytics solutions to address business needs;
Maintain an up-to-date knowledge of the group benefits industry, systems, products, trends, and emerging technology, while having a thorough understanding of how these relate to group insurance consulting; and
Participate in functional team activities which support the operations of the Health Solutions practice.
Skills and experience that will lead to success
2 to 4 years of experience working in a consulting, financial or insurance environment working in group benefits or group underwriting department, would be considered an asset;
Demonstrate analytical skills and creativity to quickly integrate information, identify trends, draw conclusions and provide meaning to data;
Practical knowledge in SQL, Python, and BI tools (e.g. Power BI, Tableau);
Knowledge in ETL processes, both design and implementation;
Applied statistics skills such as distributions, statistical testing, regression, etc.;
Strong technical skills in analyzing data for machine learning model building using various methods including k-mean clustering, collinearity and other advanced techniques
Knowledge of best practices to ensure maintainability and efficiency of data-centric projects
Strong technical skills, advanced understanding of databases, experience reporting and analyzing data using advance functions through Microsoft Excel and Access;
Superior communication skills, both written and oral, bilingual would be considered an asset;
Excellent time management and prioritization skills, ability to work under deadlines, and work on several projects simultaneously is critical;
Work well as part of a team and ability to self-manage;
Ability to discover, ask key questions and seek for guidance where appropriate. Interest to think beyond day-to-day tasks and understand how your work aligns to the success of Aon’s Health Solutions practice;
Bachelor’s degree in Statistics, Mathematics, Actuarial Science, Computer Science or related discipline, or equivalent years of industry experience; and
Commitment to professional development.
How we support our colleagues
In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions, but we also recognise that flexibility goes beyond just the place of work… and we are all for it. We call this Smart Working!
Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued.
We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation on [email protected]
Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.
#LI-DR1
#LI-HYBRID
2512901
As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions supporting our Health Solutions practice.
As an Analyst, you will be a member of Aon’s National Analytics team, supporting advanced analytics and reporting in the servicing of existing clients and prospects.
Aon is in the business of better decisions
At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.
As an organization, we are united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed.
What the day will look like
Be part of a dynamic team of analysts, actuaries and business experts focused on designing and building healthcare data and analytics products;
Build strong working relationships and collaborate effectively on cross functional teams with colleagues, clients and carriers;
Manage data requirements, gather information on client requirements, analyze and report on data;
Develop and maintain on-premises and cloud-based data warehouse/data lakes such as Snowflake and Databricks;
Develop and maintain SQL databases, Entity diagrams (ED), including ETL, SSIS and SQL Jobs;
Implement automation and efficiencies wherever possible to streamline the process, minimizing the need for manual intervention;
Evaluate, design, and implement advanced analytics solutions to address business needs;
Maintain an up-to-date knowledge of the group benefits industry, systems, products, trends, and emerging technology, while having a thorough understanding of how these relate to group insurance consulting; and
Participate in functional team activities which support the operations of the Health Solutions practice.
Skills and experience that will lead to success
2 to 4 years of experience working in a consulting, financial or insurance environment working in group benefits or group underwriting department, would be considered an asset;
Demonstrate analytical skills and creativity to quickly integrate information, identify trends, draw conclusions and provide meaning to data;
Practical knowledge in SQL, Python, and BI tools (e.g. Power BI, Tableau);
Knowledge in ETL processes, both design and implementation;
Applied statistics skills such as distributions, statistical testing, regression, etc.;
Strong technical skills in analyzing data for machine learning model building using various methods including k-mean clustering, collinearity and other advanced techniques
Knowledge of best practices to ensure maintainability and efficiency of data-centric projects
Strong technical skills, advanced understanding of databases, experience reporting and analyzing data using advance functions through Microsoft Excel and Access;
Superior communication skills, both written and oral, bilingual would be considered an asset;
Excellent time management and prioritization skills, ability to work under deadlines, and work on several projects simultaneously is critical;
Work well as part of a team and ability to self-manage;
Ability to discover, ask key questions and seek for guidance where appropriate. Interest to think beyond day-to-day tasks and understand how your work aligns to the success of Aon’s Health Solutions practice;
Bachelor’s degree in Statistics, Mathematics, Actuarial Science, Computer Science or related discipline, or equivalent years of industry experience; and
Commitment to professional development.
How we support our colleagues
In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions, but we also recognise that flexibility goes beyond just the place of work… and we are all for it. We call this Smart Working!
Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued.
We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation on [email protected]
Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.
#LI-DR1
#LI-HYBRID
Youthfully is seeking a driven and resourceful Sales & Enrollment (BDR/SDR) Manager to join our fast-growing edtech startup. You’re joining...
Apply For This JobWaste Connections of Canada is a leading non-hazardous solid waste management in North America. We are looking for a SAFETY...
Apply For This JobEmployment Type Contract ending March 29th, 2024, Bargaining Unit Work Hours 35 hours/week Work Setting Onsite; Hybrid: Opportunity to work...
Apply For This JobSales Associate – ( 22000LJF ) Description Why Sherwin-Williams Here, we believe there’s not one path to success, but careers...
Apply For This JobThe Opportunity Kids U is a growing Accredited Early Childhood Learning Institute in Calgary and Strathmore. For children aged zero...
Apply For This JobDo you dare to make an impact? YOUR ROLE Education and promotion of Schwarzkopf Professional and Alterna Haircare, including product...
Apply For This Job