At a Glance
- Tasks: Design and implement a cutting-edge data architecture for the Justice Information Management System.
- Company: Join a forward-thinking team dedicated to improving justice data management.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on innovation and career advancement.
- Why this job: Make a real impact on data governance and reporting in the justice sector.
- Qualifications: Experience in data architecture, ETL processes, and data quality improvement.
The predicted salary is between 98550 - 120450 $ per year.
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 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
- Test 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
- 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
- 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
- Establish and participate in design reviews, regular or ad-hoc architectural reviews
- Provide support to other members of the enterprise architecture team as required
Senior Data Architect in Edmonton employer: P@thlion Staffing Careers
As a Program Manager at our organization, you will thrive in a dynamic work culture that values innovation and collaboration. We offer competitive benefits, including professional development opportunities to enhance your skills and advance your career. Located in a vibrant area, our company fosters a supportive environment where your contributions are recognized, making it an excellent place for meaningful and rewarding employment.
