Senior Business Intelligence Analyst – Power BI Senior Business Intelligence Analyst – Power BI
Client: Government of Alberta (GoA)

Location: Edmonton, Alberta

Work Arrangement: Primarily Remote – Must Work from Within Canada

Onsite: Up to 15% in Edmonton, as required

Contract: Approximately 1,036.75 hours

Hours: 36.25 hours/week | 7.25 hours/day

Schedule: Monday–Friday, 8:15 AM–4:30 PM Alberta Time

Job Overview
The Government of Alberta is seeking a Senior Business Intelligence Analyst – Power BI to support its Data Strategy and Data Centre of Excellence initiatives.

The successful candidate will have robust hands-on experience in Power BI, data analysis, data modelling, data visualization, DAX, SQL, analytical solutions, and data storytelling . The resource will work with complex and regulated datasets to develop dashboards, reports, KPIs, analytical models, and data products that support strategic decision-making across government.

This role requires a candidate who can work across both technical and business functions , understand stakeholder requirements, transform data into meaningful insights, and communicate findings effectively to technical and non-technical audiences.

Key Responsibilities
Design, develop, and optimize advanced Power BI solutions using complex and regulated datasets.

Develop interactive Power BI dashboards, reports, KPIs, and analytical models .

Analyze large and complex datasets to identify trends, patterns, and actionable insights.

Perform trend analysis, predictive analytics, forecasting, statistical analysis, and data mining .

Gather, analyze, document, and validate requirements for analytical and BI projects.

Translate business requirements into effective end-to-end analytical solutions .





Combine and integrate raw data from multiple sources and across different business domains.

Develop complex DAX measures, calculated columns, and advanced time-intelligence calculations .

Use SQL for data transformation, querying, and analytical processing.

Design and develop data models and analytical data products.

Conduct data quality audits, reviews, and analysis .

Capture and maintain business and technical metadata for data products.

Develop KPIs, metrics, outcomes, key results, and performance indicators .

Integrate quantitative and qualitative data to generate business insights.

Create customized reporting and visualizations using multiple data sources.

Present analytical findings and provide data-driven recommendations to business users and executives.

Explain complex data concepts clearly to both technical and non-technical stakeholders.

Support strategic planning and evidence-based decision-making.

Identify and escalate issues, risks, and data-quality concerns.

Collaborate effectively with GoA employees, vendors, and other project stakeholders.

Requirements Required Qualifications
Bachelor's degree in Computer Science or a related field . Equivalent education may be considered.

5+ years of direct hands-on experience designing, developing, and optimizing advanced Power BI solutions .

5+ years of experience using Power BI visualization techniques and features for data storytelling.





5+ years of experience analyzing large and complex datasets using Power BI and Azure analytics tools .

5+ years of experience presenting and communicating data-driven insights to executives and business users within a government organization.

5+ years of experience understanding, gathering, and developing requirements for analytical projects.

Preferred Qualifications
5+ years of experience translating business requirements into analytical solutions and delivering end-to-end BI solutions.

5+ years of experience combining raw data from multiple data sources and across business domains.

5+ years of experience working directly with clients/stakeholders and explaining complex data principles.

5+ years of experience developing complex DAX measures, calculated columns, and advanced time intelligence .

3+ years of experience using SQL for data transformation, querying, and analytical processing in large-scale environments.

5+ years of experience developing visualizations, dashboards, and analytical models.

3+ years of experience working with large government datasets .

Required Technical Skills
Primary:

Power BI

DAX

SQL

Data Analysis

KPI Development

Additional:

Statistical Analysis

Predictive Analytics

Forecasting

Data Mining

Data Quality

Data Integration

Requirements Analysis

Data Product Development

Data Storytelling

Work Arrangement
Position is primarily remote .

Candidate must be located in Canada and perform the work from within Canada.

Up to 15% onsite attendance in Edmonton may be required.

Candidate must provide their own computer, software, equipment, and remote-work setup.

Windows is strongly preferred because of compatibility with Azure Virtual Desktop (AVD) .

GoA will provide required system credentials and access.

#J-18808-Ljbffr

📌 Senior Business Intelligence Analyst – Power BI (Alberta)
🏢 SereneAid
📍 Alberta