Data Analytics Engineer: ETL, AWS & Insights

Sun Life Financial; Toronto; Hybrid; 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

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.