Data Engineer

Overview

Adastra is seeking a hands-on Data Engineer to design, build, and maintain scalable data solutions in a cloud-based environment for a major retail client (Loblaw). This role will focus on developing robust data pipelines, transforming and optimizing large datasets, and leveraging GCP BigQuery to enable reliable analytics and reporting across SAP S/4HANA Cerebro Reporting initiatives.

The ideal candidate has strong SQL and Python expertise, experience working with production-scale data systems, and the ability to collaborate effectively with both technical and business stakeholders to deliver high-quality, scalable data solutions.

Primary Location: Toronto, ON

Work Model: Hybrid 3-Days Onsite

Employment Type: Contractor

Vacancy Status: New

RESPONSIBILITIES

• Design, develop, and maintain scalable and reliable data pipelines
• Write, optimize, and troubleshoot complex SQL queries for large datasets
• Build and manage datasets within GCP BigQuery, including query optimization and performance tuning
• Develop data transformation workflows using Python
• Ensure data quality, integrity, and consistency across systems
• Support data modeling efforts to enable analytics and downstream consumption
• Collaborate with analysts, data scientists, and business stakeholders to translate requirements into technical solutions
• Document data processes, workflows, and system architecture
• Contribute to best practices in data engineering, governance, and performance optimization

QUALIFICATIONS, SKILLS & EXPERIENCE

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field
• 5+ years of hands-on Data Engineering experience
• Strong hands-on experience with SQL (complex joins, aggregations, performance tuning)
• Strong proficiency in Python for data processing, ETL development, and automation
• Experience working within Google Cloud Platform (GCP), specifically BigQuery
• Experience building and maintaining production-grade data pipelines
• Solid understanding of data modeling and large-scale data processing
• Experience working with structured and semi-structured datasets
• Strong analytical and problem-solving abilities
• Excellent communication skills with the ability to collaborate cross-functionally

NICE TO HAVE

• Experience with orchestration tools (e.g., Airflow or similar)
• Experience with dbt or modern data transformation frameworks
• Familiarity with CI/CD practices for data engineering
• Experience working in Agile environments
• Exposure to data governance and data quality frameworks
• Experience supporting machine learning or advanced analytics workloads

ABOUT ADASTRA

Adastra is a global leader in AI and data-driven transformation, helping organizations lead with artificial intelligence—responsibly, strategically, and at scale. With over 25 years of experience, Adastra empowers enterprise clients to unlock business value through data innovation, operational excellence, and smart customer engagement.

Trusted by some of the world’s most prominent brands, Adastra delivers end-to-end solutions grounded in thoughtful strategy, robust governance, and deep technical expertise. From defining vision to ensuring execution, Adastra guides organizations through every stage of their AI, data and cloud journey—building future-ready capabilities and delivering measurable, lasting impact.

Adastra serves clients across key industries including financial services, automotive, manufacturing, technology, media and telecom (TMT), healthcare, retail, and professional services. The company employs more than 2,000 professionals across North America, Europe, and Asia.

WHAT WE OFFER

• Opportunity for advancement and career progression
• Competitive compensation
• Successful referral program
• The opportunity to work with one of Canada's 50 Best Managed Companies 
• Satisfaction of working for a reputable company 
• A flexible, dynamic, and diverse workplace 

EQUAL OPPORTUNITY EMPLOYER

In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights Code.  In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives, encourage diversified labour force participation and equal access to opportunities based on merit and performance.

AI Usage - Our hiring process includes the use of AI-enabled tools to screen applications (e.g., keyword matching, qualification ranking). A human recruiter reviews all AI-generated shortlists to make informed hiring decisions.

There has been an increased instance of fraudulent job offers coming from people posing as Adastra HR employees. Please note that Adastra will never request fees as part of our recruiting process and any emails sent to you that are not from ‘@adastragrp.com’ or ‘@talent.icims.com’ are fraudulent. All employment offers are sent via DocuSign and if you receive an employment offer from a suspicious email and not via DocuSign, it is fraudulent.

Contact careers@adastragrp.com to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers.