Senior Power BI & Data Analytics Lead - Remote Canada

SereneAID; Edmonton; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

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 strong 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

Qualifications

• Bachelor's degree in Computer Science or a related field.
• 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.

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.

Skills

Power BI

DAX

SQL

Data Analysis

KPI Development

Data Storytelling

Education

Bachelor's degree in Computer Science or a related field

Tools

Azure analytics tools

Job description

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 strong 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