Associate Data Modeller: Sponsorship Available

Cheshire and Wirral Partnership NHS Foundation Trust

Job Summary

The post holder will be responsible for supporting the Trusts Data Modelling team in the following areas:

  • working with Clinical and Support Services to design, develop and support data structures enabling the design and build of technological reporting solutions and visualisations.
  • Utilise knowledge of core data warehouse components including data loaders; datasets; data transformations; data mappings and lookups; and scheduled processes.
  • Ensure that highly complex data sets are created and available to the trust through robust data load procedures which maximise the use of automated routines.
  • Using enhanced technical skills to model data enabling the development of clinical and corporate reporting dashboards, to present data as business information that will assist managers in making strategic decisions, and help service managers to manage their services effectively based on the activity recorded in the Trust’s clinical and non-clinical based systems which is processed by the data warehouse.

Main duties of the job

Assist with the technical design and development of data modelling solutions and work with wider BI team to ensure that the models are interpreted correctly and built using the most appropriate data sources to reflect business requirements.

Work with BI team to create and support automation of ETL routines for the extraction and processing of complex data from source database systems and text based data extracts where appropriate. Adapt existing processes to meet new requirements.

Assist with the development of clinical and corporate reporting dashboards, to present data as business information that will assist managers in making strategic decisions, and help service managers to manage their services effectively based on the activity reported in the Trust’s clinical and non-clinical based systems that is processed by the data warehouse.

Assist with the creation and maintenance of technical specifications, including source to target mappings, in support of developments which can be interpreted by Data Warehouse developer or 3rd party supplier.

Assist with the creation and maintenance of reference data where required utilising process control and master data management principles across current system configurations and future developments.

Work with BI team and manage the effective roll-out of reporting visualisations and solutions working within CWP’s standard hardware/software offering.

Person Specification

Qualifications

Essential

  • Educated to degree level in a relevant discipline or equivalent experience

Desirable

  • Member of ASSIST, BCS, UKCHIP or other relevant professional body
  • Additional qualification in a technology or information discipline

Knowledge and Expertise

Essential

  • Significant experience in Microsoft SQL Server RDBMS
  • Significant experience in SQL/TSQL
  • Advanced-level skill in SSIS and SSAS
  • Knowledge of SSRS
  • Advanced keyboard skills

Desirable

  • Advanced-level skill in SSRS
  • Experience of Qlikview/QlikSense/PowerBI
  • Knowledge of Data Warehouse Modelling theories.
  • Knowledge of development lifecycle

Experience

Essential

  • Minimum of 2-3 years’ experience designing, developing and implementing small to medium-sized IT systems
  • Expert data analysis skills
  • Experience of complex data query, extraction and manipulation tools such as SQL Server, SQL Reporting, SSIS etc.

Desirable

  • NHS experience working in Informatics, within a Mental Health Trust
  • Experience working in a business intelligence environment

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Closing Date: 01 May 2025

To apply for this job please visit apps.trac.jobs.