Senior Data Engineer

Sun Life

. Design and engineer data models representing key business entities such as Advisors, Clients, and Products .

Posted 10/23/2026full-timeToronto • CanadaSenior💰 CA$85,000 - CA$128,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Expertise in designing and engineering data models, ensuring data quality and integrity, and implementing data products for analytical use cases. Proficient in cloud technologies, data governance, and collaboration with cross-functional teams to derive business value from data.

Highest-signal resume keywords

AWSSnowflakePythonSQLData Governance

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

Data ModelingETL PipelinesData QualityData IntegrationRelational Database SystemsSpark OptimizationData Products EngineeringStatistical ModelsBig Data TechnologiesData Pipeline Logic

Soft Skills

Verbal CommunicationWritten CommunicationCollaboration

Tools & Technologies

PySparkParquetIcebergDevOps Technologies

Certifications & Qualifications

Reliability Status Clearance

Industry Keywords

Financial ServicesData Governance PrinciplesAI ServicesClient Behavior AnalysisAnalytical Models

Tech Stack

Tools & technologies

AWSCloudETLPySparkPythonSparkSQL

About the role

Key responsibilities & impact

Design and engineer data models representing key business entities such as Advisors, Clients, and Products
Maintain high data quality and integrity across data sources
Convert complex business and technical rules into data-flow and data-pipeline logic
Understand enterprise data and interpret it to derive business value
Work with Data Science teams to implement data products for varied use cases
Collaborate with stakeholders and incorporate requirements into solution designs
Standardize metadata into a common glossary and document it for data consumers
Build enriched data products supporting analytical models across Canadian business units
Bridge business-consumer requirements and data-engineering practitioners
Partner with CXO business stakeholders, enterprise governance and risk partners, and CXO data practitioners
Work with data analysts and data scientists to identify business opportunities, understand client behavior, and optimize sales cycles

Requirements

What you’ll need

3–5 years of hands-on experience with major cloud technologies and programming languages for data processing and analytics
3+ years of experience with AWS and Snowflake for ETL pipelines, catalog management, data quality, and data governance
3+ years of experience and proficiency in Python, PySpark, and SQL
Demonstrated experience optimizing Spark and SQL job cost and performance
5 years of hands-on experience with relational database systems, relational, dimensional, and analytical models
3–5 years of experience engineering data products for analytical models
3–5 years building feedback loops between model deployment and data
Sound understanding of data management and data governance principles
Proven ability to extract, conform, and integrate operational data sources into production-grade data products
Experience with Parquet and Iceberg data formats
Experience with very large datasets and big data technologies
Excellent verbal and written communication skills and ability to partner with Data Scientists to articulate insights
Understanding of AI and machine learning concepts and AWS/Snowflake AI services
Knowledge of fundamental statistical models and techniques
Knowledge and experience with DevOps technologies
Experience in a large financial services organization
Reliability Status Clearance required before employment
Must satisfactorily complete applicable background checks before starting and during employment
Undergraduate degree in Computer Science, Mathematics, Engineering, or equivalent

Benefits

Comp & perks

Wellness programs supporting mental, physical, and financial health
Variety of career paths with networking potential
Hybrid work flexibility between office and virtual work
Incentive plans for eligible employees, subject to individual and company performance
Accommodation support during the application process
Employee well-being and mental health workplace initiatives