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.