Software Developer - Etl

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 RequirementsFollowing are the evaluation criteria along with the evaluation % weightage.
Evaluation Criteria
Evaluation % Weightage
MandatorySkills and Experience
70%
DesirableSkills and Experience
25%
Education
3%
PublicSector 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 CommentsReq 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 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.
#J-18808-Ljbffr