Senior Data Architect – JIMS 3.0 Location:

Edmonton, Alberta / Remote within Canada Department:

Government of Alberta – Justice Project:

Justice Information Management System (JIMS) 3.0 Hours:

36.25 hours/week | 7.25 hours/day Contract Term:

Initial term with potential extensions Work Location Requirement:

Candidate must reside and work within Canada

About the Project The Government of Alberta's

Justice Information Management System (JIMS) 3.0

project is transforming the way court data is integrated, governed, and reported across the Justice organization.

The project will consolidate multiple standalone IBM Cognos Business Intelligence data marts into an integrated

Enterprise Data Warehouse (EDW)

and supporting data marts and views. The solution will integrate data currently sourced from the Justice Online Information Network (JOIN) and modernize the architecture supporting strategic, operational, and ad hoc court reporting.

The initiative will improve:

Data integration and architecture

Data governance and quality

Interactive and timely reporting

Historical data preservation

Reporting performance

Reusability and cost efficiency

About the Role We are seeking an experienced

Senior Data Architect

to support the JIMS 3.0 project and lead key data architecture, modelling, profiling, integration, and data warehouse activities.

The successful candidate will work closely with project stakeholders and technical teams to assess existing data marts, define future-state data architecture, develop data models and mapping specifications, support ETL development,



and ensure the quality and integrity of Dimensions and Facts within the Enterprise Data Warehouse.

Key Responsibilities

Define, document, and manage data architecture principles, strategies, standards, models, guidelines, and design practices.

Review and assess existing data marts and reporting architectures.

Perform detailed data profiling and analysis of source and target data structures.

Identify and define required

Dimensions and Facts

for the Enterprise Data Warehouse.

Develop detailed data mapping and design specifications.

Support the development and testing of

ETL/ELT processes .

Develop and validate data models using enterprise data architecture and dimensional modelling principles.

Support staging and transformation of required data.

Update existing JOIN data models to accommodate new Fact attributes.

Perform quality assurance and testing of Dimensions, Facts, and data warehouse components.

Develop Power BI reports and visualizations to support data validation and testing.

Identify opportunities to improve data quality, reuse, sharing, and governance.

Develop transition plans to move current-state data toward the desired future-state architecture.

Provide architecture guidance and consulting to project teams and stakeholders.

Participate in data architecture and solution design reviews.





Ensure alignment with Government of Alberta enterprise architecture and IMT strategies.

Address data architecture scope extensions and provide recommendations.

Provide technical guidance, advice, and consultancy to initiatives aligning with enterprise data architecture.

Support minor fixes and enhancements to delivered data marts.

Document lessons learned and provide project close-out feedback.

Collaborate with enterprise architecture and technical teams as required.

Required Qualifications & Experience Education

Post-secondary degree or diploma in

Computer Science, Information Technology, Cybersecurity, Data Management , or a related discipline.

Completed structured training in

SQL or structured query languages .

Training related to

Cloud Computing

completed within the past 5–10 years.

Data Architecture & Modelling

5+ years of experience

defining data architecture and applying

Kimball/dimensional data modelling

principles.

5+ years of experience

using data modelling and architecture tools such as

SAP/Sybase Power Designer or equivalent.

Solid experience with enterprise data warehouse architecture, dimensional modelling, Facts, Dimensions, data mapping, and data integration.

Strong experience performing data profiling, source-to-target analysis, and data quality assessment.

Experience designing and supporting ETL/ELT processes.

Experience with data governance, data quality, metadata, and information management practices.

Experience developing or validating BI reporting solutions, preferably using

Power BI .

Public Sec

📌 Senior Data Architect I Onsite I GOA I (Edmonton)
🏢 Analyst Technical Solutions
📍 Edmonton