Data Engineer (SSIS & AWS)
Share
Job Location:
Monthly Salary:
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Overview
Adastra is 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.
Please note: This role requires an active Reliability Status (PSPC) or the ability to obtain one. Candidates who already hold Reliability Clearance will be prioritized.
Primary Location: Toronto ON
Work Model: Hybrid 1-Day Onsite (per month)
Employment Type: Contractor
Vacancy Status: New
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 SKILLS & EXPERIENCE
- 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
Adastra is a global leader in AI and data-driven transformation helping organizations lead with artificial intelligenceresponsibly 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 worlds 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 journeybuilding 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 2000 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 Canadas 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 Corporations 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 @ 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.
Required Experience:
IC
