Senior Data Engineer Government of Alberta – Technology and Innovation Location:

Edmonton, Alberta / Remote within Canada Work Arrangement:

Primarily Remote | On-site as Required Position:

1 Contract Term:

Approximately 1 year, with potential extension of up to 24 months

About the Opportunity The Government of Alberta (GoA) is seeking an experienced

Senior Data Engineer

to join its

Digital Design and Delivery (DDD)

team within Technology and Innovation.

The Digital Design and Delivery Division is helping transform government services by enabling simpler, more efficient, accessible, and citizen-focused digital experiences. The team applies modern digital delivery practices, including human-centred design, agile methodologies, cloud technologies, modern data practices, and evidence-based decision-making.

The successful candidate will work across multiple government projects involving

data engineering, data integration, analytics, cloud transformation, data architecture, and digital service modernization .

This is an excellent opportunity for a senior data professional who enjoys working in complex enterprise environments and collaborating with product owners, analysts, developers, architects, and business stakeholders.

Project Overview – JIMS 3.0 One of the key initiatives associated with this opportunity is

JIMS 3.0 (Justice Information Management System) .

JIMS 3.0 is a data integration initiative designed to consolidate, redesign, and modernize multiple court-data reporting environments into an integrated

Enterprise Data Warehouse (EDW)

and supporting data marts and views.





The project will replace six existing standalone IBM Cognos BI data marts, including:

Justice Information Management System (JIMS)

Crown File Ownership (CFO)

Court Case Management (CCM)

Courtroom Utilization

Courtroom Activity

Case Adjournment

The initiative will integrate data currently extracted and transformed from the

Justice Online Information Network (JOIN)

database and establish a more effective, scalable, governed, and user-friendly reporting architecture.

Key project outcomes include:

Integrated and scalable data architecture

Improved reporting and analytics capabilities

Reduced reporting latency

Preservation of historical data

Improved data governance and data quality

Enhanced self-service reporting capabilities

Role Overview The

Senior Data Engineer

will be responsible for designing, developing, testing, and supporting enterprise data solutions across cloud and on-premises environments.

The successful candidate will work with data architects, analysts, developers, product owners, and business stakeholders to develop reliable data pipelines, dimensional models, reporting solutions, and data integration processes.

The role will involve both

hands-on technical delivery and collaboration with business and technical stakeholders .





Key Responsibilities Data Engineering & Integration

Design, build, and maintain scalable data pipelines across on-premises and cloud environments, including

Microsoft Azure, AWS, and GCP .

Develop end-to-end

ETL/ELT pipelines

to ingest, transform, validate, and store large and complex datasets.

Build and maintain data integration solutions using

SSIS and Azure Data Factory (ADF) .

Integrate data from relational databases, NoSQL platforms, APIs, files, and other heterogeneous data sources.

Implement data validation, error handling, logging, monitoring, and reconciliation processes to ensure reliable data delivery.

Identify and resolve pipeline performance issues, bottlenecks, and data-quality challenges.

Optimize ETL/ELT processes for scalability, performance, maintainability, and operational reliability.

Data Modelling & Architecture

Design and optimize

dimensional data models , including Star and Snowflake schemas.

Develop and maintain fact and dimension tables to support enterprise reporting and analytics.

Apply data architecture principles, standards, and best practices.

Conduct detailed data profiling and analyze source-system structures and relationships.

Develop data mapping and transformation specifications.

Promote reusable, scalable, and governed data models.

Support data warehouse and data lake architecture and implementation.

Ensure data solutions align with enterprise data governance and security requirements.

Data Migration

Design and execute data migration solutions across on-premises and cloud environments.

📌 Senior Data Engineer I Govt of Alberta I Hybrid (Edmonton)
🏢 Analyst Technical Solutions
📍 Edmonton