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. About us 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. Date posted 17 April 2025 Pay scheme Agenda for change Band Band 6 Salary £37,338 to £44,962 a year per annum Contract Permanent Working pattern Full-time Reference number 373-CSS1151 Job locations Redesmere Countess of Chester Health Park Chester CH2 1BQ Job description Job responsibilities Please download a copy of the job description (see documents to download section below) for full details of the main responsibilities for this role. At CWP, our recruitment selection processes are based on both competence (see person specification for details) and values. CWP recruits people that can demonstrate the Trusts Values in their everyday life and we use a values-based approach in our interviews, which explores not only what you do but how and why you do it. Before applying, we encourage you to review the Trusts Values and think about how these align with your own personal values. The supporting information section in your application should reflect your understanding of the Trusts Values and associated behaviours and you should provide examples from your work experience and/or personal life which demonstrate these values through your behaviours. An applicant guide to help and support you through your recruitment journey can be accessed at the bottom of this page. Further help and support for completing your application can be accessed via our website. If you need any further guidance to help you complete your application, contact our recruitment team via email at: cwp.recruitmentnhs.net or by calling 01244 393100. If you have a disability that meets the definition set out in the Equality Act 2010, and you can show that you meet the essential criteria described in the person specification for an available position, please answer YES to the question: Do you wish to be considered under the Guaranteed Interview Scheme? Please inform the team if you have any special support needs to be considered as part of the interview and selection processes. The trust offers a Guaranteed Interview Scheme to any armed forces community applicants who meet the essential criteria for the post and encourages applications from armed forces reservists or cadet force adult volunteers.Please note applicants will be required to pay for their DBS check. Costs are deducted from salary following appointment. You are encouraged to enrol for the DBS Update Service. A small annual fee of £16 per year applies.New entrants to the NHS will commence on the minimum of the scale stated above.Applicants are advised to apply early as if a large number of applications are received for this post we reserve the right to close the vacancy prior to the advertised date.Good luck with your application. We hope to welcome you to Team CWP very soon Job description Job responsibilities Please download a copy of the job description (see documents to download section below) for full details of the main responsibilities for this role. At CWP, our recruitment selection processes are based on both competence (see person specification for details) and values. CWP recruits people that can demonstrate the Trusts Values in their everyday life and we use a values-based approach in our interviews, which explores not only what you do but how and why you do it. Before applying, we encourage you to review the Trusts Values and think about how these align with your own personal values. The supporting information section in your application should reflect your understanding of the Trusts Values and associated behaviours and you should provide examples from your work experience and/or personal life which demonstrate these values through your behaviours. An applicant guide to help and support you through your recruitment journey can be accessed at the bottom of this page. Further help and support for completing your application can be accessed via our website. If you need any further guidance to help you complete your application, contact our recruitment team via email at: cwp.recruitmentnhs.net or by calling 01244 393100. If you have a disability that meets the definition set out in the Equality Act 2010, and you can show that you meet the essential criteria described in the person specification for an available position, please answer YES to the question: Do you wish to be considered under the Guaranteed Interview Scheme? Please inform the team if you have any special support needs to be considered as part of the interview and selection processes. The trust offers a Guaranteed Interview Scheme to any armed forces community applicants who meet the essential criteria for the post and encourages applications from armed forces reservists or cadet force adult volunteers.Please note applicants will be required to pay for their DBS check. Costs are deducted from salary following appointment. You are encouraged to enrol for the DBS Update Service. A small annual fee of £16 per year applies.New entrants to the NHS will commence on the minimum of the scale stated above.Applicants are advised to apply early as if a large number of applications are received for this post we reserve the right to close the vacancy prior to the advertised date.Good luck with your application. We hope to welcome you to Team CWP very soon 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 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). Additional information 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). Employer details Employer name Cheshire and Wirral Partnership NHS Foundation Trust Address Redesmere Countess of Chester Health Park Chester CH2 1BQ Employer's website https://www.cwp.nhs.uk/about-us/working-for-us/ (Opens in a new tab)