Analyst, Data & Analytics

TechAlliance of Southwestern Ontario, London Economic Development Corporation; Toronto; On-site; CAD 66,000 - 88,000; Full time

Benefits offered by this job

Career development programs

Health and dental benefits

Mental health benefit

Volunteer day

Company-matching pension plan

Share ownership program

Employee discounts

Job summary

Canada Life in Toronto is seeking a highly skilled Data Analyst to join the Insurance Solutions team. You will support data management, analysis, and reporting to inform decision-making and produce insights for diverse audiences.

This role collaborates with data scientists and SMEs, builds data models, dashboards, and data marts, and translates requirements into actionable solutions while ensuring data quality and governance.

Qualifications

• University or College education in a related field, or an equivalent combination of education and experience.
• Experience working with raw data and manipulating large datasets.
• Proficiency in Excel, Power BI, data modelling, and Databricks, with experience creating interactive dashboards.
• Ability to work with diverse data inputs and build data marts aligned with business requirements.
• Proven ability to learn quickly, work independently, and manage multiple priorities in a fast-paced environment.
• Ability to write complex SQL queries to extract and integrate data from multiple sources.
• Proficiency in scripting languages such as Python or R.
• Hands-on experience with Azure compute services and a good understanding of Azure Data Factory pipelines.

Responsibilities

• Build, implement, and maintain data models, custom reports, and dashboards, keeping in mind the needs of varied audiences.
• Create visually compelling presentations and use strong communication skills to present them to stakeholders (ability to build a narrative that outlines the background and highlights the impact of initiatives).
• Identify opportunities to ingest data, prioritize data needs, and build data marts to drive efficiencies in reporting functions.
• Leverage data expertise to support new initiatives through analysis and ongoing reporting across the entire analytics lifecycle.
• Communicate requirements to the Technology team for development and ensure smooth deployment of data projects after performing data quality testing.
• Collaborate with cross-functional teams to gather requirements and deliver data solutions that meet business needs.
• Support existing data owners in their data management practices, ensuring a single source of truth.
• Work with large datasets that may be inconsistent, unclean, or not fully modeled.
• Ensure best practices are followed with respect to data governance and structure.
• Communicate effectively while demonstrating critical thinking and business acumen.

Skills

Excel

Power BI

SQL

Python

R

Data modelling

Databricks

Azure Data Factory

Communication

Education

University or College degree in related field

Tools

Azure Data Factory

Job description

Select how often (in days) to receive an alert:

Canada Life is seeking a highly skilled Data Analyst to join the Insurance Solutions team. As a part of the Performance Management area, this role will be responsible for supporting the data management, analysis, and reporting needs of the department. The Data Analyst supports decision-making, monitors business performance, and provides actionable insights using analytics and visualizations tailored to different audiences.

The role will benefit from collaboration with subject matter experts and data scientists. If you are looking to become a subject matter expert in connected data and help guide the team in improving processes through data mining and analysis, this is the role for you.

Given the size and scope of our organization, we have the flexibility for this position to be located in the following head office locations: Toronto and London.

What you will do

• Build, implement, and maintain data models, custom reports, and dashboards, keeping in mind the needs of varied audiences
• Create visually compelling presentations and use strong communication skills to present them to stakeholders (ability to build a narrative that outlines the background and highlights the impact of initiatives)
• Identify opportunities to ingest data, prioritize data needs, and build data marts to drive efficiencies in reporting functions
• Leverage data expertise to support new initiatives through analysis and ongoing reporting across the entire analytics lifecycle
• Communicate requirements to the Technology team for development and ensure smooth deployment of data projects after performing data quality testing
• Collaborate with cross-functional teams to gather requirements and deliver data solutions that meet business needs
• Support existing data owners in their data management practices, ensuring a single source of truth
• Work with large datasets that may be inconsistent, unclean, or not fully modeled
• Ensure best practices are followed with respect to data governance and structure
• Communicate effectively while demonstrating critical thinking and business acumen

What you will bring

• University or College education in a related field of study, or an equivalent combination of education and experience
• Experience working with raw data and manipulating large datasets
• Proficiency in Excel, Power BI, data modelling, and Databricks, with experience creating interactive dashboards
• Ability to work with diverse data inputs and build data marts aligned with business requirements
• Proven ability to learn quickly, work independently, and manage multiple priorities in a fast-paced environment
• Ability to work with little to no documentation or instructions
• Strong attention to detail, with the ability to produce high-quality outputs under tight timelines
• Driven to continuously improve processes, performance, and efficiency
• Knowledge of the organization, distribution channels, products, systems, and data is an asset
• Ability to write complex SQL queries to extract and integrate data from multiple sources
• Proficiency in scripting languages such as Python or R
• Hands-on experience with Azure compute services and a good understanding of Azure Data Factory pipelines
• Preferred: Microsoft Certified – Azure Data Analyst Associate (Power BI) certification

The base salary for this position is between $65,800 - $87,700 annually. This represents base salary only and does not represent other variable compensation components of our total compensation ( i.e. annual bonus, commission etc). If you are selected to move forward in our recruitment process, your recruiter will be able to discuss additional details of our total rewards program with you.

Career opportunities will be open a minimum of 5 business days from the date of posting, closing dates will vary depending on the search activity. All applications received will be reviewed on a rolling basis.

Grow with Canada Life

We’re united by a shared purpose: to improve the financial, physical and mental well-being of Canadians. Our company is trusted by 1 in 3 Canadians and contributes to the strength of communities across the country.

We’re looking for people who live our values everyday: we step up, we do the right thing, and we deliver – for our customers, communities and each other. Are you someone who always strives to do the right thing, who steps up for themselves and others, and delivers with impact? Then we want to hear from you!

What we offer

We’re committed to supporting our employees through every stage of their career. Here’s what you can expect as a full-time or part-time permanent team member:

• Career Development: Opportunities for career advancement, access to industry-leading learning programs and up to$2,000 annuallytowardseducation reimbursement.
• Health & Wellness: Flexible health and dental benefits,plus a $5,000 mental health benefit to support your well-being.
• Time Off: In addition to regular vacation andpersonal days, we support communityinvolvement with avolunteer day.
• Financial Security: Company-matching pension plan,share ownership program andadditionalinvestment options.
• Rewards and Recognition: Employee recognition programs, service milestone celebrations, employee discounts and more!
• Emphasis onCommunity: We provide a workplace where employees feel connected and supported through Employee Resource Groups (ERGs), mentorshipprograms, socialclubsandevents.

We’re committed to removing barriers and ensuring equal access to employment. Applicants requiring reasonable accommodation during the application process may contact [e-mail]. All information provided will be handled in accordance with applicable laws and Canada Life policies.

Canada Life would like to thank all applicants, however only those who qualify for an interview will be contacted.

Location: Toronto, ON, CA