Project Data Analyst

Role Responsibilities

Join us in transforming how Alberta delivers infrastructure—where your data expertise drives smarter decisions, greater transparency, and lasting impact for communities across the province!

Reporting to the Manager of Project Reporting and Integration, the Project Data Analyst position plays a key role in developing and enhancing data analytics and reporting solutions to support the delivery of major infrastructure projects across Alberta Infrastructure. This position ensures decision-makers have timely, accurate, and actionable insights by integrating project, financial, and operational data.

The role is responsible for data governance, quality assurance, and automation, supporting transparency, efficiency, and compliance with government reporting standards. Through the design of predictive models, dashboards, and data pipelines, the analyst enables strategic planning, performance monitoring, and contributes to the ministry’s digital transformation efforts.

Responsibilities: 
Some of the responsibilities of this position include but are not limited to: 

• Data Integration & Quality Management: 
  Design and maintain data models and ETL pipelines to integrate diverse data sources.Implement data quality controls, manage metadata standards, and coordinate data stewardship to ensure accurate, timely, and trusted project data.
• Reporting & Visualization: 
  Develop and maintain executive-ready dashboards using Power BI. Standardize reporting templates and deliver concise insights to support leadership decision-making. Enable self-service analytics through certified datasets and semantic models.
• Advanced Analytics & Forecasting: 
  Build predictive models to support cost forecasting, schedule risk analysis, and resource planning. Define early warning indicators and conduct scenario analysis to inform prioritization and capital optimization.
• Governance & Compliance: 
  Apply privacy, security, and information management standards to datasets and reports. Manage change control processes and ensure alignment with ministry governance and IT systems.
• Operational Planning & Performance Measurement: 
  Translate strategic objectives into measurable KPIs. Provide analytical support for capital planning, variance analysis, and policy impact assessments to inform operational decisions.
• Data Literacy & Continuous Improvement: 
  Promote data literacy through training, coaching, and community engagement. Lead continuous improvement initiatives, pilot innovative solutions, and refine analytics tools based on user feedback.

Please click on this link to view the job description for this position.

APS Competencies

Competencies are behaviors that are essential to reach our goals in serving Albertans. We encourage you to have an in depth understanding of the competencies that are required for this opportunity and to be prepared to demonstrate them during the recruitment process.

This link will assist you with understanding competencies: https://www.alberta.ca/system/files/custom_downloaded_images/psc-alberta-public-service-competency-model.pdf.

Agility: Proactively incorporates change into processes. Creates opportunities for improvement. Is aware of and adapts to changing priorities. Remains objective under pressure and supports others to manage their emotions. Proactively explains impact of change on roles and integrates change in existing work. Readily adapts plans and practices.

Drive for Results: Knowing what outcomes are important and maximizing resources to achieve results that are aligned with the goals of the organization, while maintaining accountability to each other and external stakeholders.

Systems Thinking: Considers inter-relationships and emerging trends to attain goals. Seeks insight on implications of different options. Analyzes long-term outcomes, focus on goals and values. Identifies unintended consequences.

Creative Problem Solving: Engages the community and resources at hand to address issues. Engages perspective to seek root causes. Finds ways to improve complex systems. Employs resources from other areas to solve problems. Engages others and encourages debate and idea generation to solve problems while addressing risks.

Qualifications

Required: 

• A university degree in Computer Science, Engineering, Information Technology, Management Information Systems, or a related discipline.
• A minimum of 4 years of progressively responsible related experience in data analytics, BI development, or data engineering, preferably in a capital project or public-sector environment.
• Proven experience designing Power BI dashboards, building data models, and implementing ETL processes.
• Hands-on experience with SQL, Power Query, and automation tools (e.g., Power Automate, Azure Data Factory).
•  Advanced proficiency in Power BI, Excel (Power Pivot), and data visualization best practices.

Equivalency: Directly related education or experience considered on the basis of:

• 1 year of education for 1 year of experience; or
• 1 year of experience for 1 year of education.

 Assets:

• Microsoft Certified: Data Analyst Associate or an equivalent Business Intelligence (BI) certification.
• Project Management certification such as PMP or PRINCE2, to support governance and structured project delivery.
• Prosci Change Management certification to facilitate adoption of digital tools and processes.
• Strong understanding and/or hands-on experience with SQL for data querying and transformation.
• Knowledge of data governance frameworks, privacy/security standards, and metadata management.
• Understanding of system integration principles and API-based data exchange.
• Ability to manage Microsoft Fabric workspaces.
• Familiarity with predictive analytics and statistical modeling (Python/R).

Minimum recruitment standards outline the minimum education and experience required for appointment to a job classification. Refer to https://www.alberta.ca/alberta-public-service-minimum-recruitment-standards

Notes

Term of Employment: Permanent full-time position.
Hours of Work:  36.25 hours per week
Location:  Edmonton 

A written assessment may be required as part of the interview process.

Final candidates may be required to undergo a security screening.

Applicants are advised to provide a cover letter summarizing information that clearly and concisely demonstrates how their qualifications meet the advertised requirements, including education, experience, and relevant examples of
required competencies.

This competition may be used to fill future vacancies, across the Government of Alberta, at   the same or lower classification level.

Any costs associated with obtaining the required documents/checks as noted or interview travel expenses, will be the responsibility of the candidate. Out-of-province applicants can obtain the required documents/checks from the province they currently reside in.

Links and information on what the GoA have to offer to prospective employees.

•    Working for the Alberta Public Service - https://www.alberta.ca/advantages-working-for-alberta-public-service.aspx.
•    Public Service Pension Plan (PSPP) - https://www.pspp.ca.
•    Management Employees Pension Plan (MEPP) - https://www.mepp.ca.
•    Alberta Public Service Benefit Information - https://www.alberta.ca/alberta-public-service-benefits.
•    Professional learning and development - https://www.alberta.ca/professional-development-support-directive.
•    Research Alberta Public Service Careers tool – https://researchapscareers.alberta.ca.
•    Positive workplace culture and work-life balance.
•    Leadership and mentorship programs.