数据架构师 - 高级 JP952
Data Architect - Senior JP952
项目名称：
JIMS 3.0（司法信息管理系统）
范围：
司法信息管理系统（JIMS）3.0 是一个数据集成项目，旨在整合、重新设计并实施多个独立的报告数据集市，这些数据集市包含法院数据，并将其整合到企业数据仓库（EDW）以及一组依赖的数据集市和视图中。该项目将取代现有的六个独立的 IBM Cognos BI 数据集市 JIMS、Crown File Ownership（CFO）、Court Case Management（CCM）、Courtroom Utilization、Courtroom Activity 和 Case Adjournment，以构建一个高度集成的数据仓库。现有的数据集市从司法在线信息网络（JOIN）数据库中提取、处理、重构并聚合用于战略、运营和临时报告的法院数据。该项目的目标是通过实现更高效、用户友好、快速且成本更低的报告架构，提升法院数据的可用性、治理和报告能力。通过该项目将实现以下优势：
集成且动态的架构
交互式报告
报告延迟减少
历史数据保存
改进的数据治理
此高级数据架构师职位将：
审查现有的数据集市
执行详细的数据剖析
分析并创建设计和映射规范
识别事实所需的维度
对事实中的表进行详细的数据剖析
开发并测试抽取-转换-加载（ETL）流程
为多个维度开发 Power BI 报告用于测试
对维度和事实进行质量保证测试
更新 JOIN 当前数据模型以适应新的事实属性
准备所需数据
解决交付数据集市中的小问题
在项目结束时提供反馈和经验总结
职责：
促进数据架构的有效定义和管理（例如原则、策略、架构、方法、设计原则、模型、标准、指南、计划等）；
鼓励减少数据冗余的数据模型和实践，通过推广重用/共享（符合 IMT 策略）；
识别并记录企业级数据需求；
鼓励提升数据质量的实践；
制定并领导过渡计划，指导当前数据向理想未来状态的转变；
领导或协助与部门和阿尔伯塔省政府企业架构（GAEA）数据架构相关的沟通活动；
为定义数据架构做出贡献；
查看英文原文
Project Name:
JIMS 3.0 (Justice Information Management System)
Scope:
Justice Information Management System (JIMS) 3.0 is a data integration project aimed to amalgamate, re-design and implement several disjointed reporting data marts containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent data mart and views. This project will replace the existing six stand-alone IBM Cognos BI data marts JIMS, Crown File Ownership (CFO), Court Case Management (CCM), Courtroom Utilization, Courtroom Activity, and Case Adjournment) with a well-integrated data warehouse. The existing data marts extract, process, re-structure and aggregate data required for strategic, operational and ad hoc reporting of court data stored in the Justice Online Information Network (JOIN) database. The goal of the project is to evolve availability, governance and reporting of court data by implementing a more efficient, user-friendly, faster and cost-effective reporting architecture. The following benefits will be realized through the project:
Integrated and dynamic architecture
Interactive reporting
Reporting lag
Preservation of historical data
Improved data governance
This Senior Data Architect role will:
review existing data marts,
perform detailed data profiling,
analyze and create design and mapping specifications,
identify Dimensions required for Facts,
complete detailed data profiling of tables included in Facts,
develop and test Extract Transform Load (ETL) processes,
develop Power BI reports for testing for several Dimensions,
testing of Dimensions and Fact for quality assurance
update JOIN as-is data models for new Fact attributes,
stage the required data
address minor fixes in delivered data marts,
provide feedback and lessons learned at project close out.
Duties:
Facilitate the effective definition and management of the data architecture (e.g. principles, strategies, architectures, methods, design principles, models, standards, guidelines, plans, etc.);
Encourage data models and practices that reduce data redundancy by promoting reuse/sharing (in keeping with the IMT strategy);
Identify and document enterprise data requirements;
Encourage practices that improve data quality;
Develop and lead the transition plans that will guide current data to its ideal future state;
Lead or assist in communication activities surrounding the Sectors and Government of Alberta Enterprise Architecture (GAEA) data architecture;
Contribute to the definition and development of the enterprise architecture framework, and associated corporate solution design and delivery methods, thus improving the proactive alignment of data architecture;
Respond to requests for extensions to the scope of the data architecture;
Provide information, advice, guidance, and consultancy to initiatives/projects that are defining or aligning to the data architecture – thus promoting compliance to the data architecture and IMT strategies;
Establish and participate in design reviews, regular or ad-hoc architectural reviews – ensuring correct interpretation of the data architecture, and IMT strategies; and
Provide support to other members of the enterprise architecture team as required
Originally posted on Himalayas