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, contemporary 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 efficient, 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