Project Name

JIMS 3.0 (Justice Information Management System)

Scope

The Data Unit requires the support of contingent labour to support a data integration project aimed to re-design and implement several reporting data marts, with conformed dimensions, containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent views.

The position will be responsible for performing technical strategic functions, ensuring the architecture supports Justice data analytics and reporting needs.

Additionally, this role may support application of the Data Fabric architecture, data quality, data standards, and best practices to development as needed.

The successful candidate is expected to have a broad skill set and be capable of performing diverse functions and activities, including but not limited to:

- Understanding of data warehouse design principles, including dimensional modeling, star schemas, snowflake schemas, and the use of conformed dimensions to ensure consistency across data marts.
- Create both logical and physical data models that efficiently store data and support business processes.
- Support the development and adoption of best practices for data management, integration and common data management, and standardized methodologies.
- Contribute to development of individual data architectures and data quality practices, as needed, to support business objectives.
- Work with datasets using ETL (Extract, Transform, Load) tools and techniques for integrating data from various sources into the EDW.
- Interact with clients/partners (GOA-internal and/or external).

Duties

- Design the data architecture, including the EDW structure, data marts, and conformed dimensions,



to support reporting and analytical needs.
- Develop logical and physical data models for the EDW and data marts, ensuring they are optimized for performance and aligned with business processes.
- Plan and oversee the integration of data from various sources into the EDW, designing ETL processes that ensure data quality and consistency.
- Establish data governance policies and practices to manage data access, quality, and security throughout the project.
- Support the development, adoption, and implementation of best practices in data management, which includes data architecture, data sharing, data integration, data quality, common data, and standardized methodologies.
- Lead or assist in communicating activities surrounding the Data architecture.
- Document the data architecture, models, and processes, and ensure knowledge transfer to IT and business teams for ongoing operations and maintenance.
- Contribute to development of data sharing, data integration, data quality, common data and standardized methodologies.
- Participate in design reviews, regular or ad-hoc architectural reviews – ensuring correct interpretation of the data architecture.
- Respond to requests for extensions to the scope of the data architecture, as needed.
- Work with developers and supporting information technology (IT) resources to manage ongoing data assets and process changes, as needed.
- Work with IT and business stakeholders to ensure the data architecture meets business requirements and is aligned with the organization's strategic goals.

Deliverables

- Specific deliverables and due dates will be determined by the client team.
- Status reports - weekly and monthly.

📌 GOAPR315 Data Architect (Edmonton)
🏢 Omega solutions
📍 Edmonton