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

We’re an equal opportunity employer committed to increasing diversity and inclusion in today’s workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Minorities, women, LGBTQ candidates, and individuals with disabilities are encouraged to apply. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions.