data architect

SereneAid; Edmonton; Hybrid; CAD 77,000 - 103,000; Full time

Job summary

SereneAid is seeking a Senior Data Architect to lead data architecture efforts for the Justice Information Management System (JIMS 3.0) initiative. The role focuses on integrating multiple data marts into a unified EDW and enacting governance, privacy, and cybersecurity standards across stakeholders within Government of Alberta.

The position is primarily remote within Canada with Edmonton onsite meetings as required, 12-month contract with possible extension, and starts ASAP.

Responsibilities

• Provide data architecture analysis, assessment, and risk assessments for JIMS 3.0.
• Define and document data architecture principles, standards, models, guidelines, and strategies.
• Analyze current-state data architecture and develop target-state architecture.
• Identify architecture risks, dependencies, gaps, and opportunities for improvement.
• Develop transition plans from current-state to future-state data architecture.
• Ensure architecture aligns with Government of Alberta Enterprise Architecture (GAEA) and IMT strategies.
• Participate in architecture and design reviews.
• Provide architecture guidance and recommendations to project teams.
• Determine appropriate data mart content and data structures based on business and reporting requirements.
• Design and develop conceptual, logical, and physical data models.
• Define Facts, Dimensions, attributes, measures, relationships, and data structures.
• Apply dimensional modeling and data warehouse best practices.
• Analyze existing reporting data marts and recommend improvements.
• Promote data reuse, standardization, sharing, and reduction of data redundancy.
• Support the integration of multiple existing data marts into the JIMS 3.0 EDW.
• Capture, analyze, document, and implement business rules.
• Identify and document enterprise data requirements.
• Translate business requirements into technical data structures.
• Work with stakeholders to validate data definitions and business rules.
• Ensure data models accurately represent business and judicial processes.
• Perform detailed data profiling and analysis.
• Assess data quality, completeness, consistency, and integrity.
• Identify data gaps, anomalies, duplication, and inconsistencies.
• Establish practices that improve data quality and governance.
• Support testing and validation of data marts and data warehouse structures.
• Support the design and implementation of data integration and ETL processes for the JIMS 3.0 EDW.

Job description

Senior Data Architect

SereneAid

Client: Government of Alberta ? Justice

Project: Justice Information Management System (JIMS 3.0)

Role: Senior Data Architect

Work Arrangement: Primarily Remote within Canada; Edmonton onsite meetings as required

Contract: Approximately 12 months with potential extension up to 24 months

Role Overview

The Government of Alberta ? Justice is seeking a Senior Data Architect to support the JIMS 3.0 (Justice Information Management System) initiative. JIMS 3.0 is a data integration and modernization project focused on consolidating multiple court-data reporting marts into an integrated Enterprise Data Warehouse (EDW) and associated data marts and reporting views. The Senior Data Architect will provide architecture leadership, conduct architecture risk assessments and analysis, define data structures and business rules, and support the design and implementation of data marts. The resource will work closely with enterprise architects, technical teams, business stakeholders, and Justice representatives to ensure that data architecture aligns with Government of Alberta standards, privacy requirements, cybersecurity policies, and business objectives.

Key Responsibilities

Data Architecture & Analysis

• Provide data architecture analysis, assessment, and risk assessments for JIMS 3.0.
• Define and document data architecture principles, standards, models, guidelines, and strategies.
• Analyze current-state data architecture and develop target-state architecture.
• Identify architecture risks, dependencies, gaps, and opportunities for improvement.
• Develop transition plans from current-state to future-state data architecture.
• Ensure architecture aligns with Government of Alberta Enterprise Architecture (GAEA) and IMT strategies.
• Participate in architecture and design reviews.
• Provide architecture guidance and recommendations to project teams.

Data Mart & Data Warehouse Architecture

• Determine appropriate data mart content and data structures based on business and reporting requirements.
• Design and develop conceptual, logical, and physical data models.
• Define Facts, Dimensions, attributes, measures, relationships, and data structures.
• Apply dimensional modeling and data warehouse best practices.
• Analyze existing reporting data marts and recommend improvements.
• Promote data reuse, standardization, sharing, and reduction of data redundancy.
• Support the integration of multiple existing data marts into the JIMS 3.0 EDW.

Business Rules & Data Requirements

• Capture, analyze, document, and implement business rules.
• Identify and document enterprise data requirements.
• Translate business requirements into technical data structures.
• Work with stakeholders to validate data definitions and business rules.
• Ensure data models accurately represent business and judicial processes.

Data Profiling & Quality

• Perform detailed data profiling and analysis.
• Assess data quality, completeness, consistency, and integrity.
• Identify data gaps, anomalies, duplication, and inconsistencies.
• Establish practices that improve data quality and governance.
• Support testing and validation of data marts and data warehouse structures.

Data Integration & ETL

• Support the design and implementation of data integration and ETL processes for the JIMS 3.0 EDW.

Location and Employment Details

• 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 #633230350523770840

Advertised until 2026-08-26