Search Jobs

Hold CTRL to choose multiple sectors (up to 3)


Hold CTRL to choose multiple sectors (up to 3)

Data Warehouse Developer (PROMS) job in South West

  • Show me jobs like this one
  • More jobs from this recruiter
  • Email this job to a friend
  • Print this job
Job Ref:  204708099
Employer:  cv-library.co.uk
Job Type:  Contract
Country:  United Kingdom
City:  South West
Salary:  £165 - £175/day
21/10/2016 02:23
NHS Organisation

Data Warehouse Developer

South West

Circa £(Apply online only) per day

4 months with potential to extend

An exciting position within a South West NHS organisation.

You will be required to develop a robust generic ETL process for extracting XML from a SQL table in the PROMs system into a relational format into SQL tables

You will be responsible for:

* Link the PROMs data to other data warehouse datasets and develop a range of data products that satisfy the requirements of users such as Local Health Boards and analytical/ research staff
* Develop further ETL processes for the capture of patient-level costing and National Joint Registry data, both of which are required in order to support the overarching objectives of the PROMs project
* Liaise with the PROMs developers to ensure that the data held in the PROMs system is accessible in a "data warehouse-ready" format
* Extract, transform and load XML data from the PROMs system into relational SQL tables
* Liaise with users to establish requirements for data products, and then develop these data products, linking PROMs data to other datasets where required and anonymising data as appropriate

You will have:

* Experience of using Microsoft SSMS & SSIS and ETL.
* Experience of manipulating (and shredding) XML is also a pre-requisite
* Knowledge of XML Schema Definition (XSD files)
Copyright © Rengineeringjobs.com Job Board 2011  | Powered by JobMount Job Board Software