Job Description BI Analyst (Power BI / Data Analytics)

Project Overview

The Data Services team within Technology and Innovation supports the Oil Sands Monitoring (OSM) Program under Alberta Environment and Protected Areas. The team enables access to scientifically credible environmental monitoring data and supports data governance data quality reporting and technical systems.

The BI Analyst will collaborate with technical teams and business stakeholders to deliver enterprise reporting analytics and visualization solutions that support operational scientific and executive decision-making.

Requirements

Key Responsibilities

• Design and develop advanced dashboards scorecards and visual analytics using Power BI
  
• Build and maintain enterprise data models and semantic layers
  
• Develop ETL processes using Power Query M and DAX
  
• Create optimized and reusable Power BI datasets and reports
  
• Integrate Power BI with Azure data sources and on-premises databases
  
• Analyze large and complex datasets for trend analysis predictive analytics and forecasting
  
• Gather business requirements and translate them into analytical solutions
  
• Work with data architects and engineers to manage data pipelines and staging environments
  
• Implement Power BI Service features including:
  • Scheduled refresh
    
  • Workspaces
    
  • Row-Level Security (RLS)
    
  • Incremental refresh
    
• Optimize dashboards and reports for performance and usability
  
• Present insights and recommendations to executives and business stakeholders
  
• Provide training and support for end users
  
• Ensure data quality governance and security compliance
  

Mandatory Qualifications

Education

• Post-secondary degree diploma or certificate in Computer Science or a related field
  

Required Experience (Minimum 4 Years Each)

• Translating business requirements into analytical and BI solutions
  
• Designing developing and optimizing advanced Power BI solutions
  
• Building visualizations and storytelling dashboards using Power BI
  
• Analyzing large complex datasets using Power BI and Azure analytics tools
  
• SQL development for querying transformations and analytical processing
  

Nice-to-Have Skills

• Experience building data products in the Government of Alberta cloud environment
  
• Strong DAX expertise including:
  • Complex measures
    
  • Calculated columns
    
  • Advanced time intelligence
    
• Experience with Power BI Service administration and security
  
• Executive-level presentation and storytelling experience
  
• Experience with Alberta government datasets such as:
  • Environmental monitoring
    
  • Water licensing
    
  • Transportation permits
    
  • Consumer licensing
    

Technical Skills

• Microsoft Power BI
  
• DAX
  
• Power Query M
  
• SQL
  
• Azure Analytics Tools
  
• ETL & Data Modeling
  
• Dashboard Optimization
  
• Row-Level Security (RLS)
  
• Predictive Analytics & Forecasting
  

Work Environment

• Remote work within Canada
  
• Occasional onsite meetings in Edmonton (34 times annually)
  
• Must provide own equipment compatible with Azure Virtual Desktop (Windows preferred)
  

Additional Information

• Criminal record check may be required
  
• Mandatory GOA security and privacy training required upon onboarding
  
• Work hours:
  • Monday to Friday
    
  • 08:15 AM 04:30 PM Alberta Time