Connecting...

Data Warehouse Developer - SQL, SSMS, SSIS, ETL

Job Title: Data Warehouse Developer - SQL, SSMS, SSIS, ETL
Contract Type: Contract
Location: Cardiff
Industry:
Salary: £300 Per Day Umbrella - INSIDE IR35
Start Date: Nov 2017
Reference: JD%2FC%2F17008
Contact Name: Jackie Dean
Contact Email: jackie.dean@gsatechsource.com
Job Published: October 31, 2017 16:07

Job Description

Data Warehouse, Developer, SQL, SSMS, SSIS, ETL, XML, XSD

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 warehouse-ready” format.
• extract, transform and load XML data from the PROMs system into relational SQL tables in the 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 patient-level 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.

Support the identification of an appropriate solution which allows delivery of existing data services.

Understand current architecture, data structure, security requirements and business process. Consider hosting and security, Support solution design taking into account platform sizing, volumetric s, network connectivity, web services, web UI, ETL, data egress and data security.

It is essential that candidates have the following expertise in:

The use Microsoft SSMS & SSIS and ETL.
Experience of manipulating (and shredding) XML is also a pre-requisite. 
Knowledge of XML Schema Definition (XSD files).
Experienced in the development of data warehouse capability.

CV Submission Deadline: FRIDAY 3RD NOVEMBER @ 8:30am GSA Techsource Ltd operates as an Employment Agency when recruiting for permanent vacancies, and an Employment Business when recruiting for contract vacancies. All contract rates quoted are to Ltd companies.