Early Careers: Analyst, Health Analytics

Posting Description:
**Early Careers: Analyst, Health Analytics (Toronto, Vancouver or Calgary)**:
As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions as part of our Health Solutions business group within Aon.

As a Analyst in our Health Analytics team, you will be supporting client teams in the servicing of clients with respect to the financial management of their benefit programs. Working alongside a team of analysts and senior team leaders, you will contribute to a range of client work, such as annual renewals, carrier marketings, experience reporting and analysis, budget preparation, financial statement review, union negotiations, pricing, and plan redesigns.
- 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._

**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**:

- 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.

**How this opportunity is different**:
As an Intern Analyst, you will be part of Aon’s National Analytics team, supporting advanced analytics and reporting in the servicing of existing clients and prospects.

**Skills and experience that will lead to success**:

- 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;
**Education**:

- Having a bachelors 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

**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 you