Sunlife – Data Engineer

TEEMA; Markham; Hybrid; CAD 75,000 - 105,000; Full time

Job summary

A leading company is seeking a highly skilled Data Engineer to join their team. The role involves designing and implementing ETL pipelines, data modeling, and collaborating with both technical and non-technical stakeholders. Ideal candidates should have experience in SQL, SSIS, and possess strong problem-solving and communication skills.

Qualifications

• Proven experience with SQL Server, SSIS, and ETL development.
• Strong understanding of data modeling, mapping, and transformation.
• Ability to write and optimize stored procedures.

Responsibilities

• Design, develop, and maintain ETL pipelines using SSIS and SQL Server.
• Translate complex business logic into stored procedures and SSIS workflows.
• Collaborate with business stakeholders to deliver actionable data solutions.

Skills

SQL

SSIS

ETL development

data modeling

data mapping

data transformation

problem-solving

communication

Job description

Job Title:Data Engineer
Job ID:81732
Location:Markham, Ontario –Hybrid 1-day onsite
End Client: Sunlife

Overview:
We are seeking a highly skilled and motivatedData Engineerwith a strong background inSQL,SSIS, andETL pipeline development. The ideal candidate will be experienced in designing and implementing robust data solutions, translating business logic into technical workflows, and collaborating effectively with both technical and non-technical stakeholders.

What you will be doing:

• Design, develop, and maintainETL pipelinesusingSSISandSQL Server

• Performdata ingestion, extraction, and mappingacross multiple systems

• Translate complexbusiness logicinto stored procedures and SSIS workflows

• Develop and implementdata modelsto support business requirements

• Create and managecomplex business rulesanddata manipulation logic

• Identify and flag data anomalies and inconsistencies

• Collaborate with business stakeholders to understand requirements and deliver actionable data solutions

• Work independently and take ownership of assigned tasks and deliverables

What you must have:

• Proven experience withSQL Server,SSIS, andETL development

• Strong understanding ofdata modeling,data mapping, anddata transformation

• Ability to write and optimizestored proceduresanddata manipulation scripts

• Excellent problem-solving skills and attention to detail

• Strong communication skills, with experience engaging directly with business users

• Experience withAWS is a plus

• Clearance Requirement: Active Security Clearance required or is eligible for Reliability Security Clearance

For more information about TEEMA and to consider other career opportunities, please visit our website atwww.teemagroup.com