Software Developer - Power BI Developer

Job Description

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.

Requirements
Mandatory Skills & Experience Cloud & Infrastructure Engineering Proven experience designing, deploying, and maintaining hybrid infrastructure environments across: Microsoft Azure Amazon Web Services (AWS) Linux-based environments SaaS solutions COTS solutions On-premises systems Strong experience with Windows and Linux server administration including: CentOS Ubuntu CoreOS Experience supporting modern web technology stacks including: LAMP MEAN Drupal Elasticsearch Experience with virtualization platforms, storage solutions, networking, and enterprise infrastructure services. Strong understanding of cloud architecture frameworks, technology assessments, and cloud solution strategies. Identity & Access Management Experience managing and supporting identity and access controls using: Active Directory Microsoft Entra ID Enterprise IAM solutions Experience implementing authentication, authorization, and access governance controls. DevOps & CI/CD Automation Strong experience designing, building, and administering CI/CD pipelines for continuous integration and deployment. Experience with development and collaboration tools including: Azure DevOps JIRA Confluence Maven Jenkins Experience with Infrastructure as Code (IaC) and version-controlled deployments. Strong knowledge of DevOps methodologies, automation frameworks, and release management best practices. Experience with containerization and orchestration technologies including: Docker Kubernetes AKS / EKS Experience automating operational and compliance-related activities using: PowerShell Bash Python Programming & Scripting Hands-on experience with scripting and programming languages including: Python Bash PHP Java JavaScript Node.js Experience with build and configuration management tools including: Git Ansible Chef Puppet API & Integration Experience Experience building and consuming APIs and integration endpoints. Experience integrating cloud platforms, enterprise systems, and deployment pipelines. Understanding of enterprise integration architectures and service-based deployments. Security, Monitoring & Compliance Strong understanding of infrastructure security, cloud security, and DevOps security best practices including: Least privilege access Secure logging Secrets management Vulnerability remediation Experience with security and monitoring tools including: Radware Dynatrace Splunk Azure Monitor / Log Analytics AWS CloudTrail / CloudWatch ELK Stack / SIEM solutions Experience implementing centralized audit logging and monitoring across enterprise platforms. Ability to support internal and external audits through reporting, evidence gathering, and log analysis. Experience supporting forensic investigations, audit remediation, and incident reviews. Familiarity with Government of Ontario I&IT Directives, Policies, and Information Technology Standards. Release Management & Operational Support Experience coordinating infrastructure and application releases across technical and business teams. Knowledge of change management processes, deployment approvals, rollback planning, and release governance. Experience with release readiness reviews, deployment validation, and post-release monitoring. Ability to maintain release documentation, operational records, and audit artifacts. Project Management & Communication Strong project planning, coordination, and resource management skills. Experience with roadmap planning, modernization initiatives, and infrastructure investment planning. Strong stakeholder communication and cross-functional collaboration skills. Ability to explain complex technical concepts to business users, leadership teams, and non-technical stakeholders. Strong documentation, reporting, presentation, and technical writing skills. Mobile Device Management Experience supporting mobile device management for cellular devices and tablets across multiple platforms and operating systems. Desirable Skills Experience supporting Government of Ontario enterprise environments. Experience with enterprise modernization and cloud transformation initiatives. Familiarity with enterprise governance, compliance frameworks, and audit readiness programs. Experience mentoring and coaching junior DevOps and infrastructure resources. Strong understanding of operational resilience, disaster recovery, and enterprise monitoring strategies. Additional Information Strong hands-on DevOps, cloud infrastructure, automation, CI/CD, security, and enterprise release management experience is mandatory for this role.