Job Description – BI Analyst (Power BI / Data Analytics)
Job ID: GOAPRDJP00000915
Client: Government of Alberta – Technology and Innovation
Project: Oil Sands Monitoring Data Services
Role: Business Intelligence (BI) Analyst
Location: Edmonton, Alberta (Remote within Canada with occasional onsite meetings)
Contract Type: GOA Standard Contingent Resource
Duration: Approx. 12 months + possible 6-month extension
Work Schedule: 36.25 hours/week
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 (3–4 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