RQ11487 – Software Developer – ETL – Senior

Client: Ministry of Public and Business Service Delivery and Procurement – RQ11487

We are seeking a highly experienced Senior Software Developer – ETL with strong expertise in Azure data technologies, data engineering, ETL development, Microsoft Fabric, Azure Databricks, PySpark, and Power BI. The ideal candidate will have hands-on experience designing and developing scalable data pipelines, transforming raw data into structured Silver and Gold layers, building semantic models, and developing high-performance Power BI reports and dashboards. The successful candidate will support enterprise data architecture, business intelligence, data integration, and analytical reporting initiatives while ensuring data accuracy, reliability, security, and performance.

Role Snapshot

• Job Title: RQ11487 – Software Developer – ETL – Senior

• Client: Ministry of Public and Business Service Delivery and Procurement

• Work Location: 40 St. Clair Avenue West, Toronto, Ontario, Canada

• Work Arrangement: Onsite – 5 Days per Week

• Estimated Start Date: October 5, 2026

• Estimated End Date: March 31, 2027

• Business Days: 123.00

• Extension: 60.00

• Hours: 7.25 hours per day

• Working Schedule: Monday to Friday, between 8:00 AM and 5:00 PM, excluding lunch breaks

• Security Level: No Clearance Required

Must Have

• 6+ years of experience with Azure technologies, including:

  • Azure Databricks

  • Azure Data Lake Gen 2

  • Power BI development and semantic modelling

  • Azure DevOps CI/CD

  • PySpark

  • Microsoft Fabric

  • Star Schema or Snowflake data modelling experience

Orchestration & Ingestion:

• Proficiency in using Data Factory within Microsoft Fabric to build complex and scalable data pipelines.

Business Intelligence:

• Experience designing efficient Direct Lake semantic models in Power BI using Silver/Gold layer models to ensure high-speed reporting directly from OneLake.

• Experience using semantic models to design and develop Power BI reports and dashboards.

• Ability to develop operational and analytical Power BI reports and paginated reports.

Description

To respond to the priorities of the Government of Ontario through the passage of Bill 5, Protect Ontario by Unleashing Our Economy Act, 2025, the resource may be partially assigned to Bill 5-related projects or initiatives on an as-needed basis.

Responsibilities

The successful candidate will be responsible for the following:

• Analyse data and design semantic models.

• Transform raw data into Silver/Gold data for reporting consumption.

• Design, develop, release, and deploy Power BI reports and dashboards that meet KPIs, including accuracy, reliability, and performance.

• Review business requirements and related materials to use as input for the design and development of reports.

• Design technical system specifications and translate them into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining applications, and conducting unit tests.

• Resolve and troubleshoot technical problems that arise during the use and operation of software packages, including providing technical assistance with implementation, conversion, and migrations.

• Provide specialized skills for developing data access queries.

• Work in conjunction with data analysts to develop dashboards and other end-user reporting products.

• Support the client's wide-ranging business information requirements by implementing and supporting OLAP analytical software solutions.

• Develop and support customized query applications that analyse key business data.

Desirable Skills and Experience

• Experience with Azure Data Factory (ADF) v2.

• Data Architecture & Engineering: Competency in building Lakehouses and Warehouses, writing optimized PySpark or SQL pipelines, and implementing Medallion Architecture (Bronze/Silver/Gold layers).

• Data Governance: Experience with data security, including row-level and column-level security, and data lineage tracking.

Experience and Skill Set Requirements

The candidate will be evaluated based on the following experience and skill categories:

1. Mandatory Skills and Experience — 70%

• 6+ years of experience with Azure technologies, including Azure Databricks, Azure Data Lake Gen 2, Power BI development and semantic modelling, Azure DevOps CI/CD, PySpark, and Microsoft Fabric.

• Experience with Star Schema or Snowflake data modelling.

• Proficiency in using Data Factory within Microsoft Fabric to build complex and scalable data pipelines.

• Experience designing efficient Direct Lake semantic models in Power BI using Silver/Gold layer models for high-speed reporting directly from OneLake.

• Experience using semantic models to design and develop Power BI reports and dashboards.

• Experience developing operational and analytical Power BI reports and paginated reports.

2. Desirable Skills and Experience — 25%

• Experience with Azure Data Factory (ADF) v2.

• Competency in building Lakehouses and Warehouses.

• Experience writing optimized PySpark or SQL pipelines.

• Experience implementing Medallion Architecture, including Bronze, Silver, and Gold layers.

• Knowledge of data security, including row-level and column-level security.

• Experience with data lineage tracking.

3. Education — 3%

• Education-related qualifications and experience as applicable to the role requirements.

4. Public Sector Experience — 2%

• Public sector experience relevant to the assignment and the Government of Ontario's business and information requirements.

How to Apply

If you are interested and your profile matches the requirements, kindly send the following mandatory documents to [email protected] by Tuesday, November 10, 2026, at 9:00 AM EST.

Mandatory Documents:

1. Updated Resume in Word format (Mandatory)

2. References (Mandatory)

3. Expected Hourly Rate (Mandatory)

4. Visa Status (Mandatory)

5. LinkedIn ID (Mandatory)

Without the mandatory documents, we cannot submit a candidate.

WhatsApp Group

For daily job updates, you can also join our WhatsApp group using the link below:

Join our WhatsApp Group

Additional Information

Work Arrangement and Working Hours

This position is listed as Onsite, unless otherwise instructed by the Client. The resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00 AM and 5:00 PM, excluding lunch breaks, every Monday to Friday inclusive, at the identified Ontario Public Service (OPS) office location.

• Onsite Requirement: 5 days per week.

Email is the best way to reach us.

You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.