Business Intelligence Analyst

The Digital Regulatory Assurance System (DRAS) is a major Government of Alberta initiative led by Environment and Protected Areas (EPA) to modernize, digitize, and streamline environmental and natural resource regulatory processes.

DRAS supports the complete regulatory lifecycle—from application and authorization through compliance monitoring, remediation, and closure—using a single digital platform. As the volume and complexity of data continue to grow, the program requires an experienced Business Intelligence Analyst to provide advanced analytics, reporting, dashboard development, and data-driven insights that support operational and strategic decision-making.

• Design, develop, and maintain advanced dashboards, scorecards, and visual analytics using Microsoft Power BI.
• Build and optimize enterprise reporting solutions using Power BI, DAX, and Power Query.
• Develop and maintain data models, semantic models, and ETL processes.
• Integrate Power BI solutions with Azure-based data platforms and on-premises data sources.
• Collaborate with business stakeholders, data architects, and data engineers to understand reporting requirements and KPIs.
• Translate business requirements into scalable analytical and reporting solutions.
• Conduct data analysis to identify trends, patterns, anomalies, and business opportunities.
• Present analytical findings and recommendations to business and executive stakeholders.
• Implement and maintain Power BI Service features including scheduled refreshes, alerts, and workspace management.
• Configure Row-Level Security (RLS), incremental refresh, and performance optimization strategies.
• Ensure data quality, consistency, governance, and security compliance.
• Provide end-user support, training, and documentation.
• Leverage AI-assisted analytics tools to automate insights generation and enhance reporting capabilities.
• Perform other related duties as required.

• Post-secondary Degree, Diploma, or Certificate in Computer Science, Information Technology, Data Analytics, or a related discipline.

• 5+ years of experience translating business requirements into analytical and reporting solutions.
• 5+ years of hands-on experience designing, developing, and optimizing advanced Power BI dashboards and reports.
• 5+ years of experience with SQL for querying, data transformation, and reporting.
• 5+ years of experience analyzing large and complex datasets.
• 5+ years of experience developing complex DAX measures, calculated columns, and data models.
• 4+ years of experience implementing Power BI Service capabilities including refresh schedules, security, and deployment.
• 4+ years of experience designing business intelligence and analytics solutions.
• 4+ years of experience using advanced data visualization and storytelling techniques.
• Strong experience working with Azure data platforms and enterprise reporting environments.

• Experience with source code control and version management practices.
• Experience leveraging AI-assisted analytics tools and technologies.
• Experience with Databricks Medallion Architecture.
• Experience building data products using Azure Synapse Analytics.
• Experience working with Government of Alberta data environments and datasets.

• Remote work from within Canada is required.
• Resource must supply their own computer and equipment.
• Windows operating system is preferred for Azure Virtual Desktop (AVD) compatibility.
• Occasional onsite meetings may be required in Edmonton, Alberta (approximately 3–4 times annually or as needed).
• Travel, accommodation, relocation, and related expenses will not be reimbursed.

• Criminal Record Check may be required prior to project commencement.
• Successful candidate must complete mandatory Government of Alberta training, including:
  • Freedom of Information and Protection of Privacy (FOIP)
  • Security Awareness Training
  • Other required onboarding courses

Candidates must provide:

• Updated Resume
• Detailed project descriptions demonstrating required experience
• Employment history in MMM/YYYY to MMM/YYYY format
• Three professional references (most recent first)