Data Warehouse Software Developer II

We are seeking a detail-oriented Data Warehouse Software Developer II to support and enhance an enterprise-level Data Warehouse environment. In this role, you will be responsible for maintaining robust data pipelines, ensuring strict data integrity, and developing scalable solutions on modern cloud data platforms.

You will balance operational support—monitoring and troubleshooting automated processing workflows—with hands-on engineering, writing complex database routines, and expanding data integration capabilities in the cloud.

Advantages
Modern Cloud Stack: Gain deep hands-on experience leveraging top-tier platforms like Snowflake and Azure Data Factory.

High-Impact Growth: Perform a vital dual role combining data operations, root-cause troubleshooting, and new pipeline development.

Strong Extension Potential: Long-term assignment covering a parental leave with a high likelihood of extension.

Collaborative Team: Work alongside dedicated engineers in an environment prioritizing continuous improvement and modern CI/CD practices.

Responsibilities
Operational & Support Tasks
- Job Monitoring: Monitor daily and weekly automated data processing jobs to ensure smooth and successful execution.

- Routine Processing: Execute scheduled business procedures related to data processing and enterprise reporting.

- Data Quality: Validate data accuracy and completeness across various interconnected systems.

- Troubleshooting: Investigate and diagnose failed processing jobs, perform root cause analysis, and implement permanent bug fixes.

- Data Integrity: Maintain ongoing data accuracy and reliability within the core data warehouse environment.

Development & Enhancement
- Database Engineering: Design, develop, and maintain stored procedures using SQL and Snowflake (including Python-based logic).

- Pipeline Automation: Build and enhance Azure Data Factory (ADF) pipelines for data integration and transformation.

- Template & Release Management: Update and manage Azure pipeline templates while supporting deployments for ADF and Azure Synapse projects using Azure DevOps and Git.

- Application Maintenance: Maintain and improve in-house support applications built with Python and Java.

Qualifications
Must-Have Qualifications:
- Technical Support & Operations: Demonstrated experience troubleshooting data pipeline failures, root-cause analysis, and job monitoring.

- Core Database & Cloud Data: Strong proficiency with SQL and Snowflake database environments.

- Programming Languages: Solid hands-on development experience using Python and Java.

- Azure Cloud Suite: Hands-on experience with Azure Data Factory (ADF), Azure Synapse Analytics, and Azure Functions.

- CI/CD & Version Control: Familiarity with Azure DevOps and Git for version control and deployment pipelines.

- Language Skills: Fluent English (written and spoken).

Summary
If you are an Intermediate Data Warehouse Developer with strong SQL, Python, and Azure skills who thrives on both solving complex technical data issues and building scalable pipelines, apply today! Bring your expertise to a dynamic cloud environment and make an immediate impact.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.