Data Engineer

Adastra; Markham; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A leading consulting company is seeking an experienced ETL Developer for a hybrid role. The successful candidate will be responsible for designing and maintaining ETL processes using SSIS and AWS Glue. This contract position is ideal for someone with extensive experience in data integration and a passion for optimizing data pipelines.

Qualifications

• 5+ years of hands-on experience with SSIS and SQL Stored Procedures.
• 2+ years of experience developing AWS Glue data pipelines.
• Strong SQL and Python programming skills required.

Responsibilities

• Design, develop, and maintain ETL processes using SSIS and AWS Glue.
• Optimize and troubleshoot data pipelines for performance and reliability.
• Conduct unit and system integration testing.

Skills

SSIS

SQL

AWS Glue

Python

Agile methodologies

Problem-solving

Analytical skills

Communication

Documentation

Job description

Overview

We are seeking an experienced ETL Developer with strong expertise in both on-premise and cloud-based data integration. The ideal candidate will have a solid background in SSIS and AWS Glue, with a passion for optimizing data pipelines and modernizing legacy systems.

Location: Hybrid 1-Day onsite

Status: Contract

Responsibilities:

• Design, develop, and maintain ETL processes using SSIS and AWS Glue
• Reverse engineer legacy SQL code and migrate to modern data platforms
• Optimize and troubleshoot data pipelines for performance and reliability
• Apply data modeling and engineering best practices
• Conduct unit and system integration testing
• Document business rules and technical specifications clearly and thoroughly

Qualifications:

• Must have Reliability Clearance or eligible to obtain clearance
• Must have 5+ yearsof hands-on experience with SSIS and SQL Stored Procedures
• Must have 2+ yearsof experience developing AWS Glue data pipelines
• Must have strong SQL and Python programming skills
• Solid understanding of Agile methodologies
• Familiarity with QA processes including unit and integration testing
• Excellent problem-solving and analytical skills
• Strong communication and documentation abilities
• Ability to work independently and collaboratively in a fast-paced environment

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

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