19 Nov
|
Pathlion
|
Ottawa
Project NameJIMS 3.0 (Justice Information Management System)ScopeJustice 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:BenefitsIntegrated and dynamic architectureInteractive reportingReporting lagPreservation of historical dataImproved data governanceRole OverviewThis Senior Data Architect role will:review existing data martsperform detailed data profilinganalyze and create design and mapping specificationsidentify dimensions required for factscomplete detailed data profiling of tables included in factsdevelop and test Extract Transform Load (ETL)
processesdevelop Power BI reports for testing for several dimensionstest dimensions and fact for quality assuranceupdate JOIN as‐is data models for recent fact attributesstage the required dataaddress minor fixes in delivered data martsprovide feedback and lessons learned at project close outDutiesFacilitate 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 requirementsEncourage practices that improve data qualityDevelop and lead the transition plans that will guide current data to its ideal future stateLead or assist in communication activities surrounding the Sectors and Government of Alberta Enterprise Architecture (GAEA) data architectureContribute 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 architectureRespond to requests for extensions to the scope of the data architectureProvide 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 strategiesEstablish and participate in design reviews, regular or ad‐hoc architectural reviews – ensuring correct interpretation of the data architecture, and IMT strategiesProvide support to other members of the enterprise architecture team as required
📌 Data Architect - Senior (Remote) Jp952 (Ottawa)
🏢 Pathlion
📍 Ottawa