Data Warehouse Archiect

Recruiter
Hunter AHP & Mental Health
Location
Leicester, UK
Salary
Competitive
Posted
02 Sep 2019
Closes
17 Sep 2019
Ref
1240510982
Contract Type
Permanent
Hours
Full Time
Our client, an NHS organisation based in the East Midlands, is looking to hire a Data Warehouse Architect. In this role the Data Warehouse Architect will lead a SQL Server 2016 upgrade. They need will need to manage and deliver the project plan, complete the build and its optimisation.

Main Duties:
  • Deliver the project plan and upgrade to SQL Server 2016
  • Analyse of the current architecture of the data warehouse
  • Develop a report to highlight the benefits and any risks of changing to a more efficient architecture
  • Put together a description of how they would set up the architecture and how it would look
  • Produce a SOP for the extraction process including the use of a staging area for cleaning and processing the data before loading into the data warehouse
  • Improve on speed of SQL Queries ran through visualisation tool
  • Lead on automation

Main Skills/ Experience (Essential and desirable)
  • Previous experience writing project plan and delivering a SQL Server 2016 upgrade within the NHS
  • Knowledge or practical experience working with mental health data sets
  • Excellent understanding of Data Warehouse Architecture
  • Understanding of SystmOne extracts

Similar jobs

Similar jobs