The post holder will be responsible for supporting the Trusts Data Modelling team in the following areas:
1. Working with Clinical and Support Services to design, develop and support data structures enabling the design and build of technological reporting solutions and visualisations.
2. Utilise knowledge of core data warehouse components including data loaders; datasets; data transformations; data mappings and lookups; and scheduled processes.
3. 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.
4. 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.
5. 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.
6. 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.
7. 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.
8. 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.
9. 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.
10. Work with BI team and manage the effective roll-out of reporting visualisations and solutions working within CWP’s standard hardware/software offering.
Cheshire and Wirral Partnership (CWP) provides health and care services for a population of over one million people, including mental health, learning disability, community physical health and all-age disability care, as well as the provision of three GP surgeries in Cheshire.
We employ around 4,500 staff across 73 sites and have services across Wirral and Cheshire, as well as Trafford, Warrington, Bolton, Halton and Liverpool. We also provide specialist services for the North West as a whole.
Our aim is to help improve the lives of everyone in our communities, adopting a compassionate, person-centred approach to everything we do. We are rated as Outstanding for Caring by the Care Quality Commission, with a Good rating overall.
As a Disability Confident Employer, Rainbow Badge Scheme member, Veteran Aware organisation and proud holder of the Armed Forces Covenant Employer Recognition Scheme Gold Award, CWP is committed to making our recruitment practices as inclusive as possible and developing a culture that values differences, and welcome applications from people who have direct experience of accessing our services.
We also offer up to three weeks’ induction, with our Prepare to Care programme for all new starters. This aims to give you all the knowledge and guidance to help you hit the ground running with CWP.
Whether you are just starting out in your career or looking to use your existing skills and experience in a new role, you’ll find something to suit you at CWP.
For further details / informal visits contact: Name: Andrew Peter Haws Job title: Head of Information Management and BI Email address: a.haws@nhs.net Telephone number: 07766498133
If you consider yourself Neurodivergent and need help to complete your application form, please contact cwp.recruitment@nhs.net or telephone 01244 393100
#J-18808-Ljbffr