Data Engineer

Overview

Adastra is seeking a hands‑on Data Engineer to design, build, and maintain scalable data solutions in a cloud‑based environment. This role will focus on developing robust data pipelines, transforming and optimizing large datasets, and leveraging GCP Big Query to enable reliable analytics and reporting across the organization. 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.

Location: Brampton, ON (Hybrid 3‑Day/week)

Status: Contract

• 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 Big Query, 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

• 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 Big Query
• 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

• 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

For more than 25 years, Adastra Corporation has been hyper‑focused on data and the infrastructures to support it. We are an international consulting company working with businesses and IT leaders to extract value through data and analytic solutions in the domains of Cloud, Data Management, Analytics, AI and ML, Governance, Hyper Automation, and Enterprise Application Development. Our team of experts, combined with our world‑class data management platform, helps provide trusted insights, establish frameworks, enforce best practices, and streamline processes for around‑the‑clock global coverage.

Adastra has a proven track record of helping organizations of all sizes – from SMEs to Fortune 1000s – achieve their data transformation goals, whether that be accelerating innovation, improving operational excellence, or creating unforgettable customer experiences.

• 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

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.