Senior Data Engineer

Join us inbuilding 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) were committed to sustainability customer excellence and community impact. Since 1945 weve 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.

The 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 Youll 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 environment

What Youll Bring

Education & Experience

• Bachelors 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 teamwere here to support you.

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.

Please note

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

Hiring Range: $93300 - $116600 per year. A candidates experience and knowledge may be factored into the pay a candidate receives for this position. This posting is for an existing vacancy.

Required Experience:

Senior IC