Student, Associate Data Engineer (Fall 2026)

Sun Life•Waterloo, ON

2d•Hybrid

About The Position

The Canadian Engineering team is looking for an Associate Data Engineer with an interest in designing, developing, implementing, supporting, and analyzing AWS Data pipelines, Data Ingestion and Data Architecture. The successful candidate will have strong technical and problem-solving skills and will show initiative, be accepting of responsibility and be open to learning new skills. This opportunity is available to students with a December 2026 or later graduation date.

Requirements

Reliability Security Clearance
law enforcement inquiry and a credit check
Experience or knowledge of developing solutions for data warehouse loads and system integrations using ETL tools
Experience or knowledge of developing data pipelines using AWS Glue
Experience or knowledge of Python script development using PySpark, Python libraries, configuration driven and object-oriented ETL
Strong knowledge of SQL is essential
Experience or knowledge of CI/CD pipelines and DevOps practices for data engineering workflows
Experience or knowledge of Jenkins for automated build and deployment processes
Familiarity with version control systems such as GitHub or Bitbucket for collaborative development
Experience or knowledge of Generative AI or Agentic AI applications in the data engineering space, including LLM integration for data processing, analysis, or automation
Experience with data modeling concepts and data structure design for supporting high performing read SQLs
Ability to deep dive in existing data integration code to analyze and reverse engineer
Strong analytical skills, including conceptual, requirements interpretation, solution creation and problem-solving abilities
Excellent collaboration and leadership skills and proven ability to adapt to challenges, coaching and mentoring
Ability to work in a global multi-site environment and working in a matrix environment, onshore/offshore IT mode
Ability to lead a team of diverse skill sets and interface with peripheral technical teams
Students with a December 2026 or later graduation date

Nice To Haves

An understanding and/or hands-on experience with Step and Lambda functions will be an asset

Responsibilities

Provide coding and design help on the construction and maintenance of robust and efficient data applications and reusable frameworks
Develop data pipelines in an AWS Cloud environment using Python and AWS Glue (PySpark) technology
Implement and maintain CI/CD pipelines for automated testing and deployment of data solutions
Responsible for coordinating or participating in all aspects of the development cycle from design and development to release planning and implementation of data systems
Deliver solutions according to Systems Development Life Cycle (SDLC) methodology for either waterfall or agile projects
Provide consultation for the evaluation of data and software systems
Develop and manage effective working relationships with other departments, groups or personnel with whom work must be coordinated