Job Description Senior Business Intelligence Analyst Power BI Client: Government of Alberta (GoA) Project: Data Strategy & Various Data Projects 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 AM4: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 Visualization Data Modelling Dashboard Development Business Intelligence Data Analysis KPI Development Additional:



Azure Analytics 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.

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 Visualization Data Modelling Dashboard Development Business Intelligence Data Analysis KPI Development Additional: Azure Analytics Statistical Analysis Predictive Analytics Forecasting Data Mining Data Quality Data Integration Requirements Analysis Data Product Development Data Storytelling

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