Sunlife – Data Engineer
- Markham, ON
- Contract
- Full-time
Job ID: 81732
Location: Markham, Ontario – Hybrid 1-day onsite
End Client: SunlifeOverview:
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 ServerPerform data ingestion, extraction, and mapping across multiple systemsTranslate complex business logic into stored procedures and SSIS workflowsDevelop and implement data models to support business requirementsCreate and manage complex business rules and data manipulation logicIdentify and flag data anomalies and inconsistenciesCollaborate with business stakeholders to understand requirements and deliver actionable data solutionsWork independently and take ownership of assigned tasks and deliverablesWhat you must have:Proven experience with SQL Server, SSIS, and ETL developmentStrong understanding of data modeling, data mapping, and data transformationAbility to write and optimize stored procedures and data manipulation scriptsExcellent problem-solving skills and attention to detailStrong communication skills, with experience engaging directly with business usersExperience with AWS is a plusClearance Requirement: Active Security Clearance required or is eligible for Reliability Security ClearanceFor more information about TEEMA and to consider other career opportunities, please visit our website at