Sunlife - Data Engineer

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 motivated Data Engineer with a strong background in SQL, SSIS, and ETL 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 maintain ETL pipelines using SSIS and SQL Server

• Perform data ingestion, extraction, and mapping across multiple systems

• Translate complex business logic into stored procedures and SSIS workflows

• Develop and implement data models to support business requirements

• Create and manage complex business rules and data 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 with SQL Server, SSIS, and ETL development

• Strong understanding of data modeling, data mapping, and data transformation

• Ability to write and optimize stored procedures and data manipulation scripts

• Excellent problem-solving skills and attention to detail

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

• Experience with AWS 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 at www.teemagroup.com