RQ09315 - Software Developer - ETL Senior
Closing Date - 2025-05-30, 9:00 a.m.
Hybrid - Candidate MUST work 3 days onsite and 2 days remote
Start Date - 2025-06-23 to 2026-04-02
Office Location - Ministry of Public and Business Service Delivery and Procurement 5700 Yonge Street, 10th Floor Toronto, Ontario
Rate - CAD$80/hr
Title
Software Developer - ETL
Description
NOTE
Assignment Type: This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager.
Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW.
===============================================================
Responsibilities:
We are seeking a highly skilled Software Developer with ETL implementation experience to join our data engineering team. This role is critical in ensuring the accuracy, reliability, and performance of our data pipelines and analytics infrastructure built on the Microsoft Azure platform and Databricks. Under the supervision of the IT QA Lead, you will collaborate closely with data engineers and DevOps teams to design and implement robust data quality frameworks, automated testing pipelines, and CI/CD processes.
Design and implement comprehensive test plans for data pipelines and transformations in a Microsoft Azure + Databricks and Power BI technology stack.
Conduct data quality assessments, validation, and profiling using tools like Great Expectations.
Develop and maintain automated testing frameworks integrated into CI/CD pipelines.
Collaborate with data engineers to ensure adherence to Medallion Architecture best practices.
Monitor and assess pipeline performance, scalability, and data integrity.
Implement and manage DevOps practices using Azure DevOps, Git, and related tools.
Document test cases, validation rules, and QA processes clearly and consistently.
Perform functional testing on Power BI Reports and dashboards
Participate in Agile ceremonies and contribute to sprint planning and retrospectives.
Skills
Experience and Skill Set Requirements
| Public Sector Experience | 5+ years of experience working in the federal/provincial/broader public-sector as a software developer / data specialist / quality assurance tester | 5 points |
| Core ETL Development Skill & Experience | 5+ years of experience in data engineering: Must have demonstrated expertise in designing and implementing comprehensive data pipelines and transformations in a Microsoft Azure + Databricks and Power BI technology stack. Must have strong knowledge and hands-on experience with: Microsoft Azure Data Services (ADF, ADLS Gen 2, Synapse, Azure SQL) Azure Databricks PySpark and SQL Power BI (data preparation, modelling, and visualization) Must have demonstrated experience in developing and maintaining data pipelines and release management through Continuous Integration and Continuous Delivery (CI/CD) and DevOps practices using Azure DevOps, Git, Visual Studio Code, and related tools. Demonstrated experience in collaborating with data engineers to ensure adherence to Medallion Architecture best practices (Staging, Bronze, Silver, Gold layers), Certifications (preferred but not required): - Microsoft Certified: Azure Data Engineer Associate - Databricks Certified Data Engineer Associate/Professional - Microsoft Certified: Fabric Analytics Engineer Associate - Microsoft Certified: Power BI Data Analyst Associate Microsoft Certified: DevOps Engineer | 75 points |
| Quality Assurance Skill & Experience | 5+ years of experience in quality assurance and automated testing: Must have experience conducting software quality functional assessments, systems testing, performance evaluation, automated testing, using a variety of tools such as: Conducting data quality assessments, validation, and profiling using tools like Great Expectations Developing and maintaining automated testing frameworks integrated into CI/CD pipelines and DevOps practices using Azure DevOps, Git, Visual Studio Code, and related tools. Certifications (preferred but not required): - Certified Software Tester (CSTE) - Certified Tester Test Automation Engineer. | 20 points |
-
MUST HAVES:
5+ years of experience in data engineering:
Must have demonstrated expertise in designing and implementing comprehensive data pipelines and transformations in a Microsoft Azure + Databricks and Power BI technology stack.
Must have strong knowledge and hands-on experience with:
Microsoft Azure Data Services (ADF, ADLS Gen 2, Synapse, Azure SQL)
Azure Databricks
PySpark and SQL
Power BI (data preparation, modelling, and visualization)
Must have demonstrated experience in developing and maintaining data pipelines and release management through Continuous Integration and Continuous Delivery (CI/CD) and DevOps practices using Azure DevOps, Git, Visual Studio Code, and related tools
Must have experience conducting software quality functional assessments, systems testing, performance evaluation, automated testing, using a variety of tools such as:
- JIRA or Azure DevOps for defect tracking,
- Selenium for automated testing of web-based apps, including Power BI reports and dashboards,
- JMeter for performance evaluation.
Conducting data quality assessments, validation, and profiling using tools like Great Expectations
Developing and maintaining automated testing frameworks integrated into CI/CD pipelines and DevOps practices using Azure DevOps, Git, Visual Studio Code, and related tools.
...new professionals from around the world to work as counselors, mentors, instructors and... ...A summer at Ramapo acts as an internship experience for many of our staff. We are happy to work... ...in the fields of Education, Psychology, Social Work, and Human Services with the...
...Previous experience in merchandising is preferred Understanding best practices in customer service and sales Must have a valid Drivers License with a minimum of 5 years driving experience, clean driving record with no moving violations over the past 3 years. No...
...We are in need of a resource that can help manage the accounting needs of the company. Ideal candidate will come in three to four days on a weekly basis for the months of July and August, and one to two days per week from September onwards. REQUIREMENTS: At...
Join to apply for the Sports Executive Producer role at Nexstar Media Group, Inc. KOIN 6 TV/Portlands CW, a Nexstar Media Inc. owned... ...principles of localism, diversity and trustworthy, unbiased broadcast journalism. At the same time, the company continues to simultaneously...
Microsoft Dynamics CRM Testing, QXNT, .Net Testing Full-timeSonsoft, Inc. is a USA-based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. specializes in Software Development, Software Consultancy, and Information Technology Enabled...