data architect

Upstaff; Edmonton; On-site; CAD 81,000 - 99,000; Full time

Job summary

Government of Alberta Justice is seeking a Senior Data Architect to lead the data architecture for the JIMS 3.0 project. The role focuses on designing enterprise data models, profiling source data, and ensuring data quality and governance within the EDW and related data marts.

The candidate will collaborate with enterprise architecture teams, business stakeholders, and technical teams to transition current court-data environments toward the JIMS 3.0 target architecture, aligning with GA E A and

Qualifications

• Strong experience in Kimball dimensional modeling and data warehouse design.
• Proficient in SQL and cloud platforms (Azure).
• Knowledge of government/government enterprise architecture is a plus.
• Experience with data governance and data quality.

Responsibilities

• Define, document, and manage data architecture principles, strategies, standards, models, guidelines, and plans.
• Develop current-state and future-state data architecture and transition plans.
• Ensure data architecture aligns with Government of Alberta Enterprise Architecture (GAEA) and IMT strategies.
• Develop data structures required for the JIMS 3.0 EDW.
• Create detailed data mapping and transformation specifications.

Skills

Kimball modeling

Data warehouse

SQL

Azure Cloud

Data architecture

Public sector experience

JIMS

Court data

Governance

Job description

Senior Data Architect ? JIMS 3.0

Job details

Client: Government of Alberta ? Justice

Project: Justice Information Management System (JIMS 3.0)

Location: Primarily Remote ? Canada; Edmonton onsite meetings as required

Onsite Requirement: Approximately 15% of total hours

Position: 3

Hours: 36.25 hours/week

Contract: Approximately 1,805.25 hours, with potential extension up to 24 months

• Salary $ 90,100 YEAR annually
• Terms of employment Full time
• Position Vacancies 1 vacancy
• Location Edmonton , AB
• Work location On site
• Start date Starts as soon as possible
• Source Talent.com #633049212839468808

Role Overview

The Government of Alberta ? Justice is seeking a Senior Data Architect to support the Justice Information Management System (JIMS 3.0) project.

JIMS 3.0 is a major data integration and modernization initiative designed to consolidate multiple existing court-data reporting marts into an integrated Enterprise Data Warehouse (EDW) and supporting data marts and reporting views.

The Senior Data Architect will be responsible for defining the data architecture, developing dimensional data models, profiling and analyzing source data, designing data mappings, supporting ETL development, and ensuring data quality and governance. The resource will work closely with technical teams, business stakeholders, and enterprise architecture teams to transition existing court-data environments toward the JIMS 3.0 target architecture.

The ideal candidate will have strong Kimball dimensional modeling, data warehouse, SQL, Azure/cloud, data architecture, and public-sector experience. Experience with JOIN, JIMS, court data, and Justice environments is highly desirable.

Data Architecture & Enterprise Architecture

• Define, document, and manage data architecture principles, strategies, standards, models, guidelines, and plans.
• Develop current-state and future-state data architecture and transition plans.
• Ensure data architecture aligns with Government of Alberta Enterprise Architecture (GAEA) and IMT strategies.
• Define enterprise data requirements and architectural standards.
• Provide data architecture guidance and consulting to project teams.
• Participate in architectural and solution design reviews.
• Identify opportunities to improve data reuse, sharing, governance, and standardization.
• Ensure data architecture reduces unnecessary data redundancy.
• Support the enterprise architecture team with data architecture initiatives.

Data Modeling & Data Warehouse

• Apply Kimball dimensional modeling principles to design enterprise data marts.
• Develop conceptual, logical, and physical data models.
• Identify and define appropriate Facts, Dimensions, measures, attributes, keys, and relationships.
• Review and update existing data models.
• Develop data structures required for the JIMS 3.0 EDW.
• Define data warehouse and data-mart architecture patterns.
• Create detailed data mapping and transformation specifications.
• Ensure historical data is appropriately preserved and managed.

Data Profiling & Analysis

• Perform detailed profiling of source data and database tables.
• Analyze existing JIMS and related data marts.
• Identify data-quality issues, inconsistencies, redundancies, and gaps.
• Analyze business rules and relationships within court data.
• Map source data to target EDW structures.
• Validate data definitions and business rules with stakeholders.

ETL & Data Integration

• Location Edmonton , AB
• Work location On site
• Salary $ 90,100 YEAR annually
• Terms of employment Full time
• Starts as soon as possible
• vacancies 1 vacancy
• Source Talent.com #633049212839468808

Advertised until

2026-08-26

View the full job posting on Talent.com

The median wage is the salary of a given occupation where half the workers earn more than that amount, and half earn less. This information is presented on job postings to help job seekers determine how the salary compares to the amount earned by other workers working the same job. Job Bank preferred indicating the median wage, which is less affected by extremely high or low wages, rather than the average wage which is calculated by adding up all the salaries of a group of people and then dividing that total by the number of people.