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.