Job Description

Description:

Project Name:

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 marts and views. This project will replace the existing six stand-alone IBM Cognos BI data marts (JIMS 1.0), 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 Reduced reporting lag Preservation of historical data Improved data governance
Resposbility:-
This role will assist in the planning, design, development, and testing of the Extract, Transform and Load (ETL) phases for the data warehousing activities within the Justice Information Management System (JIMS) 3.0 project. Additionally, the role is expected to help make sense of the large amount of legacy data through analysis and insight to ensure new data model correctly reflects business requirements. The success of this part of the project is critical to the overall project success for the Justice Business Intelligence unit and the GOA.

Working with Senior Data Architects, this role will primarily be as the Data Developer who understands data models and design specifications, understands star schema and data warehouse development life cycle, and is able to translate requirements and design specifications into queries and batch jobs that move data into a structured data warehouse. This Data Developer role will specifically focus on:

reviewing existing data marts, performing detailed data profiling, analyzing and creating mapping specifications, developing and testing Extract Transform Load (ETL) processes, developing test queries for several Dimensions and Facts, testing of Dimensions and Facts for quality assurance, developing objects such as views, tables, stored procedures to examine data for business usability, staging the required data, addressing defects in newly developed dimension and fact tables, communicating analysis results with data architects, other developers, and business subject matter experts providing feedback and lessons learned at project close out.
Duties:

Deliver applications programming and analysis tasks as part of a system development process as well as provide application support, maintenance and enhancements. An Application Developer applies a broad knowledge of various technical areas to foresee and rectify certain problem areas within technology or with a mix of technologies, but the focus is to ensure a certain business/functional use case is solved with the help of technology.

Liaises with business units and program areas to ensure solutions meet current and strategic ministry needs and requirements. Write performing quality code to fulfill design, and pass code review with minimal number of defects. Apply configuration on development environments when required. Participate in implementing full product into production and supports providing application versions and details for implementation plan. Highlight the technical impacts of the functional design on existing applications based on a detailed analysis. Deliver technical design and database structure for medium to high application complexity. Maintain technical documentation. Identify critical features of system and focus testing effort on them. Ensure that the unit test covers the right proportion of the application. Setup data for testing. Grasp Able to quickly understand application functionalities and process. Handle and fix production defects efficiently. Provide tracking and reporting of time and status on all work as required. Contribute to the creation of the Application Lifecycle Planning Identify and coordinate release schedules Identify service requests and priorities with customer Ensure planned releases remain on schedule and on track
Job Type: Fixed term contract
Contract length: 12 months

Pay: $50.80-$65.71 per hour

Expected hours: 7.5 per week

Work Location: Remote