PowerBI Developer, ETL, Azure, Databricks, SQL

Software Developer - ETL (Intermediate) / Power BI Developer

Client: Government Services Integration Cluster (GSIC)- RQ11676

Ministry: Ministry of Public and Business Service Delivery and Procurement

Rate: $70-75

Location: Toronto, ON

Work Model: 100% Onsite

Contract: Till March 31, 2027, can extend

The Government of Ontario is seeking an experienced Software Developer - ETL/Power BI Developer to support the Ontario Data Platform (ODP), a large-scale Data & AI transformation initiative. The successful candidate will develop enterprise-grade Power BI dashboards, reporting solutions, and data models while collaborating with business stakeholders, data engineers, and architects to deliver impactful analytics and insights.

Key Responsibilities

• Develop, enhance, and maintain Power BI dashboards, reports, and semantic models.
• Create DAX calculations, data models, and Power Query transformations.
• Integrate data from databases, APIs, cloud platforms, and data warehouses.
• Support data validation, reconciliation, testing, and reporting accuracy.
• Implement report security, governance standards, and Row-Level Security (RLS).
• Optimize report performance, refresh schedules, and workspace management.
• Collaborate with business users and technical teams to deliver reporting solutions.
• Maintain documentation, data lineage, and reporting standards.

Must-Have Skills

• Degree or Diploma in Computer Science, Information Systems, Data Analytics, Business Intelligence, or a related field.
• Strong experience developing dashboards, reports, and visualizations using Microsoft Power BI.
• Expertise in DAX, Power Query (M), Data Modeling, and Semantic Models.
• Experience with SQL and relational databases.
• Strong understanding of data warehousing, dimensional modeling, and star schema design.
• Experience transforming complex business requirements into reporting and analytics solutions.
• Knowledge of data governance, metadata management, and data lineage concepts.
• Experience working with large datasets and enterprise reporting environments.
• Strong analytical, problem-solving, communication, and stakeholder management skills.

Nice-to-Have Skills

• Experience with Databricks, including Databricks SQL Warehouses and Lakehouse architectures.
• Familiarity with Azure Data Platform services such as:
• Azure Data Lake Storage (ADLS)
• Azure Synapse Analytics
• Azure Data Factory (ADF)
• Microsoft Fabric
• Experience with enterprise data governance and data quality initiatives.
• Knowledge of Python, R, or other analytics tools.
• Experience supporting large public-sector or enterprise analytics platforms.
• Exposure to Agile, DevOps, and modern data delivery practices.

Note: AI-enabled tools may be used to sort applications based on job-related criteria. All AI generated results are vetted by our team and the decision of which candidates move forward is always made by a human.