Teradata Data Engineer

Adastra is seeking an experienced Data Engineer to support enterprise data warehousing initiatives within a structured, large-scale environment. This role will focus on developing, optimizing, and maintaining data warehouse solutions, with a strong emphasis on SQL development and Teradata utilities. The ideal candidate brings solid data engineering experience, strong communication skills, and the ability to collaborate effectively across technical and business teams. Finance industry experience is considered an asset.

Location: Brampton, Ontario (Hybrid 3-Day/week) 

Status: Contract

Responsibilities

• Design, develop, and maintain data warehouse solutions to support reporting and analytics
• Write and optimize complex SQL queries for large-scale datasets
• Utilize Teradata utilities (BTEQ, MLOAD, FastLoad, etc.) for data ingestion and batch processing
• Develop and maintain ETL workflows to ensure accurate and timely data delivery
• Support data validation, quality checks, and performance tuning within the data warehouse
• Collaborate with business stakeholders, analysts, and technical teams to gather requirements and translate them into scalable solutions
• Troubleshoot and resolve data-related issues in production environments
• Document technical processes, workflows, and data definitions

Qualifications, Skills & Experience

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field
• 5+ years of hands-on experience in Data Engineering
• Strong SQL development skills, including complex joins, aggregations, and query optimization
• Strong experience working with Teradata utilities (BTEQ, MLOAD, FastLoad, etc.)
• Solid experience working within Data Warehouse (DWH) environments
• Experience building and maintaining ETL processes in production environments
• Strong understanding of data modeling concepts and structured data systems
• Excellent communication skills with the ability to work cross-functionally

Nice to Have

• Experience within the finance or banking industry
• Exposure to large enterprise data platforms
• Familiarity with data governance and regulatory data environments
• Experience working in agile delivery environments

About Adastra

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 work 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 worldclass 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.

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.

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 '' or '' 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 to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers.