Software Developer - Power BI Developer

Software Developer – Developer (Power BI / BI Solutions Developer)

Position Overview

We are seeking an experienced Software Developer – Developer with strong expertise in Microsoft Power BI, Business Intelligence (BI), Data Warehousing, ETL Development, and Data Analytics. The successful candidate will design, develop, and implement enterprise BI solutions that support business reporting and decision-making needs.

Working closely with business stakeholders and technical teams, the developer will translate business requirements into scalable, secure, and high-performing analytics solutions while adhering to GO-ITS standards and industry best practices.

This role requires extensive experience in Power BI, SQL Server, ETL processes, data modeling, dashboard development, Azure analytics services, and data warehousing, along with the ability to support production releases, infrastructure upgrades, and ongoing operational support.

Key Responsibilities

Business Intelligence & Analytics Development

Design, develop, and maintain enterprise BI solutions using Microsoft Power BI.

Build interactive dashboards, reports, and visualizations to support business intelligence initiatives.

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

Develop semantic models, dimensional models, and data warehouse structures.

Create scalable reporting solutions for both on-premises and cloud environments.

Ensure data accuracy, integrity, security, and performance optimization.

Power BI Administration & Development

Develop solutions using Power BI Desktop, Power BI Service, and Power BI Report Server.

Publish, deploy, and manage Power BI reports and datasets.

Implement Row-Level Security (RLS), workspace management, and data governance controls.

Configure automated refresh schedules and monitor report performance.

Optimize Power BI datasets, queries, and dashboards for enterprise-scale usage.

Integrate Power BI with Azure services and Microsoft BI technologies.

Data Warehousing & ETL

Design and implement ETL processes using SSIS, Informatica ETL, and Azure Data Factory.

Develop data migration and transformation solutions across multiple source systems.

Build and maintain data warehouses and reporting databases.

Perform data cleansing, validation, transformation, and integration activities.

Create and maintain source-to-target mappings and data flow documentation.

Release Management & DevOps

Support deployment and release activities across development, testing, and production environments.

Automate Power BI and ETL deployments using Azure DevOps, GitHub Actions, or similar CI/CD tools.

Develop scripts using PowerShell, Python, or command-line tools for automation.

Implement automated testing, validation, rollback, and monitoring procedures.

Participate in code merges, package creation, release planning, and production support.

Technical Leadership & Stakeholder Engagement

Collaborate with business users, developers, QA teams, and infrastructure teams.

Lead discussions to identify business challenges and recommend optimal technical solutions.

Provide guidance on technology roadmaps, architecture decisions, and modernization initiatives.

Evaluate and recommend tools, platforms, and technology solutions aligned with business objectives.

Support User Acceptance Testing (UAT) and stakeholder communications.

Documentation & Knowledge Transfer

Create and maintain technical documentation including

Data dictionaries

Data models

Data flow diagrams

ETL design documents

Source-to-target mappings

Release books

Ensure all project documentation is stored in designated SharePoint and Azure DevOps repositories.

Conduct knowledge transfer sessions and walkthroughs with designated ministry staff.

Required Technical Skills

Microsoft Power BI (Desktop, Service, Report Server)

Advanced DAX (Data Analysis Expressions)

Power Query (M Language)

SQL Server and advanced SQL development

Data Modeling (Star Schema, Fact & Dimension Modeling)

ETL Development (SSIS, Informatica ETL)

Dashboard and Report Development

Data Warehousing

Data Migration and Transformation

Performance Tuning and Optimization

Row-Level Security (RLS)

Azure Data Factory

Microsoft Fabric

Azure Analytics Services

Git / Azure DevOps

Visual Studio

Preferred Technical Skills

Oracle Database

.NET Framework

Java Development

Cloud Services and Azure Platforms

Advanced Data Analytics

PowerDesigner

Erwin Data Modeler

GitHub Actions

PowerShell

Python Scripting

Desired Qualifications

10+ years of experience in Software Development, BI Development, or Data Analytics.

5+ years of hands-on experience with Power BI development and administration.

5+ years of ETL and Data Warehouse development experience.

Experience leading BI modernization, migration, and technology upgrade initiatives.

Strong understanding of SDLC, Agile, and Waterfall methodologies.

Experience with stakeholder engagement, business analysis, and requirements gathering.

Strong analytical, troubleshooting, and problem-solving skills.

Excellent communication and documentation abilities.

Nice-to-Have

Previous experience within the Ontario Public Service (OPS) or other public-sector organizations.

Knowledge of GO-ITS standards and government technology frameworks.

PL-300: Microsoft Power BI Data Analyst certification.

Experience with accessibility standards such as AODA.

Ideal Candidate Profile

A Senior Power BI Developer / BI Solutions Developer with extensive experience in Power BI, DAX, SQL, Data Warehousing, ETL (SSIS/Informatica), Azure Analytics, Microsoft Fabric, and dashboard development, combined with strong stakeholder engagement, technical leadership, and public-sector experience.

This role is best suited for professionals who can drive enterprise reporting and analytics initiatives from requirements gathering through deployment and operational support.