To respond to the priorities of the Government of Ontario through the passage of the 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.

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-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.

Responsibilities

Analyze data and design semantic models

Transform raw data into silver/gold data for reporting consumption.

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

Review business requirements (and related materials) to use as input for design/development of reports

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

Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Provide specialized skills for developing data access queries

Works in conjunction with data analysts for developing dashboards and other end user reporting products

Supports Client’s wide-ranging business information requirements, implementing and supporting OLAP analytical software solutions

Develops and supports customized query applications which analyze key business data

Experience Requirements Following are the evaluation criteria along with the evaluation % weightage.

Evaluation Criteria

Evaluation % Weightage

Mandatory Skills and Experience

70%

Desirable Skills and Experience

25%

Education

3%

Public Sector Experience





2%

TOTAL

100%

Mandatory Skills and Experience

6+ years experience as Azure technologies including

Azure Databricks

Azure DataLake Gen 2.

Power BI development and semantic modeling

Azure DevOps CI/CD

PySpark

Microsoft Fabric

Star Schema or Snowflake data modeling experience

Orchestration & Ingestion:

Proficiency using Data Factory within Fabric to build complex, scalable data pipelines.

Business Intelligence:

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

Use of semantic models to design and develop Power BI reports and dashboards. Develop operational and analytical PowerBI reports/paginated reports.

Desirable Skills and Experience

Experience in 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:

Data security (row-level/column-level), and data lineage tracking.

Supplier Comments Req Closing Date/Time 2026-11-10, 11:00 a.m.

Max number of candidate submission – 1(one)

Candidate is required to come in office 5 days a week

Must haves:

?6+ years experience as Azure technologies including

Azure Databricks

Azure DataLake Gen 2.

Power BI development and semantic modeling

Azure DevOps CI/CD

PySpark

Microsoft Fabric

Star Schema or Snowflake data modeling experience

Orchestration & Ingestion:

Proficiency using Data Factory within Fabric to build complex, scalable data pipelines.

Business Intelligence:

Designing productive Direct Lake semantic models in Power BI using Silver/Gold layer models to ensure high-speed reporting directly from OneLake.

Use of semantic models to design and develop Power BI reports and dashboards. Develop operational and analytical PowerBI reports/paginated reports.

#J-18808-Ljbffr

📌 Software Developer – ETL (Toronto)
🏢 Softline Technology
📍 Toronto