Logo of Huzzle

Home

Matches

Explore

Manage

Early Careers: Analyst, Health Analytics

image

Aon

8d ago

  • Internship
    Full-time
    Off-cycle Internship
  • Data
    Healthcare
  • Toronto

AI generated summary

  • You must be authorized to work in Canada, have analytical skills, proficiency in SQL, Python, BI tools, applied stats knowledge, and teamwork skills. A bachelor’s in a related field is required.
  • You will analyze healthcare data, collaborate with teams, use SQL and data warehouses, implement automation, create visualizations, and support group benefits consulting.

Requirements

  • Applicants must be legally authorized to work in Canada. This role is not eligible for sponsorship, and we are unable to sponsor or take over sponsorship of an employment visa or work permit.
  • 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, including understanding of GitHub;
  • Applied statistics skills such as distributions, statistical testing, regression, etc.;
  • Understanding standard methodologies to ensure the longevity and efficiency of data-centric projects;
  • Extensive technical skills, advanced understanding of databases, experience reporting and analyzing data using advanced functions through Microsoft Excel and Access;
  • Outstanding communication skills, both written and oral;
  • Ability to work closely as a key member of a team and independently with minimum supervision;
  • Excellent time management and prioritization skills, ability to meet deadlines, and work on several projects simultaneously;
  • Ability to discover, ask key questions and seek for mentorship 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;
  • Having a bachelor's degree in Statistics, Mathematics, Computer Science or a related field; or equivalent experience;
  • Previous experience working in financial services or insurance environment working in group benefits or group underwriting department, would be considered an asset;

Responsibilities

  • Join a dynamic team of analysts, actuaries, and business experts passionate about crafting and building healthcare data and analytics products;
  • Foster strong working relationships and effectively collaborate on teams with colleagues, clients, and carriers, spanning multiple functions;
  • Handle data requirements, gather information on client requirements, analyze and report on data;
  • Understand and use on-premises and cloud-based data warehouse/data lakes such as Snowflake and Databricks;
  • Understand, use and query SQL databases, Entity relationship diagrams (ERD), including ETL, Databricks data pipelines and Snowflake Lakehouse compute;
  • Implement automation and efficiencies wherever possible to streamline the process, minimizing the need for manual intervention, predominantly with Python and R programming;
  • Proficient in data visualization using PowerBI, including data modelling;
  • Evaluate, design, and implement sophisticated 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 practice.

FAQs

What is the job title for this position?

The job title is Early Careers: Analyst, Health Analytics.

Where is this position located?

This position is located in Toronto, Vancouver, or Calgary.

What are the main responsibilities of the Analyst in the Health Analytics team?

The Analyst will support client teams in financial management of benefit programs, including annual renewals, experience reporting, budget preparation, and plan redesigns.

Is this position eligible for visa sponsorship?

No, this role is not eligible for sponsorship, and Aon is unable to sponsor or take over sponsorship of an employment visa or work permit.

What educational background is required for this position?

A bachelor's degree in Statistics, Mathematics, Computer Science, or a related field is required, or equivalent experience.

What technical skills are necessary for this role?

Proficiency in SQL, Python, BI tools (e.g., Power BI, Tableau), and knowledge of ETL processes is necessary, along with advanced understanding of databases and experience in statistical analysis.

Are there opportunities for career growth in this role?

Yes, Aon encourages a continuous learning culture that helps colleagues learn, share, and grow to achieve their fullest potential.

What kind of team will the Analyst be working with?

The Analyst will join a dynamic team of analysts, actuaries, and business experts within the Health Analytics team.

Is there a focus on diversity and inclusion at Aon?

Yes, Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves.

What benefits does Aon offer to its employees?

Aon offers a comprehensive benefits package, supports work/life balance with Global Wellbeing Days, and promotes flexible working styles.

How does Aon support employees' well-being?

Aon supports employees' well-being by encouraging the use of Global Wellbeing Days and promoting a flexible work environment known as Smart Working.

How should applicants with disabilities request accommodations?

Applicants with disabilities can request reasonable adjustments to participate in the job application and interview process by emailing ReasonableAccommodations@Aon.com.

Aon

Aon is in the business of better decisions

Consulting
Industry
10,001+
Employees
1940
Founded Year

Mission & Purpose

Aon is a global professional services firm that specializes in risk management, insurance brokerage, and human resources solutions. They offer a wide range of services including risk assessment, insurance brokerage, retirement and health solutions, and data analytics. Aon's ultimate mission is to empower clients to manage risk effectively, optimise their resources, and make informed decisions that drive business growth and resilience. Their purpose is to help clients navigate the complexities of risk and talent management, providing innovative solutions and insights that enable organisations to mitigate risks, protect assets, attract and retain talent, and enhance overall operational performance. Aon aims to be a trusted advisor, offering customised solutions that address the unique challenges of their clients across industries, ensuring they are well-prepared and positioned for success in a rapidly changing world.