Data and Systems Specialist

Oipc Ab

Edmonton

Presencial

CAD 77.000 - 100.000

Jornada completa

hace 30 horas
Sé de los primeros/as/es en solicitar esta vacante

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Ventajas ofrecidas por este puesto de trabajo

Positive workplace culture and work‑l‑

Descripción de la vacante

Alberta Public Service in Edmonton seeks a Data and Systems Specialist to design and maintain data infrastructure supporting capital planning. You will lead data modelling, ETL, data governance and inventory management, transforming data into analysis-ready datasets for evidence-based decisions.

You will collaborate with stakeholders to build dashboards and self-service tools using SharePoint, Power Apps and Power Automate, enhancing reporting and forecasting across divisions.

Formación

  • University degree in a related field with two years of related experience.
  • Equivalent combination of education and experience accepted.

Responsabilidades

  • Lead data collection, ETL, data warehouses and data models for analytics.
  • Develop dashboards, reports and self-service tools for decision support.
  • Establish governance standards and data quality across systems.
  • Collaborate with stakeholders to deliver data management and reporting solutions.

Conocimientos

Databases
Data warehouses
Data models
ETL processes
Excel
Python
Pandas
Analytics models
Reports
Dashboards
Self-service reporting
Data governance
SharePoint
Power Apps
Power Automate
Environmental scans
Briefings

Educación

University degree in a related field
Equivalency considered (education/experience)

Herramientas

SharePoint
Power Apps
Power Automate

Descripción del empleo

Job Information

Job Title: Data and Systems Specialist

Job Requisition ID: 88085

Ministry: Education and Childcare

Location: Edmonton

Full or Part-Time: Full Time

Hours of Work: 36.25 hours per week

Permanent/Temporary/Wage: Permanent

Scope: Open Competition

Closing Date: November 23, 2026

Classification: Program Services 3

Salary: $2,935.39 to $3,850.29 bi-weekly ($76,613 - $100,492 /year)

The Alberta Public Service works to build a stronger province for current and future generations. We make a difference in the lives of Albertans through rewarding career opportunities.

The Financial Services and Capital Planning Division supports the planning, delivery and stewardship of Alberta’s school infrastructure. Within the division, the Capital Data Analytics and Policy unit works with school jurisdictions, Francophone authorities and charter school societies to provide, preserve and upgrade supported capital infrastructure. The unit combines policy research, development and implementation with analytics and integration services, maintaining the data infrastructure used for information management, modelling, reporting, automation, and descriptive and predictive analytics.

Reporting to the Manager, Analytics and Integration, the Data and Systems Specialist develops and maintains the Capital Planning Sector’s data infrastructure, data warehouse and information systems to support reporting, analytics, digital information products and strategic capital planning. The position leads data modelling, collection, integration, governance and inventory management; transforms structured and unstructured information into analysis-ready datasets; and works with internal and external stakeholders to ensure reliable, consistent data for evidence-based decision-making.

Key responsibilities include:

  • Data Management, Integration and Information Systems: Lead the development and continuous improvement of data collection processes, databases, data warehouses, data models, ETL processes and backend workflows. Develop and support SharePoint, Power Apps, Power Automate and other digital solutions, and evaluate emerging technologies to automate workflows and improve operational efficiency.
  • Data Analysis, Analytics and Decision Support: Develop analytical models, reports, dashboards and self-service reporting tools. Integrate demographic, enrolment, geospatial and capital planning data; conduct statistical, financial and computational analysis; and prepare forecasts, recommendations, briefings, presentations and business cases for decision-makers.
  • Data Governance, Quality Assurance and Inventory Management: Establish governance standards, validation procedures and quality assurance processes to maintain accurate, consistent and reproducible information across systems. Manage data related to school facilities, sites, playgrounds, modular classrooms, building attributes, maintenance, capacity, utilization and other capital planning assets.
  • Stakeholder Collaboration and Program Support: Work with internal and external stakeholders to identify business requirements and develop data, reporting and information management solutions. Provide technical advice, training and analytical support, and participate in ministry, cross-government and stakeholder committees, working groups and special projects.

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.

  • Creative Problem Solving: Uses available resources and diverse perspectives to identify root causes, improve complex systems and develop practical data and technology solutions where established processes or information systems may not exist.
  • Agility: Anticipates obstacles, evaluates alternative approaches and adapts to changing priorities and technologies while managing risks and maintaining focus on desired outcomes.
  • Develop Self and Others: Pursues continuous learning, seeks and applies feedback, and shares technical knowledge to support the sector’s transition to tools such as SQL, Python, SharePoint and programming notebooks.
