Intermediate Power BI Developer ETL

Build enterprise Power BI reporting solutions onsite in Toronto using DAX, Power Query, SQL, and advanced data modelling expertise. Support Ontario’s Data and AI transformation.

As an Intermediate Software Developer focused on ETL and Power BI, you will develop dashboards, reports, semantic models, and visualizations. The Ministry of Public and Business Service Delivery and Procurement needs reliable analytics supporting government programs and services. You will work with large datasets and complex business requirements.

Key Responsibilities:

• Design and maintain interactive Power BI dashboards and reports
• Create DAX measures, calculations, and enterprise semantic models
• Develop Power Query transformations and integrate enterprise data sources
• Validate reporting accuracy through reconciliation and user acceptance testing
• Apply security, governance, performance, and documentation standards

Requirements:

• Degree or diploma in a related technical or analytics field
• Strong Microsoft Power BI, DAX, Power Query, and SQL expertise
• Knowledge of dimensional modelling, star schemas, and data warehousing
• Experience with large datasets and complex reporting requirements
• Strong analytical, problem-solving, communication, and collaboration skills

Apply your Power BI, SQL, data modelling, and governance expertise to enterprise reporting for Ontario government services.