AON Looking for Analyst – Business Analytics at Alberta Full Time

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 ReasonableAdjustments@Aon.com

  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 ReasonableAdjustments@Aon.com

  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