Data Architect - Senior (REMOTE) JP994

Pathlion; Edmonton; Remote; CAD 90,000 - 130,000; Full time

Job summary

Pathlion is seeking a Senior Data Architect to lead the design and governance of enterprise data models for the JIMS 3.0 project in Canada. Responsibilities include reviewing data marts, profiling data, and creating mapping specifications to support an integrated data warehouse and reporting layer.

You will develop ETL processes and test Dim/Fact data, updating data models as needed. The role requires coordinating with the enterprise architecture team, delivering data architecture guidance, and

Qualifications

• Experience designing enterprise data architectures and data models.
• Proficiency in ETL design and data integration.
• Familiarity with data governance and data quality practices.

Responsibilities

• Review existing data marts and data sources.
• Perform data profiling and analyze data quality.
• Create design and mapping specifications for facts/dimensions.
• Identify dimensions for facts and document inherent attributes.
• Develop and test ETL processes to move and transform data.
• Develop Power BI reports for testing dimensions and facts.
• Coordinate testing of dimensions and facts for QA.
• Update as-is data models to incorporate new fact attributes.
• Stage required data for migration.
• Address issues in delivered data marts and provide fixes.
• Provide feedback and lessons learned at project closeout.

Skills

Data modeling

ETL development

Data governance

Education

Bachelor's degree in Computer Science or related

Tools

Power BI

Job description

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