数据架构师 - 高级 JP994
Data Architect - Senior JP994
项目名称：
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