Data Warehouse Developer Cardiff 300 pd
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 ExperienceIt 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 www.jobsite.co.uk/job/959431855