GOAPRDJP000001016 - Business Intelligence Analyst - Intermediate

The Government of Alberta is seeking a Business Intelligence Analyst – Intermediate to support the Data Centre of Excellence and the province’s Data Strategy. The role focuses on designing and developing Power BI data products, dashboards, semantic models, and analytics that transform complex, regulated datasets into actionable insights for policy, operations, and executive reporting. Comparable Alberta postings emphasize advanced Power BI, DAX, data modeling, Azure analytics, and stakeholder communication.hubmub+2

Role Snapshot

• Job Title: GOAPRDJP000001016 – Business Intelligence Analyst – Intermediate
• Client: Government of Alberta
• Work Location: 7000 – 113 ST, Edmonton, Alberta (Primarily remote; up to ~15% onsite meetings)
• Estimated Start Date: 05/10/2026
• Estimated End Date: 30/04/2027
• Business Days: 244
• Hours per Day: 7.25
• Maximum Extension: 6 months
• Application Deadline: Monday, September 21, 2026 at 4:00 PM EST
• Submission Emails:
• • monikasetia@smsoftconsulting.com
  • hrsmss@smsoftconsulting.com
    

Mandatory Documents

• Updated resume in Word format
• Skills Matrix and References
• Expected hourly rate
• Visa status
• LinkedIn ID
  
  

Scope and Context

The role sits within the Artificial Intelligence, Data and Emerging Technologies Division, which uses a one-government approach to data governance, decision-making, and service delivery. The analyst will help implement the Government of Alberta Data Strategy, enabling better data access, collaboration, reduced duplication, and innovation across ministries.

The position supports the Data Centre of Excellence by designing and delivering analytical data products and services, including dashboards, reports, KPIs, data models, and evidence for use across departments and with external stakeholders.hubmub+1

Key Duties

• Deliver business intelligence capabilities to support internal and external client needs.
• Develop data products based on various datasets.
• Analyze data and prepare results.
• Gather and document client requirements.
• Design and develop data products and semantic models.
• Capture business and technical metadata for data products.
• Perform data analysis, data-quality audits, statistical analysis, and data mining.
• Develop and share data models and products.
• Define baseline and ongoing outcomes, key results, metrics, and indicators.
• Provide insights that support decision-making and strategic planning.
• Integrate quantitative and qualitative data to create business insights.
• Design and create dashboards and custom reporting from various data sources.
  
  

Must-Have Experience

• Direct hands-on experience designing, developing, and optimizing advanced Power BI solutions for regulated and complex datasets.
• Direct hands-on experience with a comprehensive set of Power BI visualization techniques and storytelling features.
• Direct hands-on experience analyzing large, complex datasets for trend analysis, predictive analytics, and forecasting using Power BI and Azure analytics tools.
• Experience presenting and storytelling to effectively communicate data-driven insights to executives and business users in a government environment.
• Experience understanding and developing requirements for analytical projects.
  
  

Nice-to-Have Experience

• Translating business requirements into analytical solutions and communicating findings to technical and non-technical stakeholders.
• Combining raw data from multiple sources within and across domains.
• Explaining complex data principles clearly to clients.
• Developing complex measures, calculated columns, and advanced time intelligence using DAX in Power BI.
• Direct hands-on experience with SQL for transformations, querying, and analytical processing in large-scale environments.
• Preparing visualizations, dashboards, and analytical models.
• Working with large government datasets.
  
  

Comparable Government of Alberta BI roles specifically call for advanced Power BI, DAX, Power Query M, semantic modeling, ETL, Azure integration, performance tuning, and storytelling for executive audiences.hubmub+2

Technical Environment

• Microsoft Power BI
• DAX and Power Query M
• Azure analytics services
• SQL Server and relational databases
• Data modeling and semantic models
• Data-quality and metadata management
• Cross-ministry data integration
  
  

Ideal Candidate

The strongest candidate is an intermediate BI analyst who can:

• Design and build enterprise-grade Power BI solutions.
• Model data, write complex DAX measures, and implement advanced time intelligence.
• Integrate data from multiple sources using SQL and Azure tools.
• Translate business questions into analytical solutions and KPIs.
• Communicate insights clearly to executives and business users.
• Work with large, regulated government datasets and follow data-governance practices.
  
  

Work Arrangement

• The role is anticipated to be primarily remote, with up to 15% onsite meetings in Edmonton.
• If onsite attendance is required, the Government of Alberta will not cover relocation, commuting, housing, or meal expenses.
  
  

How to Apply

Send the following to monikasetia@smsoftconsulting.com OR hrsmss@smsoftconsulting.com by Monday, September 21, 2026 at 4:00 PM EST:

• Updated resume in Word format
• Skills Matrix and References
• Expected hourly rate
• Visa status
• LinkedIn ID
  
  

Applications without the mandatory documents cannot be submitted.