[Hiring] Senior Data Architect @P@thlion Staffing Careers

Role Description

The 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 with a well-integrated data warehouse. 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.

• 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

Qualifications

• 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
• Provide support to other members of the enterprise architecture team as required