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.
