About the role
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
Hourly Rate
Negotiable
About Vantix Systems Inc
For over a decade, Vantix has been providing its clientele with technology and services to help boost productivity, streamline business processes and increase revenue. Serving diverse markets across the globe from corporate to government, Vantix delivers.
About the role
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
Hourly Rate
Negotiable
About Vantix Systems Inc
For over a decade, Vantix has been providing its clientele with technology and services to help boost productivity, streamline business processes and increase revenue. Serving diverse markets across the globe from corporate to government, Vantix delivers.