Senior Data Engineer: ETL & Data Warehouse Architect

Atlantic Packaging Products Ltd.; Toronto; On-site; CAD 93,000 - 117,000; Full time

Benefits offered by this job

Comprehensive health, dental and vision coverage

Education assistance for continuous skill development

Retirement savings and wellness initiatives

Job summary

Atlantic Packaging Products Ltd. based in Ontario is seeking a Senior Data Engineer to design and maintain enterprise data pipelines and data warehouse solutions. In this hybrid role, the candidate will work closely with the Data & Analytics team to transform raw data and ensure data integrity, accuracy, and accessibility.

Applicants should possess a Bachelor’s degree in a relevant field and 7+ years of experience in data engineering. The position provides a competitive salary range of $93,300 - $116,600 annually.

Qualifications

• 7+ years of experience in data engineering, ETL development, or data warehouse development.
• Strong expertise in SQL Server, including advanced SQL development.
• Experience with SQL Server Integration Services (SSIS) for building ETL pipelines.

Responsibilities

• Design, develop, and maintain ETL pipelines using SQL Server Integration Services (SSIS).
• Develop complex SQL queries, stored procedures, and scripts to support data processing.
• Monitor and troubleshoot ETL jobs, identifying and resolving failures and performance issues.

Skills

SQL Server

SSIS

Data Warehousing

ETL Development

Performance Tuning

Data Governance

Education

Bachelor’s degree in Computer Science, Engineering, or a related field

Tools

Azure

AWS

Git

Power BI

Job description

Atlantic Packaging Products Ltd. based in Ontario is seeking a Senior Data Engineer to design and maintain enterprise data pipelines and data warehouse solutions. In this hybrid role, the candidate will work closely with the Data & Analytics team to transform raw data and ensure data integrity, accuracy, and accessibility.

Applicants should possess a Bachelor’s degree in a relevant field and 7+ years of experience in data engineering. The position provides a competitive salary range of $93,300 - $116,600 annually.