Data Engineer - Senior

Data Engineer – Senior

Government of Alberta – Technology and Innovation (Digital Design and Delivery Division)

Contract Term : January 26, 2026 – January 31, 2027 (up to 12-month extension)

Work Model : Primarily Remote (Edmonton-based meetings as required)

Project Overview

The Government of Alberta (GoA) is modernizing how government services are designed and delivered to provide simpler, more efficient, and more user-centred digital services for Albertans. The Digital Design and Delivery Division (DDD) serves as the Province’s centre of excellence for digital delivery, combining human-centred design, Agile delivery, and modern data practices to ensure service quality, consistency, and value.

DDD partners with ministries across government to support service innovation, program review, and digital transformation initiatives. As part of this mandate, DDD is seeking a Senior Data Engineer to support enterprise-scale data and analytics solutions across multiple product and program teams.

Role Summary

The Senior Data Engineer will work as part of cross-functional Agile delivery teams, collaborating with product owners, engineers, analysts, and stakeholders to design, build, and operate scalable data platforms and analytics solutions.

This role combines strong data engineering expertise with advanced analytics and visualization capabilities, enabling data-driven decision-making and measurable service improvements across the Government of Alberta.

Key Responsibilities

Data Engineering & Architecture

Design, build, and maintain scalable data pipelines across on-premises and cloud platforms (Azure, AWS, GCP).

Develop and optimize ETL / ELT workflows to ingest, transform, and store large, complex datasets.

Build and manage data lakes, warehouses, and curated data marts with appropriate governance, security, and performance controls.

Design and implement dimensional data models (star and snowflake schemas) to support reporting, analytics, and self-service use cases.

Integrate data from diverse sources including SQL, NoSQL, APIs, and flat files, ensuring accuracy, completeness, and reliability.

Implement validation, monitoring, logging, and error handling to ensure high-quality, dependable data pipelines.

Automate deployment, testing, and monitoring of data pipelines using Git-based workflows and CI / CD pipelines.

Perform migrations across on-premises, cloud, and cross-database environments.

Analytics, Reporting & Insights

Analyze datasets to identify trends, patterns, and anomalies using statistical methods, DAX, Python, and R.

Develop and maintain Power BI dashboards and reports, including advanced DAX measures and tabular models.

Build descriptive and predictive models to support service improvement and policy decision-making.

Translate complex analytical findings into clear, actionable insights for non-technical audiences.

Provide data-driven evidence to support corporate priorities, strategies, and program outcomes.

Collaboration & Agile Delivery

Work within Agile product and program teams, contributing to backlog refinement, sprint planning, and iterative delivery.

Partner with engineers, analysts, and business stakeholders to translate requirements into scalable data solutions.

Support analytics literacy and self-service reporting capabilities across teams.

Mentor team members and contribute to continuous improvement of data practices.

Scope of Services

Full-time engagement supporting 2–3 concurrent projects

Maximum of 1,960 hours per term, subject to project needs

Services and deliverables will evolve iteratively based on user, business, and technical requirements

Work Location & Travel

Primarily remote

Occasional in-person meetings or work sessions in Edmonton, with reasonable notice

Some travel within Alberta may be required for field research or user interviews (arranged by the Province when possible)

Facilities & Tools

Data Engineer is responsible for providing their own equipment

Government of Alberta will provide required system access and credentials

Primary collaboration tool : Microsoft Teams (Zoom used occasionally; accounts not provided)

Security Requirements

Criminal Record Check required upon request

Enhanced Security Clearance required for assignments supporting Justice

Additional clearances (e.g., RCMP Top Secret) may be required during the contract term

Final engagement subject to written approval following successful security clearance

Mandatory Qualifications

Education

Bachelor’s degree in Computer Science, Information Technology, or a related field

Required Experience

5+ years experience as a Data Engineer, Data Analyst, or similar role

3+ years experience :

Designing dimensional data models

Ensuring data quality, security, and governance

Developing Power BI dashboards and reports

Working with Microsoft tabular models and DAX

5+ years experience manipulating and extracting data from diverse sources

3+ years experience with SSIS, Azure Data Factory (ADF), or similar tools

2+ years experience :

CI / CD pipelines, Git, and collaborative development workflows

Migrating data across on-premises and cloud environments

Preferred (Nice-to-Have) Experience

Leading or contributing to custom software application development projects

Experience with enterprise data integration platforms

Familiarity with Government of Alberta IT environments and shared services

Exposure to AI / ML tools and data workflows

Spirit Omega is committed to a diverse and inclusive workplace. We welcome applications from anyone, including members of Indigenous peoples, Women, visible minorities, persons with disabilities, persons of minority sexual orientations and gender identities, and others with the skills and knowledge to productively engage with diverse communities.

Looking for more opportunities? Check out our website at jobs.spiritomega.com

#INDSPO