Description

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

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.

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