Job overview
An exciting opportunity has arisen for a Business Intelligence and Provider Collaborative Analyst to join the Cheshire and Wirral Partnership (CWP) Commissioning Team under the new Lead Provider Collaboratives (LPC); Cheshire and Merseyside CYPMHS Collaborative and the North West Adult Eating Disorder Collaborative. This is an exciting opportunity for a motivated and enthusiastic applicant to lead on data extraction, analytics and scrutiny of people accessing specialised mental health services as part of the LPCs.
50% of this role sits within the Commissioning Team at CWP who are striving to be innovative, collaborative and outcomes focused as a commissioning function and this role provides a cornerstone to achieve this. The other 50% will sit within the Business Intelligence team working on a range of new projects and the continual rollout of PowerBI.
You will play a lead role within both the Business Intelligence and LPC teams in relation to data sourcing from the Trusts Enterprise Data Warehouse working closely with the Data Engineering and Modelling to design, develop and support data structures enabling the design and build of technological reporting solutions and visualisations.
Educated to degree level with advanced level skills in Microsoft SQL Server RDBMS, advanced level skill in SQL/TSQL and PowerBI.
For further details / informal chat contact:
Andrew Haws
Head of Information Management and Business Intelligence
Email - a.haws@nhs.net
01244 393150
Main duties of the job
Duties:
You will play a lead role in building effective relationships within the Trust and LPC and support the development of a continuous improvement culture, through the delivery of high-quality performance data and information. This is an important role, in which you will be responsible for data quality and benchmarking as well as ensuring information is reported accurately, consistently, and effectively for performance reporting and providing information that supports business decisions. You will be involved in analysis, ad hoc reporting, root cause analysis of key issues for the Trust, and production of various performance papers and reports.
You will need to have excellent knowledge of data analysis and strong communication and interpersonal skills. You will need to be able to demonstrate proven experience working in an information-related role and in extracting information from a variety of systems. NHS information management experience would be an advantage but is not essential.
Experience of using Microsoft SQL Server RDBMS and SQL/TSQL at an advanced level are essential, as well as a strong working knowledge of PowerBI. Experience and knowledge of Microsoft Reporting Services (SSRS) is desirable as well as Data Modelling and Development Lifecycle principle.
You will provide information to Executive leads within the organisation consequently, excellent reporting and interpersonal skills are required, as is a professional approach.
Working for our organisation
CWP provides health and care services for local people, including mental health, learning disability, community physical health and all-age disability care – including the provision of three GP surgeries.
Our aim is to help people to be the best they can be, adopting a compassionate, person-centred approach to everything we do. We were recently rated as Outstanding for Caring by the Care Quality Commission with a Good rating overall.
We offer a variety of roles at all levels, so whether you are just starting out in your career or looking to use your skills and experience in a new role, CWP is the right employer for you.
CWP are committed to making our recruitment practices as inclusive as possible for everyone. We are committed to promoting equality and diversity and developing a culture that values differences.
To support this, we offer up to three weeks induction, dependent on role, with our Prepare to Care programme for all new starters. This programme welcomes you to CWP and provides you with information and training to support you in your role.
We welcome applications from people who have direct experience of accessing our services.
Detailed job description and main responsibilities
Please download a copy of the job description for full details.
Recruitment selection processes are based on competence (see Person specification) and values.
CWP recruits people that can demonstrate the Trust’s Values and Behaviours in their everyday life. Therefore, if you are invited to interview, you will be undertaking a Values Based Interview/Assessment, which explores not only what you do but how and why you do it.
Before applying, we encourage you to review the Trust’s Values and Behaviours which are ‘the 6 Cs’ Communication, Competence, Courage, Care, Compassion and Commitment. The supporting information section in your application should therefore reflect your understanding of the Trust’s Values and associated behaviours. You will be expected to provide us with examples from work experience and/or personal life which demonstrate these values through your behaviour.
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 – 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.
CWP is proud to be an accredited Veteran Aware organisation helping to provide and share best practice in NHS care for our armed forces community. As a veteran aware organisation, CWP is committed to delivering on the principles of the Armed Force Covenant and has a ‘Silver’ award with the MOD Defence Employer Recognition Scheme (DERS).
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 £13 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.
If you experience any technical difficulties or need help when making an application please contact our Recruitment Team on 01244 393100.
Good luck with your application. We hope to welcome you to Team CWP very soon.
Person specification
Qualifications
Essential criteria
* Highly technically proficient with extensive experience in Database Design, extraction and manipulation or Educated to master’s degree level in relevant technical subject.
* Evidence of further professional development e.g. a certificate in use of SQL server or Advance use of Microsoft Office applications.
Desirable criteria
* Member of ASSIST, BCS, UKCHIP or other relevant professional body
Knowledge and Expertise
Essential criteria
* Advanced-level skill in Microsoft SQL Server RDBMS
* Advanced-level skill in SQL/TSQL
* Advanced-level skill in SQL/TSQL
* Advanced keyboard skills
* Power BI
Desirable criteria
* Advanced-level skill in SSRS
* Knowledge of Data Warehouse Modelling theories
* Knowledge of development lifecycle
Experience
Essential criteria
* Minimum of 3 years’ experience designing, developing and implementing small to medium-sized IT systems
* Experience of translating business requirements into information/system requirements
Desirable criteria
* NHS experience working in Informatics, within a Mental Health Trust
* Experience working in a business intelligence environment