Data Analyst

Sun Life Financial; Toronto; On-site; CAD 60,000 - 97,000; Full time

Benefits offered by this job

Hybrid work environment

15 vacation days per year

Flexible benefits

Pension and stock programs

Global Learning Centre access

Wellness programs

Job summary

Sun Life Financial is seeking a Data Analyst to join the Strategy & Analytics team in Toronto. You will transform data into actionable insights across multiple business functions, owning the complete data lifecycle from ingestion to reporting.

The role blends data engineering with analytics, requiring collaboration with stakeholders and rigorous governance. The ideal candidate has 3–5 years of data analytics experience, a relevant degree, and demonstrated AWS proficiency.

Qualifications

• 3-5 years of Data Analytics experience.
• Degree in Computer Science, Mathematics, Statistics, or Engineering.
• Proven AWS proficiency.
• Ability to communicate complex methodologies clearly to non-technical audiences.

Responsibilities

• Design, build, maintain, and optimize enterprise-grade ETL/ELT pipelines to ingest, transform, and integrate data from multiple sources.
• Build and manage scalable, reliable, and secure data platforms, databases, and data warehouses, ensuring high availability and data integrity.
• Develop data modeling, transformation frameworks, and semantic layers to standardize business data for analytics and reporting.
• Own data integration processes, including data quality monitoring, validation, reconciliation, lineage tracking, and error handling.
• Collaborate with business and technical stakeholders to translate data requirements into scalable data solutions and drive governance and performance optimization.
• Design and maintain database schemas, indexing strategies, partitioning approaches, and query optimization to support growth.
• Implement and support cloud-based data solutions using AWS services for storage, orchestration, and automation.
• Contribute to automation, CI/CD deployment practices, infrastructure-as-code, and operational monitoring.

Skills

SQL

Data Modeling

Python

AWS

Data Analytics

Education

Bachelor's degree in Computer Science, Mathematics, Statistics, or Engineering

Tools

Snowflake

Redshift

Airflow

AWS Glue

Job description

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. At Sun Life, we're driven by our Purpose: helping our Clients achieve lifetime financial security and live healthier lives. Our values shape how we work: caring, authentic, bold, inspiring, and impactful. When you join Sun Life, you'll work with passionate colleagues and empowering leaders who support your growth and celebrate your contributions, so you can make a meaningful difference in our Clients' lives. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description

The Data Analyst is a strategic member of the Strategy & Analytics team, responsible for transforming data into actionable insights across multiple business functions. You will own the complete data lifecycle—from sourcing and ingesting data across systems to building robust data warehouses and delivering precision reporting solutions. This role combines data engineering expertise with analytical acumen, requiring you to work collaboratively with stakeholders while maintaining rigorous data governance standards. The ideal candidate brings 3-5 years of data analytics experience, holds a degree in Computer Science, Mathematics, Statistics, or Engineering, and demonstrates proven AWS proficiency. You'll need strong problem-solving skills, expertise in mutual fund and market-based insurance products, and the ability to communicate complex methodologies clearly to non-technical audiences. Success requires balancing technical depth with independent judgment and collaborative teamwork while managing multiple priorities simultaneously.

What will you do?

• Design, develop, maintain, and optimize enterprise-grade ETL/ELT pipelines to ingest, transform, and integrate data from multiple internal and external sources.
• Build and manage scalable, reliable, and secure data platforms, databases, and data warehouses, ensuring high availability, performance, and data integrity.
• Develop and implement robust data modeling, transformation frameworks, and semantic layers to standardize business data and support downstream analytics, reporting, and operational applications.
• Own data integration processes, including data quality monitoring, validation, reconciliation, lineage tracking, and error handling, ensuring completeness and accuracy across systems.
• Collaborate with business and technical stakeholders to translate data requirements into scalable data solutions, while driving best practices in architecture, governance, and performance optimization.
• Design and maintain database schemas, indexing strategies, partitioning approaches, and query optimization techniques to support growing data volumes and evolving business needs.
• Implement and support cloud-based data solutions using AWS services, including data storage, orchestration, and automation capabilities.
• Contribute to the continuous improvement of the enterprise data ecosystem through automation, CI/CD deployment practices, infrastructure-as-code, and operational monitoring.

What do you need to succeed?

• 3-5 years of Data Engineering experience developing and supporting enterprise ETL/ELT pipelines, data integration processes, and automated workflows.
• Strong SQL and Database Expertise, including relational and non-relational database design, schema development, query optimization, indexing, and performance tuning.
• Advanced Data Modeling Skills, with demonstrated experience building semantic, dimensional, and transformation models that standardize data across systems and business domains.
• Hands-on Cloud Data Platform Experience, including AWS and modern data warehouse technologies such as Snowflake, Redshift, or similar platforms.
• Strong Programming and Data Integration Capabilities, including Python and experience integrating data from multiple internal and external sources while ensuring data quality, governance, and reliability.

Preferred Skills

• Experience in Financial Services, Mutual Funds, ETFs, Segregated Funds, or Investment Operations.
• Experience with orchestration and automation tools (Airflow, AWS Glue, Step Functions, etc.).
• Experience with Salesforce or other CRM platforms.
• Experience supporting CI/CD and DevOps practices for data platforms.

Unique Requirements

• Some travel may be required.
• Extra hours may be required during the quarter-end reporting periods and during periods with high mutual fund trading volumes.
• This role requires Reliability Status Clearance.
• In addition to a law enforcement inquiry and a credit check, as part of your application, the Government of Canada will ask if you lived or travelled outside of Canada for 6-consecutive months during the last 5 years, and you must account for all activities during this time.

What's in it for you?

• Hybrid work environment
• A friendly, collaborative, and inclusive culture
• 15 vacation days per year
• Flexible Benefits from the day you join to meet the needs of you and your family
• Pension, stock and savings programs to help build and enhance your future financial security
• The opportunity to move along a variety of career paths with amazing networking potential
• Access to our Global Learning Centre, available 24/7 for your learning needs
• Wellness programs that support the three pillars of your health - mental, physical and financial

Recent Awards

We are honoured to be recognized as a 2022, 2023, 2024, 2025 and 2026 Best Workplaces in Canada by Great Place to Work Canada

Salary Range: 60,000/60 000 - 97,000/97 000

Job Category: Advanced Analytics Posting End Date: 21/08/2026

Shine together

At Sun Life, you can be your most brilliant self. Our supportive, flexible, and inclusive work environment is one where you – and your career – can thrive.

Whatever your aspirations, collaborative leaders and colleagues are ready to help you learn, grow, and succeed. Make life brighter

We’re a global company with a passion for people. Our purpose is to help Clients achieve lifetime financial security and live healthier lives. As a team of 30,000 across 26 countries, our impact is far-reaching, and locally relevant

There’s power in numbers. As part of Sun Life’s growing team, you have an impact on people in your community and around the world. Shape the future

With an optimistic eye on a brighter future, we drive to innovate. Be part of leading change, push boundaries and try new ways of working. Use data to drive bold actions. Be agile and pivot as we test and learn.

At Sun Life, we’re driving transformation, sustainability and innovation for our Clients, employees, partners, and communities. Join us. Together, we can make the future brighter. Join a top employer for a brighter future. Visit Sun Life Careers