Software Developer - Power BI Developer

Software Developer – Developer (Power BI / BI Solutions Developer) Position Overview We are seeking an experiencedSoftware Developer – Developerwith strong expertise inMicrosoft 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 inPower 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 DevelopmentDesign, develop, and maintain enterprise BI solutions usingMicrosoft 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 & DevelopmentDevelop solutions usingPower 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 & ETLDesign and implement ETL processes usingSSIS, 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 & DevOpsSupport 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 EngagementCollaborate 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 TransferCreate and maintain technical documentation including:Data flow diagramsSource‑to‑target mappingsRelease booksEnsure all project documentation is stored in designated SharePoint and Azure DevOps repositories.Conduct knowledge transfer sessions and walkthroughs with designated ministry staff.Required Technical SkillsMicrosoft Power BI (Desktop, Service, Report Server)Advanced DAX (Data Analysis Expressions)Power Query (M Language)SQL Server and advanced SQL developmentDashboard and Report DevelopmentData WarehousingData Migration and TransformationPerformance Tuning and OptimizationRow‑Level Security (RLS)Microsoft FabricVisual StudioPreferred Technical SkillsOracle DatabaseCloud Services and Azure PlatformsAdvanced Data AnalyticsPowerDesignerErwin Data ModelerGitHub ActionsPowerShellPython ScriptingDesired Qualifications10+ 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‑HavePrevious experience within the Ontario Public Service (OPS) or other public‑sector organizations.Knowledge of GO‑ITS standards and government technology frameworks.Experience with accessibility standards such as AODA.Ideal Candidate Profile ASenior Power BI Developer / BI Solutions Developerwith extensive experience inPower 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.#J-18808-Ljbffr