Job Description

Description

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.

Skills

ETL, Data Warehouse, SQL Server

Type

Contract

Experience Required/Mandatory Skills

Experience and technical knowledge of Microsoft SQL Server.


Experience creating user training materials, technical documentation, and platform support resources.


Experience working as an Application Developer within an enterprise IT environment equivalent in size and complexity to the Government of Alberta.


Experience working in a data warehouse/business intelligence or relevant data environment in either a development or support role.


Knowledge of ETL processes and tools, with hands-on experience designing and implementing data pipelines for transforming and loading data from multiple sources into data warehouses.

Nice To Have Skills

Experience with Agile methodology.


Experience with smoke testing, unit testing, system testing, integration testing, regression testing and user acceptance testing.


Experience with User Acceptance Testing processes on large, complex, multi-stakeholder environment.


Experience working in the public sector

Location

Edmonton/Remote

Work Environment

1 year with 1 possible 1-year extension

Hourly Rate

Negotiable