Senior Business Intelligence Analyst to develop advanced Power BI and Azure analytical solutions for regulated provincial datasets. (JP00000919)

Our public sector client is seeking a Senior Business Intelligence Analyst to develop advanced Power BI and Azure analytical solutions for regulated provincial datasets (JP00000919)

Join a data analytics team supporting government programs with high-impact business intelligence and reporting initiatives. This role delivers end-to-end analytical products transforming complex datasets into actionable insights for operations, policy, and executive decision-making.

Must Haves

• Yes/No - Bachelor degree in Computer Science, IT or related field of study.
• 5+ years of Direct hands-on experience translating business requirements into analytical solutions and communicate findings effectively to both technical and non-technical stakeholders to deliver end to end BI solutions
• 5+ years of Direct hands-on experience designing, developing, and optimizing advanced Power BI solutions that transform regulated and complex datasets into actionable insights for policy, operations and executive reporting
• 4+ years of Direct hands on experience in designing solutions to test, monitor, and audit data accuracy and completeness, both inside Power BI models and during upstream data preparation
• 4+ years of Direct hands-on experience with a comprehensive set of visualization techniques.
• 5+ years of Experience developing complex measures, calculated columns, advanced time intelligence using DAX (Data Analysis Expressions) in Power Bi
• 4+ years of Experience implementing Power BI Service features such as data refresh, workspaces and row-level security (RLS)
• 5+ years of Direct hands-on experience in analyzing large complex datasets to perform trend analysis, predictive analytics, and forecasting using Power BI and Azure analytics tools
• 4+ years of Experience in presenting and storytelling to effectively communicate data-driven insights to executives and business users within a government organization.
• 5+ years of Direct hands-on experience in SQL for data transformations querying, and analytical processing in large scale environments

A combination of the following experience is also required:

• 1+ years of Direct experience using source code control (such as GitHub etc.) approaches for Power BI artifacts).
• 1+ year of Experience leveraging AI-assisted tools (e.g., Copilot in Power BI/Fabric etc...) to accelerate data transformation, DAX generation, and report authoring. Proven ability to integrate Power BI’s native AI capabilities; such as AI Insights ,Key Influencers, and automated anomaly detection to deliver proactive business insights.
• 1+ years of Experience with Databricks Medallion Architecture (Bronze-Silver-Gold) and how Gold layer data products support enterprise reporting and analytics
• 1+ years of Experience working with Government datasets particularly Environmental Data (Water Licensing, Ambient Water monitoring), Transportation (Heavy permit loads) and Consumer licensing
• 3+ year of Proven experience in building and delivering data products using Synapse Analytics including development of curated dataset and Power Bi integration

Responsibilities

• Design and develop complex dashboards, scorecards, and visual analytics using Power BI
• Design, develop, and maintain data models and visualizations using Microsoft Power BI and Azure-based data platforms
• Data Modeling & ETL Development
• Create optimized, reusable data models using DAX and Power Query M for enterprise-wide reporting
• Build interactive dashboards and reports tailored to business needs using Microsoft Power BI
• Integrate Power BI with various Microsoft Azure data sources and on-premises databases
• Work closely with Business users, data architects and data engineers to manage data pipelines, staging areas, and semantic models.
• Work with business units to gather reporting requirements and KPIs.
• Translate ambiguous business questions into concrete BI solutions.
• Present insights and findings in clear, executive-friendly formats.
• Provide end-user training and support to ensure adoption of BI tools
• Maintain and publish datasets and dashboards in Power BI Service with scheduled refreshes and alerts
• Optimize dashboards and reports for performance
• Implement security and user access controls within Power BI
• Implement incremental data refresh, row-level security (RLS), and performance tuning strategies in Power BI.
• Conduct deep-dive analytics to uncover trends, anomalies, and business opportunities.
• Ensure data accuracy, consistency, and security compliance across all reporting assets
• Integrate AI capabilities to augment analytical processes by automating data exploration identifying trends and anomalies and generating insights.
• Other duties as needed