Senior Data Engineer

Atlantic Packaging Products Ltd.•Toronto, ON

2h•CA$93,300 - CA$116,600•Hybrid

About The Position

We are seeking a Senior Data Engineer with strong expertise in SQL Server and SSIS to join our Data & Analytics team. This role is central to designing, building, and maintaining enterprise data pipelines and data warehouse solutions. The successful applicant will ultimately be responsible for developing and administrating Databases across the organization, helping us build the data lake and transforming raw data from multiple source systems to create an Enterprise Datawarehouse and Data Lake. The Data Engineer would lead the efforts to help consolidate data via various sources to enable a robust reporting environment.

Requirements

Bachelor’s degree in Computer Science, Engineering, or a related field
7+ years of experience in data engineering, ETL development, or data warehouse development
Strong expertise in SQL Server, including advanced SQL development
Hands-on experience with SQL Server Integration Services (SSIS) for building ETL pipelines
Experience developing stored procedures, complex queries, and performance tuning
Deep understanding of ETL/ELT processes and data pipeline architecture
Strong understanding of data warehousing concepts and dimensional modeling
Experience designing and maintaining fact and dimension tables
Experience with query optimization, indexing, partitioning, and large-scale data processing
Ability to troubleshoot and resolve performance bottlenecks in ETL and SQL workloads
Understanding of data quality, data governance, and data security principles
Experience implementing logging, validation, and monitoring in ETL workflows
Experience with SQL Server ecosystem (SSIS, SSRS is a plus)
Familiarity with version control (Git)
Exposure to cloud platforms (Azure/AWS) or data lake environments is an asset

Nice To Haves

Experience with Power BI or other reporting tools
Exposure to modern data engineering tools (e.g., Azure Data Factory, Databricks)
Experience in manufacturing, supply chain, or logistics environments
French language skills are an asset

Responsibilities

Design, develop, and maintain ETL pipelines using SQL Server Integration Services (SSIS)
Build and optimize data ingestion and transformation workflows from multiple source systems
Ensure efficient, scalable, and reliable data movement across the enterprise data platform
Analyze and improve existing ETL processes for performance, scalability, and maintainability
Develop complex SQL queries, stored procedures, and scripts to support data processing and transformation
Perform query optimization, indexing, and performance tuning on large datasets
Ensure data integrity, accuracy, and consistency across systems
Design and implement data warehouse solutions using SQL Server
Develop and maintain dimensional data models (fact/dimension, star schema) to support reporting and analytics
Support the evolution of the enterprise data warehouse and data lake environment
Implement data validation, error handling, and logging within ETL processes
Monitor and troubleshoot ETL jobs, identifying and resolving failures and performance issues
Ensure data is delivered accurately and on time to downstream systems
Support data governance practices including data access controls, security, and compliance
Evaluate and improve authentication, authorization, and data protection mechanisms
Contribute to data documentation, lineage, and auditability
Work with business stakeholders and analysts to translate requirements into technical solutions
Deliver high-quality, structured datasets to support reporting tools such as Power BI
Participate in planning, estimation, and prioritization of data engineering work
Maintain and improve technical documentation for ETL processes, data models, and systems
Use version control (Git) to manage code and changes
Identify opportunities to improve tools, frameworks, and processes within the data environment