Opens an external site
- Employment type
- Full-time
- Minimum education
- Bachelor’s degree
- Apply by
- Nov 24, 2026
- Posting language
- English
- Working hours
- 36.25 hours per week
Job summary
The Data and Systems Specialist develops and maintains data infrastructure, warehouses, and information systems to support strategic capital planning and reporting. The role leads data modelling, governance, and integration efforts while providing analytical support and technical advice to stakeholders.
Job details
Job InformationJob Title: Data and Systems SpecialistJob Requisition ID: 88085Ministry: Education and ChildcareLocation: EdmontonFull or Part-Time: Full TimeHours of Work: 36.25 hours per weekPermanent/Temporary/Wage: PermanentScope: Open CompetitionClosing Date: November 23, 2026Classification: Program Services 3Salary: $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. For more information on the Ministry of Education and Childcare, please visit: https://www.alberta.ca/education-and-childcare Role Responsibilities 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. The Job Description is provided for further details on 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. 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. Minimum recruitment standards outline the minimum education and experience required for appointment to a job classification.Notes 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. 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. Links and information on what we have to offer: Working for the Alberta Public Service. Public Service Pension Plan (PSPP) Alberta Public Service Benefit Information. Professional learning and development. Research Alberta Public Service Careers tool. Positive workplace culture and work-life balance. How To Apply Applicants are advised to provide information that clearly and concisely demonstrates how their qualifications meet the advertised requirements, including education, experience, and relevant examples of required competencies. Candidates are required to apply online. Please see Job Application Resources for more information. In your resume, please include dates (including months and years) associated with all education and work experience. For example, January 2006 - June 2009 (part-time). This example is provided for illustrative purposes only. Applicants are encouraged to present their information clearly and thoroughly, using a format that best conveys their experience. It is recommended applicants who have completed post-secondary studies from outside of Canada obtain an evaluation of their credentials from the International Qualifications Assessment Service (IQAS) or from a recognized Canadian Credential Evaluator; please visit the Alliance of Credential Evaluation Services of Canada for more information.It is also recommended that applicants include the assessment certificate from IQAS or any other educational assessment service as part of their application. Closing Statement 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.
What you’ll do
The Data and Systems Specialist develops and maintains data infrastructure, warehouses, and information systems to support strategic capital planning and reporting. The role leads data modelling, governance, and integration efforts while providing analytical support and technical advice to stakeholders.
Requirements
Candidates must possess a university degree in a related field and at least two years of progressively responsible experience. Proficiency in data management tools, Python, and Microsoft Excel is required, along with the ability to develop analytical models and digital solutions.
Benefits
- Public Service Pension Plan
- Professional learning and development
- Work-life balance
Listed skills
- SQL · Preferred
- Python · Preferred
- SharePoint · Preferred
- Financial analysis · Preferred
- Reporting · Preferred
- Quality assurance · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Data modelling
- Data warehousing
- ETL processes
- SQL
- Python
- Pandas
- SharePoint
- Power Apps
- Power Automate
- Data governance
- Statistical analysis
- Financial analysis
- Reporting
- Dashboards
- Quality assurance
- Information management
- SQL (Programming Language)
- Data Analysis
- Business Intelligence
- Extract Transform Load (ETL)
- Quality Assurance
- Technical Documentation
- Dashboard
- Self Service Technologies
- Presentations
- Data Modeling
- Planning
- Data Warehousing
- Governance
- Information Systems
- Workflow Management
- Business Requirements
- Decision Making
- Microsoft Excel
- Continuous Improvement Process
- Financial Services
- Research
- Continuous Development
- Python (Programming Language)
- Data Management
- Technology Solutions
- Forecasting
- Inventory Management
- Data Governance
- Automation
- Emerging Technologies
- Pandas (Python Package)
- Operational Efficiency
- Unstructured Data
- Predictive Analytics
Job areas
- Data & Analytics
- Government & Public Sector
- Technology
- Software
- Education
- Data Systems Specialist
- Systems Administrator
- Systems Aministrators
- Network and Computer Systems Administrators
More jobs from Government of Alberta
Manager, Occupational Health and Safety Policy
- On-site
- Calgary, AB
- Posted Nov 19, 2026
Correctional Peace Officer (CPO 1 & 2) (Multiple Locations)
- On-site
- Posted Nov 19, 2026
Rangeland Agrologist
- On-site
- Medicine Hat, AB
- Posted Nov 19, 2026
Parks Business Analyst, Finance
- On-site
- AB
- Posted Nov 18, 2026
