Data Analyst

Sun Life; Toronto; Hybrid; CAD 60,000 - 97,000; Full time

Benefits offered by this job

Hybrid work environment

Pension, stock and savings programs

Flexible Benefits

15 vacation days per year

Wellness programs

Global Learning Centre access

Career networking opportunities

Job summary

Sun Life in Canada seeks a Data Analyst to join the Strategy & Analytics team. You will transform data into actionable insights, own the data lifecycle from sourcing to reporting, and collaborate with stakeholders while maintaining governance.

The ideal candidate has 3-5 years of data analytics experience, a degree in CS/Math/Statistics/Engineering, strong AWS skills, and experience with mutual fund and market-based insurance products; you will design ETL pipelines and data warehouses and

Qualifications

• 3-5 years of data engineering experience with ETL/ELT pipelines.
• Strong SQL and database design, performance tuning.
• Experience with AWS and modern data warehouse tech (Snowflake/Redshift).
• Proficient Python and data integration across sources.
• Ability to translate data requirements into scalable solutions.

Responsibilities

• Design, develop, and optimize ETL/ELT pipelines across sources.
• Build scalable data platforms, databases, and warehouses with high availability.
• Develop data modeling, transformation frameworks, and semantic layers.
• Own data integration quality, lineage, governance and validation.
• Collaborate with stakeholders to translate data requirements into solutions.
• Design schemas and optimize queries for growing data volumes.
• Implement cloud data solutions using AWS services.
• Contribute to CI/CD, infrastructure-as-code, and monitoring.

Skills

Data analytics mindset

Problem-solving

Communication

Collaboration

Independent judgment

Education

Degree in Computer Science/Mathematics/Statistics/Engineering

Tools

SQL

Python

AWS

Snowflake

Redshift

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

The Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results.

Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our Clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.

Persons with disabilities who need accommodation in the application process, or those needing job postings in an alternative format, may e-mail a request to [e-mail].

We are proud to be a hybrid organization that offers our employees the choice and flexibility to work from both the office and virtually based on the needs of the business, our Clients and you.

We may use artificial intelligence to support candidate sourcing, screening, interview scheduling.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range

60,000/60 000 - 97,000/97 000

Job Category

Advanced Analytics

Posting End Date

21/08/2026