Application developer (Data Architect)

ONLY LOCALS _ CANADIAN CITIZEN

T6H 5T6

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

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

Equipment Requirements:

• Resource will require own equipment

Resource must provide their own computer and related equipment. The computer's operating system must be a modern version of Windows or MacOS that is compatible with Azure Virtual Desktop (AVD) and related software for remote access. Windows is preferred due to better compatibility. AVD/remote-related software will be installed on the resource's computer.

In the event that the Contractor’s resources are directed to work remotely, the Contractor shall be responsible for providing all of its equipment, including computers, software, printers, supplies, desks and chairs. However, the Province shall ensure that the Contractor’s resources have the necessary access and credentials to the Government of Alberta’s system.

The fixed rate quoted must be inclusive of all overhead, office space and equipment, including supplies, administrative burden, mark-up and all other costs to perform the Services for the duration of the Contract.

Working Hours:

Standard Hours of work are 08:15 – 16:30 Alberta time, Monday through Friday excluding holidays observed by the Province

• Work must be done from within Canada, due to network and data security issues.

• The role will be remote, however in the event of an onsite meeting, the GoA does not pay for travel to attend on-site meetings, nor any expenses related to relocation, commuting, housing/accommodation, food/drink.

Notes on Location:

•Resource will work remotely, though must be available for onsite meetings when required.

•This resource will primarily work remotely; however, the resource may be required to attend meetings or work sessions in office on reasonable notice from the Province. At the time of providing such notice, the Province will advise of the expected duration of any such meetings or work sessions. However, time to travel and any associated expenses to and from Edmonton and/or travel within Alberta will be at no cost to the Province.

•Onsite meetings include but are not limited to strategic, analytical, and technical discussions, meeting with team members, senior managers, directors, executive directors, and business clients. Frequency of meeting could be up to 3-4 times per fiscal year. Actual onsite attendance may be negotiable, particularly if resource lives outside Alberta.