Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

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.

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.

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).
Familiarity with version control (Git).
Exposure to cloud platforms (Azure/AWS) or data lake environments is an asset.
Experience with Power BI or other reporting tools is a plus.
Exposure to modern data engineering tools (e.g., Azure Data Factory, Databricks) is a plus.
Experience in manufacturing, supply chain, or logistics environments is a plus.
French language skills are an asset.

Skills

SQL Server (advanced development)
SQL Server Integration Services (SSIS)
ETL/ELT processes
Data pipeline architecture
Data warehousing concepts
Dimensional modeling
Fact and dimension table design
Query optimization
Indexing
Partitioning
Large-scale data processing
Data quality
Data governance
Data security
Logging, validation, and monitoring in ETL workflows
SQL Server ecosystem (SSRS is a plus)
Version control (Git)
Cloud platforms (Azure/AWS)
Data lake environments
Power BI
Reporting tools
Azure Data Factory
Databricks
French language

Location

Scarborough, Ontario
Hybrid (3 days in office)

Work Type

Hybrid
Full-time

Experience Level

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

Education Level

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

Salary/Compensations

$93,300 - $116,600 per year

Benefits

Comprehensive health, dental, and vision coverage (dependents included)
Teamwork-focused culture with sustainability initiatives and social events
Point-based recognition program
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)

About the Company

Atlantic Packaging is a Canadian-owned company with over 80 years of excellence in the corrugated packaging industry.
Operations across North America (Ontario, Quebec, United States).
Committed to sustainability, customer excellence, and community impact.
Supported local jobs and built a legacy of trust since 1945.
Values employee ideas, growth, and impact.

Equal Opportunity

Atlantic Packaging is committed to fostering an inclusive, accessible, and respectful environment for all candidates.
Accommodation during the hiring process is available upon request.