Qualifications

University graduation in a related field plus two years of progressively responsible related experience; or equivalent.

Equivalency: Directly related education or experience will be considered on the basis of one year of education for one year of experience, or one year of experience for one year of education.

Required Skills
  • Experience designing, developing and maintaining databases, data warehouses, data models and ETL processes that transform structured and unstructured data into analysis-ready datasets.
  • Advanced proficiency with Microsoft Excel and an understanding of Python and Pandas, with the ability to learn and apply new software and tools.
  • Experience developing analytical models, reports, dashboards, forecasts and self-service reporting tools to support strategic and operational decision-making.
  • Experience establishing data governance standards, quality assurance processes and validation procedures to maintain accurate, consistent and reproducible information.
  • Ability to identify business requirements and develop effective data collection, information management and reporting solutions.
  • Experience conducting environmental scans and preparing clear briefings, presentations, reports, business cases, correspondence and technical documentation.
  • Experience developing or supporting digital solutions using SharePoint, Power Apps or Power Automate.
Assets
  • Knowledge of Alberta Education and Alberta Infrastructure policies, regulations, processes and standards related to education facilities, school planning, site readiness and capital planning.
  • Experience working with demographic, enrolment, geospatial, school facility, capacity, utilization, maintenance or modular classroom information.
  • Familiarity with open-source tools or large language models used to automate workflows and improve operational efficiency.

This is (1) one full-time position working 36.25 hours per week, Monday to Friday. The successful candidate is expected to work out of the Edmonton Office.

  • Positive workplace culture and work-life balance.

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

We thank all applicants for their interest. All applications will be reviewed to determine which candidates' qualifications most closely match the advertised requirements.

If you require any further information on this job posting or require an accommodation during the recruitment process, please contact Liliane Karara at Liliane.Karara@gov.ab.ca .

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Data and Systems Specialist Office, admin and business : Government of Alberta · Edmonton · $76,613–$100,492 a year Closes Mon, Nov 23
Data and Systems Specialist Office, admin and business : Government of Alberta · Edmonton · $76,613–$100,492 a year Closes Mon, Nov 23

Alberta • Edmonton

Presencial
CAD 76.000 - 100.000
Stakeholder Business Coordinator Office, admin and business : Government of Alberta · Edmonton · $59,137–$74,827 a year Closes Mon, Nov 23
Stakeholder Business Coordinator Office, admin and business : Government of Alberta · Edmonton · $59,137–$74,827 a year Closes Mon, Nov 23

Alberta • Edmonton

Presencial
CAD 59.000 - 75.000
Regulatory Specialist
Regulatory Specialist

Alberta • Edmonton

Presencial
CAD 77.000 - 100.000
Stakeholder Business Coordinator
Stakeholder Business Coordinator

Oipc Ab • Edmonton

Presencial
CAD 60.000 - 76.000
Instructional Design Specialist
Instructional Design Specialist

Government of Alberta • Edmonton

Presencial
CAD 77.000 - 100.000
Facilities Coordinator
Facilities Coordinator

Alberta • Edmonton

Presencial
CAD 83.000 - 114.000
Facilities Coordinator
Facilities Coordinator

Oipc Ab • Edmonton

Presencial
CAD 83.000 - 114.000
Student Records Representative
Student Records Representative

Alberta Police Review Commission • Edmonton

Presencial
CAD 57.000 - 72.000
Foundational Learning Supports Coordinator
Foundational Learning Supports Coordinator

Alberta • Edmonton

Presencial
CAD 62.000 - 80.000
Public Service Pension Plan (PSPP)
Professional learning and development
Alberta Public Service benefits
+1
Facilities Coordinator Trades, maintenance and labour : Government of Alberta · Edmonton · $83,258–$114,316 a year Closes Thu, Nov 19
Facilities Coordinator Trades, maintenance and labour : Government of Alberta · Edmonton · $83,258–$114,316 a year Closes Thu, Nov 19

Alberta • Edmonton

Presencial
CAD 83.000 - 114.000