Data Warehouse Solution Specialist

Data Warehouse Solution Specialist – NHS, Healthcare

A leading provider of health data analytics solutions is looking for an enthusiastic and innovative Data Warehouse Solution Specialist to join a small team.

Required Skills:

  • Ability to communicate effectively across organisational, technical and political boundaries
  • Specifying and designing inter-departmental or cross organisation data warehouses
  • T-SQL and SSIS development
  • .NET programming in VB or C#
  • Presentation and visualisation skills
  • Ability to reverse engineer a data model from a live system
  • Fluent in tools and techniques for modelling and communicating processes and data flows
  • 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
  • Dimensional analysis and modelling
  • Complex modelling issues such as temporal stability and divergent coding of data

Responsibilities:

  • Liaise 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

Desirable Skills:

  • Knowledge of a variety of BI tools such as Qlikview, Business Objects, IBM Cognos, Microsoft Power BI/SSAS, Tableau
  • Process and data modelling in acute healthcare
  • Message based and enterprise service bus technologies including HL7 and FHIR
  • Statistical process improvement/Six Sigma/CMMI/Lean
  • Simulation and numerical modelling techniques and software such as Simul8
  • Development of test data
  • Machine Learning and AI
  • Scrum/Agile, ISO 27001 and ITIL

The Data Warehouse Solution Specialist role offers the opportunity to make a significant contribution to the software that consultants and customers use to make real differences to people’s lives.

The company offer a competitive basic salary and a comprehensive benefits package, including Bupa private healthcare insurance and 25 days annual leave.

The Data Warehouse Solution Specialist role will be home working for the foreseeable future, the plan is for a scheduled return to the office in due course. Travel within the UK to client sites will normally be required.

Excellent opportunity, please apply for a prompt response.

To apply for this job email your details to info@rdkc.co.uk.