Join us in building Careers and shaping Experiences Beyond the Box
About Us
At Atlantic Packaging, every box tells a story and yours begins here. As a proudly Canadian‑owned company with over 80 years of excellence in the corrugated packaging industry with operations within North America (Ontario, Quebec and United States), we’re committed to sustainability, customer excellence and community impact. Since 1945, we’ve supported local jobs and built a legacy of trust with our clients and team members. At Atlantic, your ideas matter, your growth is supported and your work makes a real impact.

Opportunity
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.

Location: Scarborough, Ontario (currently hybrid, 3 days in office)

What You’ll Do
ETL Development & Data Pipelines (Core Focus)

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

SQL Development & Data Processing

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

Data Warehousing & Modeling

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

Data Quality, Reliability & Operations

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

Data Governance & Security

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

Collaboration & Delivery

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

Engineering Practices

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 workplace

What You’ll Bring
Education & Experience

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

7+ years of experience in data engineering, ETL development, or data warehouse development

Core Technical Skills (Must-Have)

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

Data Warehousing & Modeling

Strong understanding of data warehousing concepts and dimensional modeling

Experience designing and maintaining fact and dimension tables





Performance & Optimization

Experience with query optimization, indexing, partitioning, and large-scale data processing

Ability to troubleshoot and resolve performance bottlenecks in ETL and SQL workloads

Governance & Best Practices

Understanding of data quality, data governance, and data security principles

Experience implementing logging, validation, and monitoring in ETL workflows

Tools & Technologies

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 Have

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

What We Offer

Comprehensive health, dental and vision coverage (dependents included)

Teamwork-focused culture with sustainability initiatives and social events

A culture of appreciation through a point-based recognition

Opportunities for advancement and internal movement

Education assistance for continuous skill development

Academic scholarships for employees’ children

Safety equipment and PPE support program

Retirement savings and wellness initiatives

Employee Assistance Program (EAP)

Inclusion and Accessibility
Atlantic Packaging is committed to fostering an inclusive, accessible and respectful environment for all candidates. If you require accommodation during the hiring process, please contact our Talent Acquisition team—we’re here to support you.

Candidates who are 18 years or older are required to complete a criminal and background check. Details will be provided through the application process.

We sincerely thank all applicants for their interest in joining Atlantic Packaging. While we appreciate the time and effort invested, only those selected for an interview will be contacted.

Hiring Range: $93,300 - $116,600 per year. A candidate’s experience and knowledge may be factored into the pay a candidate receives for this position. This posting is for an existing vacancy.

#J-18808-Ljbffr

📌 Senior Data Engineer (Ontario)
🏢 Atlantic Packaging Products
📍 Ontario