Company: Aon

Location: Calgary, AB – Toronto, ON

Expected salary:

Job date: Fri, 22 Nov 2024 06:46:29 GMT

Job description: Job Description:Early Careers: Intern Analyst, Health Analytics – Winter 2025 – 8 monthsAre you a student with excellent technical and analytical skills looking to gain professional experience as part of an industry leading team? Are you motivated to achieve tangible outcomes for our clients by delivering innovative and effective solutions? We have the position for as an Intern Analyst supporting our Health Solutions practice!This is an 8-month full-time hybrid role with the flexibility to work both virtually and from our Toronto or Calgary offices.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 decisionsAt 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;
• Build strong working relationships and collaborate effectively on cross functional teams with colleagues, clients and carriers;
• 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 differentAs 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

• Pursuing a Bachelor’s degree in Statistics, Mathematics, Computer Science or a related field
• 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 colleaguesIn 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.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.Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status.We welcome applications from all and provide individuals with disabilities with reasonable adjustments to participate in the job application, interview process and to perform essential job functions once onboard. If you would like to learn more about the reasonable accommodations we provide, email#HYBRID#AonInternshipCanada#AonNewGradsRotationalCanada#LI-KT2#LI-Internship 2547657