Senior Data Engineer

Sun Life

Senior Data Engineer at Sun Life developing data products for analytical models. Collaborating with Data Science teams and business stakeholders to derive insights from enterprise data.

Posted 6/30/2026full-timeToronto • 🇨🇦 CanadaSenior💰 CA$80,000 - CA$128,000 per yearWebsite

Tech Stack

Tools & technologies

AWSCloudETLPySparkPythonSparkSQLTableau

About the role

Key responsibilities & impact

Design and engineer data models that represent our key business entities such as our Advisor, Client & Product
Ensure high level of data quality and data integrity are maintained across data sources for business data assets
Convert complex business and technical rules into logic for data flows and data pipelines
Obsessed with understanding our enterprise data and interpreting it in the best way possible to derive business value
Work with our Data Science teams to implement data products for various use cases
Collaborate with stakeholders and incorporate into solution design for various use case requirements
Standardize metadata into a common glossary along with the necessary documentation for data consumers
Partner closely with CXO business stakeholders, enterprise governance and risk partners, and CXO data practitioners.

Requirements

What you’ll need

3-5 years hands-on experience working on major Cloud technologies and programming languages for data processing and analytics
3+ years experience with AWS and Snowflake platforms for building robust ETL pipelines, Catalog management, Data Quality and Governance implementation to keep data compliant and reliable.
3+ years experience and proficiency in Python, Pyspark and SQL
Demonstrated Experience in cost and performance optimization of Spark and SQL jobs
5 years hands-on experience with relational database systems, relational models, dimensional models, and analytical models
3-5 years experience with engineering data products as input to various analytical models
3-5 years building feedback loops between model deployment and its data – i.e. tune & tweak data products to achieve scale, optimization, etc.
Sound understanding of Data Management principles (data warehousing, data quality, master data management, etc.) and Data Governance principles.
Sound understanding of data modelling and a passion for analytics
Proven ability to leverage knowledge of data engineering to extract, conform and integrate a variety of operational data sources into production-grade data products
Experience of popular data formats like Parquet and Iceberg
Experience in BI Tools like Tableau , Quicksight , Streamlit is a definite plus.
Experience working with very large datasets and familiarity with big data technologies
Excellent verbal and written communication skills; have executive presence and proven ability to partner with Data Scientists to articulate insights gleaned from the model and the underlying data.

Benefits

Comp & perks

Wellness programs that support the three pillars of your health – mental, physical, and financial
The opportunity to move along a variety of career paths with amazing networking potential.
A diverse workforce with wide perspectives and creative ideas benefits our Clients, the communities where we operate and all of us as colleagues.
Ability to work from both the office and virtually based on the needs of the business.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Data ModelingETL Pipeline DevelopmentData Quality ManagementData GovernanceRelational Database SystemsDimensional ModelsAnalytical ModelsCost OptimizationPerformance OptimizationData Engineering

Soft Skills

Excellent Communication SkillsExecutive PresenceCollaboration