Data Warehouse Developer Cardiff 300 pd

Cardiff (Caerdydd)
max 300 per day
01 Nov 2017
16 Nov 2017
Contract Type
Full Time
Data Warehouse Developer

Up to �300 pd (In Scope IR35), who has worked within NHS Patient records datasets and good experience of carrying out ETL tasks using SSIS, including the manipulation (and shredding) of XML, making use of XML Schema Definition (XSD files).

Duties and Responsibilities

The data warehouse developer will be required to:

Liaise with the PROMs developers to ensure that the data held in the PROMs system is accessible in a data warehouseready format.

Extract, transform and load XML data from the PROMs system into relational SQL tables in the NWIS Data Warehouse.

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.

Develop further ETL processes for the capture of patientlevel costing and National Joint Registry data, liaising as required with the relevant data providing organisations in order to agree appropriate methods of acquisition, and resolving any subsequent issues that arise.

Skills and Experience

It is essential that candidates have expertise in:

Microsoft SSMS, SSIS and ETL.

Experience of manipulating (and shredding) XML is also a prerequisite

Knowledge of XML Schema Definition (XSD files).

Contract deemed IN SCOPE of IR35 and the deadline for applications is Thursday 2nd November, at 5pm

SmartSourcing provides services as an Employment Agency and welcomes applications from all suitably qualified people regardless of age, race, religion, disability, age, gender or sexual orientation.

This job was originally posted as