This job has expired

Senior Data Warehouse Consultant / Architect - NHS Experience

Profectus Recruitment
Bracknell, UK
Closing date
22 Jan 2021

View more

Technology & New Media
Contract Type
You need to sign in or create an account to save a job.

Job Details

Profectus have an opportunity for a Senior Data Warehouse Consultant operating at an Architect level with its established client a consultancy based near Bracknell. They clients operate in the NHS, healthcare and emergency services sector.

In order to be considered for the position you must have previous experience with the NHS, ideally acute healthcare or social care as the position will involve meeting with and liaising with various NHS Trusts to deliver projects ranging from small scale data marts to large more complex solutions.

Key responsibilities for the position include:
  • Work with health business transformation consultants to capture requirements from stakeholders and system sponsors
  • Work with health business subject matter experts to understand and document the client's data assets
  • Produce and communicate logical and conceptual health models of key business processes and data flows using use case, process diagrams or other appropriate visualisation tools
  • Assess data availability, suitability and quality
  • Help identify possible transformation initiatives. Assist with re-packaging such initiatives for use with other clients
  • Producing logical and outline physical designs for target data warehouses
  • Specify transformation, linking and data re-coding rules
  • Provide data structures that can be synchronised with data integrity maintained
  • Identifying key project risks and work with the project manager to mitigate these
  • Communicating solution requirements to other technical consultants and system builders
  • Assist with creating a business data glossary and other key user documentation
  • Formulate plans for, and help manage, system testing and user acceptance testing

To be considered for the position you will need experience with the majority of the below;
  • Experience working in the Health Sector (NHS), building complex Data Warehouses to support process improvement
  • Ability to communicate effectively across organisational, technical and political boundaries, understanding the context
  • Ability to make complex and technical information and language simple and accessible
    for non-technical audiences
  • Experience of specifying and designing inter-departmental or cross organisation data
  • T-SQL and SSIS development
  • Presentation and visualisation skills
  • Process and data modelling in acute healthcare or social care
  • Ability to reverse engineer a data model from a live system
  • Fluent in tools and techniques for modelling and communicating processes and data
  • Experience of applying data to business transformation projects, measuring processes
    and progress towards outcomes
  • Creation of outline physical designs for data warehouses - targeting a relational DBMS, ideally SQL Server
  • Experience of dimensional analysis and modelling
  • Experience of dealing with more complex modelling issues such as temporal stability
    and divergent coding of data

If interested please apply for a copy of the full spec!
You need to sign in or create an account to save a job.

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert