Data Engineer

Sun Life

. Design, develop, and maintain scalable data pipelines using AWS Glue, Kafka, and Step Functions .

Posted 10/16/2026full-timeWaterloo • CanadaMid-LevelSenior💰 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.

Demonstrates expertise in designing and optimizing ETL processes using AWS Glue, SSIS, and Informatica, while ensuring data quality and compliance. Proficient in SQL and Python, with strong leadership skills to mentor teams and collaborate across functions.

Highest-signal resume keywords

ETL Design And DevelopmentAWS GlueSQL ProgrammingData Warehousing ConceptsBilingualism (French And English)

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

ETL ProcessesData ModelingPython ProgrammingSQLData WarehousingInformaticaTalendSSISKafkaData Formats

Soft Skills

Problem-SolvingAnalytical SkillsCommunicationLeadership

Tools & Technologies

AWS Step FunctionsAWS ServicesData PipelinesData Quality ToolsData Compliance Tools

Certifications & Qualifications

Bachelor’s Degree In Computer ScienceReliability Status Clearance

Industry Keywords

Data EngineeringData Sourcing Best PracticesBusiness IntelligenceAnalytics InitiativesStream Processing

Tech Stack

Tools & technologies

AWSETLInformaticaKafkaPythonSQLSSIS

About the role

Key responsibilities & impact

Design, develop, and maintain scalable data pipelines using AWS Glue, Kafka, and Step Functions
Implement and optimize ETL processes using SSIS, Informatica, or Talend
Guide and mentor Data Engineers on ETL development and data sourcing best practices
Create and maintain data models for business intelligence and analytics initiatives
Collaborate with cross-functional teams to understand data requirements and deliver solutions
Ensure data quality, security, and compliance with industry standards and regulations
Troubleshoot data-related issues and implement solutions
Stay current with emerging data engineering technologies and best practices

Requirements

What you’ll need

Bachelor’s degree in computer science, Information Technology, or related field
5-10 years of experience in ETL design, modeling, and development
Strong proficiency in SQL and Python programming
Experience with AWS services, particularly Glue, Step Functions, and other data-related services
Expertise in data warehousing concepts and methodologies
Proficiency in ETL tools such as Informatica, Talend, or SSIS
Experience with various database systems and data formats
Familiarity with Kafka and stream processing concepts
Excellent problem-solving and analytical skills
Strong communication and leadership abilities
Reliability Status Clearance required before starting employment
Bilingualism (French and English, oral and written) required for Quebec locations

Benefits

Comp & perks

Comprehensive benefits package
Participation in various incentive plans
Opportunities for professional growth and development
Flexible work arrangements
Work-life balance
Chance to work on impactful projects that drive business success
Hybrid work with flexibility to work from the office and virtually
Disability accommodation in the application process