We are seeking a highly analytical and solutions-oriented Data Analyst to support Workplace Benefits and Retirement.
This role offers the opportunity to work closely with cross-functional teams and our Field Sales and Service partners. The successful candidate will possess a deep curiosity for understanding data, adept at identifying anomalies, investigating discrepancies, and the ability to design and implement efficient data‑driven solutions.
In addition, the Data Analyst will build and evolve analytical reporting using Power BI, Excel, and SQL. By digging into performance results, identifying key trends, and translating complex data into clear insights, the role provides the information needed for data‑driven action to help move our business grow.
What you will do
Analyze, interpret, and validate large data volume to identify trends, inconsistencies, and anomalies
Provide technical and functional support on complex compensation programs, support decision‑making with sound judgement backed by data, and mentor team
Write and optimize SQL queries to support data retrieval and reporting
Maintain tools and scripts using VB.NET to support business needs
Translate complex datasets into clear, compelling insights and business narratives
Work with stakeholders to improve data availability, quality, and drive automation
Ensure data accuracy and integrity through validation, reconciliation, and quality checks
Help resolve issues, perform analysis, and support application enhancements
Document data flows, models, and solutions to ensure sustainability
What you will bring
3+ years of hands‑on experience with:
Data modeling concepts and tools
SQL (query development, optimization)
VB.NET
Power Automate
Power Apps
Power BI
Excellent communication skills, with the ability to explain technical concepts to non‑technical audiences
Strong analytical and problem‑solving skills with the ability to break down complex problems into manageable components
Ability to model, structure, validate, and document complex datasets to support accurate and reliable decision‑making
Experience improving manual operational processes, including the ability to streamline or automate validation workflows
Proven experience identifying errors, inconsistencies, and anomalies in data
Ability to manage multiple priorities in a fast‑paced environment
A proactive mindset — you seek to understand the purpose behind requests and consistently look for opportunities to improve processes and outcomes
-
The base salary for this position is between $54,700 - $104,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’reunited by a shared purpose: to improve the financial,physicaland mental well‑beingof Canadians. Our company is trusted by 1 in 3 Canadians and contributes to the strength of communities across the country.
We’relooking for people who live our values everyday:
we step up, we do the right thing, and we deliver – for our customers,communitiesand each other.Are you someone who always strives to do the right thing, who steps up for themselves and others, and who 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: Versatile 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 aworkplace whereemployeesfeel connected and supported throughEmployee Resource Groups (ERGs),mentorshipprograms,socialclubsandevents.
We’recommitted to removing barriers and ensuring equal access to employment. Applicants requiring reasonable accommodation during the application process may contact
[email protected] . All information provided will be handledin accordance withapplicable laws and Canada Life policies.
Canada Life would like to thank all applicants, however only those who qualify for an interview will be contacted .
#LI-Hybrid
Requisition ID: 6578
Category: Sales and Business Development
Location:
Toronto, ON, CA Winnipeg, MB, CA
Date: Jul 17, 2026
#J-18808-Ljbffr
📌 Data Analyst (Ontario)
🏢 TechAlliance of Southwestern Ontario, London Economic Development
📍 Ontario