Business Intelligence (Power BI) 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 lifecyclefrom application and authorization through compliance monitoring remediation and closureusing 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 34 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)