Business Intelligence Analyst

Project Name: Digital Regulatory Assurance System Scope: Modernization initiatives across the Government of Alberta are fundamentally changing how ministry users collect, manage, analyze, and use data as legacy systems are transformed into modern Data Management and Geospatial Platforms. This shift requires dedicated analytical capacity to ensure that the value of modernized data assets is fully realized. DRAS is a Government of Alberta regulatory transformation initiative led by Environment and Protected Areas (EPA) to modernize, digitize, and streamline environmental and natural resource regulatory processes.

DRAS supports the full regulatory lifecycle, from application and authorization to monitoring, compliance, remediation, and closure through a single, consolidated digital platform. The increasing scale of DRAS data creates a strong and ongoing need for dedicated business intelligence and analytics capability to support operational monitoring, compliance oversight, performance measurement, and strategic decision‑making. These needs span the full data lifecycle, including data collection and integration, data quality management, analysis of trends, patterns, compliance and regulatory reporting, and the delivery of clear, actionable insights through dashboards and visualizations.

This position will primarily support the Digital Regulatory Assurance System (DRAS) program, where high‑quality, timely analytics are essential to regulatory and compliance functions. As data and analytics maturity increases, the role may be expanded to support additional enterprise data initiatives. Duties: This is the standard description of services – revise as needed.

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 Equipment Requirements: Resource will require own equipment. The computer's operating system must be a modern version of Windows or MacOS that is compatible with Azure Virtual Desktop (AVD) and related software for remote access.

Windows is preferred due to better compatibility. AVD/remote-related software will be installed on the resource's computer. In the event that the Contractor’s resources are directed to work remotely, the Contractor shall be responsible for providing all of its equipment, including computers, software, printers, supplies, desks and chairs.

However, the Province shall ensure that the Contractor’s resources have the necessary access and credentials to the Government of Alberta’s system. Qualification Description Expected Current Must Have Attestation Yes/No - Attestation - Conflict of Interest The Supplier certifies that, following the exercise of reasonable due diligence, it is not aware of any actual, potential, or perceived conflict of interest involving the Supplier or any of its employees, subcontractors, or agents in relation to this job posting or any resulting contract. The Supplier undertakes to immediately disclose to the Province any such conflict of interest that arises or becomes known prior to contract award.

The Supplier further certifies that all information provided, whether on its own behalf or on behalf of a candidate, is true, accurate, and complete to the best of its knowledge. Yes Yes No Education Yes/No - Post-Secondary degree, diploma or certificate in Computer Science or related field of... Post-Secondary degree, diploma or certificate in Computer Science or related field of study.

Yes Yes No Work Experience Duration - Ability to translate business requirements into analytical solutions… 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 years Duration - Direct hands-on Experience in designing, developing, and optimizing advanced Power BI... 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 5 years years Duration - Direct hands on experience in designing solutions to... 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 years Duration - Direct hands-on experience with a comprehensive set of visualization techniques...

Direct hands-on experience with a comprehensive set of visualization techniques and features that demonstrate both technical depth and storytelling skill using Power Bi. 4 years years Duration - Experience developing complex measures, calculated columns… Experience developing complex measures, calculated columns, advanced time intelligence using DAX (Data Analysis Expressions) in Power Bi 5 years years Duration -Experience implementing Power BI Service features such as data refresh... Experience implementing Power BI Service features such as data refresh, workspaces and row-level security (RLS) 4 years years Duration - Experience in analyzing large complex datasets... Direct hands-on experience in analyzing large complex datasets to perform trend analysis, predictive analytics, and forecasting using Power BI and Azure analytics tools 5 years years Duration - Experience in presenting and storytelling...

Experience in presenting and storytelling to effectively communicate data-driven insights to executives and business users within a government organization. 4 years years Duration - Experience in SQL for data transformations querying... Direct hands-on experience in SQL for data transformations querying, and analytical processing in large scale environments 5 years years Nice to Have Work Experience Duration - Direct experience using source code control approaches... Direct experience using source code control (such as GitHub etc.…) approaches for Power BI artifacts 1 years years Duration - Experience leveraging AI-assisted tools to...

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 years Duration - Experience with Databricks Medallion Architecture... Experience with Databricks Medallion Architecture (Bronze–Silver–Gold) and how Gold layer data products support enterprise reporting and analytics 1 years years Duration - Experience working with Government of Alberta datasets...

Experience working with Government of Alberta datasets particularly Environmental Data (Water Licensing, Ambient Water monitoring), Transportation (Heavy permit loads) and Consumer licensing 1 years years Duration - Proven experience in building and delivering data products using Synapse Analytics... Proven experience in building and delivering data products using Synapse Analytics including development of curated dataset and Power Bi integration 3 years years