About The Role

Our client is looking for a Senior Software Developer with strong Power BI expertise to design, develop, and support enterprise-grade BI and analytics solutions. This role is ideal for someone who enjoys translating complex business needs into impactful data insights while working closely with technical and business stakeholders in a public-sector environment.

Key Responsibilities

Design, develop, and deliver BI solutions using Microsoft Power BI (On-Prem & Cloud) Translate business and data requirements into technical specifications and dashboards Build interactive reports and dashboards using Power BI Desktop & Power BI Service Develop and optimize data models (star schema, fact & dimension tables) Write and optimize DAX expressions and Power Query (M) transformations Integrate data from multiple sources (SQL databases, Oracle, cloud platforms, APIs) Support ETL processes, data migration, and transformation workflows Implement Row-Level Security (RLS) and ensure data governance compliance Optimize report and dataset performance for scalability and reliability Collaborate with Dev, QA, Infrastructure, and Business teams throughout the SDLC Support release management, deployments, and production troubleshooting Create and maintain technical documentation and participate in knowledge transfer

Must-Have Qualifications

10+ years of experience as a Software Developer / BI Developer Strong expertise in Power BI Desktop & Power BI Service Advanced knowledge of DAX (Data Analysis Expressions) Strong hands-on experience with Power Query (M Language) Excellent SQL skills (MS SQL Server preferred) Solid experience with data modeling (star schema, fact/dimension tables) Strong understanding of ETL processes and data integration Experience building interactive dashboards and data visualizations Knowledge of performance tuning and optimization in Power BI Experience implementing Row-Level Security (RLS) and data governance Familiarity with Microsoft Fabric, Azure Analytics, and cloud BI platforms Strong analytical, problem-solving, and stakeholder communication skills Ability to translate business needs into actionable insights Experience with report deployment, workspace management, and sharing Understanding of data warehousing and BI best practices Relevant certifications such as PL-300 (Power BI Data Analyst) are a strong asset

Nice-to-Have

Prior Ontario Public Service (OPS) or public-sector experience Experience working with GO-ITS standards Exposure to CI/CD pipelines, Azure DevOps, or release automation Knowledge of Oracle, SSIS, SSAS, SSRS, or Azure Data Factory