Senior Data Engineer
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
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 environment
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
