Archived listing. The details below describe a past opening.
Client: Government of Alberta – Business Intelligence Analyst - Intermediate
We are seeking an experienced
Business Intelligence Analyst – Intermediate with strong hands-on expertise in
Power BI, data analysis, data modelling, statistical analysis, data visualization, DAX, SQL, data quality, predictive analytics, forecasting, and analytical data products. The successful candidate will support strategic data initiatives for the Government of Alberta by transforming complex and regulated datasets into actionable insights, dashboards, reports, KPIs, and analytical solutions for policy, operations, executive reporting, and decision-making.
Role Snapshot
Client Government of Alberta
Work Location 7000 - 113 ST, Edmonton, Alberta, CAN, T6H 5T6
Work Model Primarily Remote – up to 15% onsite meetings
Estimated Start Date 05/10/2026
Estimated End Date 30/04/2027
Business Days 244.00
Estimated Hours per Day 7.25
Maximum Extension Term 6 Months
Application Deadline Monday, September 21, 2026 at 4:00 PM EST
Key Requirements
Must Have
- Direct hands-on experience designing, developing, and optimizing advanced Power BI solutions that transform regulated and complex datasets into actionable insights for policy, operations and executive reporting.
- Direct hands-on experience with a comprehensive set of visualization techniques and features that demonstrate both technical depth and storytelling skill using Power BI.
- Direct hands-on experience in analysing large complex datasets to perform trend analysis, predictive analytics, and forecasting using Power BI and Azure analytics tools.
- Experience in presenting and storytelling to effectively communicate data-driven insights to executives and business users within a government organization.
- Experience understanding and developing requirements for analytical projects.
Nice Have
- Direct hands-on experience translating business requirements into analytical solutions and communicate findings effectively to both technical and non-technical stakeholders to deliver end to end BI solutions.
- Experience combining raw data from a variety of data sources within and across domains.
- Experience dealing with clients and explaining complex data principles in a thoughtful manner.
- Experience developing complex measures, calculated columns, advanced time intelligence using DAX (Data Analysis Expressions) in Power BI.
- Direct hands-on experience in SQL for data transformations querying, and analytical processing in large scale environments.
- Experience preparing visualizations, dashboards, and analytical models.
- Experience working with large government datasets.
Technical Skills
Business Intelligence & Power BI
- Direct hands-on experience designing, developing, and optimizing advanced Power BI solutions.
- Strong experience transforming regulated and complex datasets into actionable insights.
- Experience creating dashboards, reports, business KPIs, visualizations, and analytical models.
- Comprehensive experience with Power BI visualization techniques and features.
- Ability to use Power BI for data storytelling and communicating data-driven insights.
- Experience developing complex measures, calculated columns, and advanced time intelligence using DAX (Data Analysis Expressions).
Data Analysis & Analytics
- Direct hands-on experience analysing large complex datasets.
- Experience performing trend analysis.
- Experience with predictive analytics.
- Experience with forecasting using Power BI and Azure analytics tools.
- Experience performing statistical analysis and data mining.
- Experience analysing data and preparing results.
- Ability to integrate both quantitative and qualitative data to create business insights.
Data Modelling & Data Products
- Experience with data modelling.
- Experience developing and sharing data models and products.
- Experience developing data products based on various data sets.
- Experience designing and developing analytical data products and services.
- Experience designing and creating dashboards and custom reporting with various data sources and inputs.
- Experience capturing business and technical metadata for data products.
- Experience combining raw data from a variety of data sources within and across domains.
SQL & Data Processing
- Direct hands-on experience in SQL for data transformations, querying, and analytical processing in large-scale environments.
- Experience working with large and complex datasets.
- Experience performing data transformations and analytical processing.
- Experience working with various data sources and inputs.
Requirements & Business Analysis
- Experience understanding and developing requirements for analytical projects.
- Experience gathering and documenting client requirements.
- Direct hands-on experience translating business requirements into analytical solutions.
- Ability to communicate findings effectively to both technical and non-technical stakeholders.
- Experience delivering end-to-end BI solutions.
Data Quality, Governance & Statistical Analysis
- Experience performing data quality audits/reviews.
- Experience with data governance.
- Experience performing statistical analysis and data mining.
- Experience capturing business and technical metadata for data products.
- Experience working with large government datasets.
Government & Stakeholder Experience
- Experience presenting and storytelling to effectively communicate data-driven insights to executives and business users within a government organization.
- Experience working with large government datasets.
- Experience dealing with clients and explaining complex data principles in a thoughtful manner.
- Ability to provide insights, support decision-making, and facilitate strategic business planning.
Professional Skills
- Strong analytical and problem-solving capabilities.
- Ability to translate complex data into actionable business insights.
- Strong data storytelling and presentation skills.
- Ability to communicate effectively with executives, business users, technical stakeholders, and non-technical stakeholders.
- Ability to gather, understand, and document analytical project requirements.
- Ability to explain complex data principles in a thoughtful manner.
- Ability to support strategic decision-making and business planning.
- Ability to work effectively within a team environment.
- Ability to adapt services and project deliverables in response to emerging user and business needs, as well as design and technical opportunities.
Role Overview
The Artificial Intelligence, Data and Emerging Technologies Division uses a one-government approach to information and privacy governance, decision-making, and service delivery across the Government of Alberta (Goal) balanced with individual client needs. This facilitates enhanced data access, collaboration, reduction in data duplication, and innovation to ensure effective and efficient services across the government to provide better services to Albertans.
The Data Centre of Excellence requires a resource to support the design and development of analytical data products & services to enable the Goal to better leverage its data assets support implementation of the Goal Data Strategy. Working within a team, this position plays a fundamental role in ensuring high-quality data analysis, data modelling, development of data visualizations and development of evidence for use across departments and with external stakeholders. This role will enact the pillars of the Data Strategy by using data to benefit Albertans.
Skills
The successful candidate will be a Business Intelligence Analyst with a diverse range of analytical skills and experience in working in multi-faceted roles. The role may have aspects of any or all the following:
- Data analysis
- Data modelling
- Statistical analysis
- Data governance
- Data science
- Data quality
- Advising
- Business analysis
- Data product design and delivery
Duties & Responsibilities
Provides hands-on business intelligence support on the strategic data initiatives that are being undertaken as part of the Data Strategy. A critical responsibility is to translate data into actionable business insights that support strategic decisions by creating dashboards, reports and business KPIs. Services and project deliverables should evolve as the work progresses, in response to emerging user and business needs, as well as design and technical opportunities.
Works With Manager Analytics Capability Centre To
- Deliver business intelligence capabilities to support internal and external client needs.
- Develop data products based on various data sets.
- Analyse data and prepare results.
- Gather and document client requirements.
- Design and develop data products.
- Capture business and technical metadata for data products.
- Perform data analysis, data quality audits/reviews, statistical analysis and data mining.
- Develop and share data models and products.
- Develop baseline and ongoing outcomes, key results, metrics, and other indicators.
- Apply skills to provide insights, support decision-making and facilitate strategic business planning.
- Integrate both quantitative and qualitative data to create business insights.
- Design and create dashboards and custom reporting with various data sources and inputs.
Work Arrangement
Primarily Remote – Edmonton, Alberta, Canada
It is anticipated the role will be primarily Remote with the possibility of up to
15% onsite meetings.
However, in the event that onsite attendance is required, the GoA will not cover expenses or any cost related to relocation, commuting, housing/accommodation, or meals and beverages.
This is a Business Intelligence Analyst position with the
Government of Alberta, supporting strategic data initiatives, analytical data products, data modelling, data visualization, business intelligence capabilities, and evidence-based decision-making across government departments and external stakeholders.
How to Apply
If you find this opportunity aligns with your career goals and interests, please send your documents to
hrsmss@smsoftconsulting.com by
Monday, September 21, 2026 at 4:00 PM EST at your earliest convenience.
We cannot proceed with the submission without the mandatory documents.
- Updated Resume in Word format – Mandatory
- Skills Matrix and References – Mandatory
- Expected Hourly Rate – Mandatory
- Visa Status – Mandatory
- LinkedIn ID – Mandatory
If you are not interested, please feel free to send over any names or forward this message to anyone who may be interested.
Email is the best way to reach us.
We make sure to screen every resume we receive in response to the positions shared, but we can't reply to every applicant due to the heavy load. However, only shortlisted candidates with the required skills will be contacted.
You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.
