Intermediate Software Developer

Intermediate Software Developer ETL

Location:

Toronto, Ontario

Employment Type:

Contract

Contract Duration:

133 days + 133 days

Hourly Rate:

CAD $40 - $45 Inc

Work Arrangement:

Onsite 5 days per week

Role Overview

The Government of Ontario is undertaking a large-scale Data & AI transformation initiative, with the Ontario Data Platform (ODP) serving as the enterprise technology ecosystem for data-driven decision-making, analytics, and artificial intelligence.

ODP provides a modern and scalable data environment that supports data ingestion, storage, processing, governance, quality, marketplace capabilities, and advanced analytics across ministries and government organizations.

We are seeking a Power BI Developer to support the development, maintenance, and enhancement of enterprise reporting and analytics solutions. The successful candidate will work closely with business stakeholders, data engineers, architects, and product teams to deliver insightful dashboards, reports, and data visualizations that enable evidence-based decision-making across government programs and services.

Key Responsibilities Power BI Development & Reporting

Design, develop, and maintain interactive Power BI dashboards and reports to support business and operational needs.

Create data models, measures, and calculations using DAX to deliver meaningful business insights.

Implement data visualization best practices to ensure reports are intuitive, accessible, and actionable.

Gather and analyze business requirements and translate them into reporting solutions.

Develop and maintain enterprise semantic models, datasets, and reusable reporting assets that support standardized analytics and reporting.

Data Integration & Analytics Support

Connect and integrate data from various enterprise data sources, including databases, APIs, cloud platforms, and data warehouses.

Develop and optimize Power Query (M) transformations for efficient data preparation and reporting.

Collaborate with data engineering teams to ensure data quality, governance, and consistency across reporting solutions.

Support ad hoc data analysis and reporting requests from business stakeholders.

Perform data validation, reconciliation, and user acceptance testing (UAT) activities to ensure reporting accuracy and integrity.

Performance, Governance & Support...