Job Description

Our leading retail client is seeking a Full Stack ETL Developer with strong experience in React, Node.js, SQL, and SSIS to join their team on a 6 month term, with high likelihood for extension. This is a hybrid role based in Mississauga, ON. 

This role will be primarily focused on ETL development (80%) using SSIS and Microsoft SQL Server, with a secondary focus (20%) on web application development using React and Node.js.

You’ll be hands-on in designing and maintaining robust data integration pipelines and supporting scalable, modern web applications. In addition to development work, you’ll play a key role in architectural discussions, process improvement initiatives, and team collaboration.

Key Responsibilities:

• Design, build, and maintain ETL pipelines using SSIS (Visual Studio 2019) to manage data movement between various systems.

• Develop and optimize complex SQL queries and stored procedures for reporting and data operations in Microsoft SQL Server.

• Contribute to the development of web-based applications using React v18 for the frontend and Node.js v18 with the Express framework for the backend.

• Troubleshoot and resolve issues in ETL workflows and web applications.

• Collaborate in solution design, offering technical recommendations for scalable and efficient architecture.

• Promote code quality, CI/CD practices, and technical documentation, including system design, data flows, and user guides.

• Engage with stakeholders and cross-functional teams to ensure requirements are well-understood and delivered effectively.

• Actively participate in problem-solving and contribute innovative ideas that drive continuous improvement.

Skills & Experience:

ETL / Data Integration (3–5 years):

• Proven experience developing with SSIS, ideally in Visual Studio 2022.

• Ability to build and troubleshoot complex SSIS packages.

• Familiarity with C# scripting within SSIS components.

SQL Development:

• Strong command of SQL, including writing and optimizing complex queries.

• Expertise in developing and managing stored procedures.

Web Development (3–5 years):

Backend:

• Proficiency in Node.js v20, including experience with the Express framework.

• Exposure to NestJS is a plus.

Frontend:

• Hands-on experience with React v18, particularly with React Hooks for modern component design