Data Modeller & Data Modelling

Posted on Jul 4, 2019 by CV-Library

South Glamorgan, United Kingdom
Wholesale Trade
Immediate Start
£300 - £350 Daily
Contract/Project
Description:

Performing analysis to produce logical Data Models. Gather and review data to produce system data models. Distributing data and resolving issues raised. Modelling and analysing data. Responding to requests for analysis. Develop processes for maintaining data across internal and external sources.

Minimum Requirement:

1) SQL and SSIS

2) Problem solving around data models

3) Understanding of the business needs

SQL and SSIS, Microsoft sml data and basic sequal servor

A new area of work for the data warehousing team, to try and gather data from patients and those surveys need to be transferred into sql tables to make available the need is for extra hands and someone with experience in the area.

Performing analysis to produce logical Data Models. Gather and review data to produce system data models. Distributing data and resolving issues raised. Modelling and analysing data. Responding to requests for analysis. Develop processes for maintaining data across internal and external sources.

• Design and implement an ETL pipeline and generic data model that has the ability to consume many different styles of XML data from the PROMs system into a relational generic future proofed data model.

• Liaise with stakeholders to ensure that the data held in the above implementation is accessible in an approved data standard format.

• Liaise with users to establish new data products requirements and then develop these data products, linking 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.

• Attend daily SCRUMS to update what happened yesterday and what will happen today.

Skills and Experience

It is essential that candidates have the following expertise in:

• Good problem solving skills with the ability to resolve technical issues by means of their own research

• Effective communicator

• The use Microsoft SQL and SSIS to create pipelines.

• Experience of manipulating (and shredding) XML (with or without XSD files) is also a pre-requisite

• Data modelling

• Dimensional modelling

• Data Pipeline development

• Produce clear and concise documentation

Security Clearance: BPSS

CV Deadline: Monday 10am

Reference: 210348172

Similar Jobs

Civil Design Engineer

Cardiff, South Glamorgan, United Kingdom

£28k - £36k Annual

Service Engineer

South Glamorgan, United Kingdom

£0 - £0 Annual

Civil Engineering Technician

Cardiff, South Glamorgan, United Kingdom

£30k - £35k Annual

Civil Design Engineer

Cardiff, South Glamorgan, United Kingdom

£30k - £40k Annual