Hours Part time - 22.5 hours per week (To be negotiated at interview - Monday to Friday.)
Job ref 367-ACMS-9186-A
Employer: Hertfordshire Partnership NHS Foundation Trust
Employer type: NHS
Site: Prospect House with requirement to work at The Orchards, Hemel Hempstead and at Waverley Road, St Albans
Town: Watford
Salary: £29,970 - £36,483 per annum, pro rata (Inclusive of 5% HCAS)
Salary period: Yearly
Closing: 31/03/2025 23:59
Employer heading
NHS AfC: Band 5
Values Based Screener
At Hertfordshire Partnership Foundation Trust we are looking for people to join us who share our values and those of the NHS. Before your application can be considered please take part in our online values questionnaire, which you can find below. When you have finished, you will be sent a 'completion code' by email, which will be valid for 6 months and required to submit your application form.
Job overview
This is a key role in the Primary Care Mental Health Services - West. The role will aid in the development of and reporting of all of the PCMHS performance targets from team level to senior managers and providing support to the teams in meeting these targets. Your focus will be on the highly skilled use of Excel. This role will not require SQL, Python or Power BI (BI may be used in the future). Highly expert use of Excel will be essential for this role.
You will be required to work across PCMHS - West and potentially assisting similar reporting for PCMHS - East within HPFT to develop and provide information reports drawn from the patient database to support the achievement of targets and apply understanding of data quality to ensure information is correct.
You will require excellent analytical skills on Excel with experience of complex datasets, forecasting and reporting of organisational performance to Senior Managers using Excel. You will be expected to be highly numerate and have excellent communication skills.
Main duties of the job
1. To analyse, develop, interpret, and present performance information using Excel to a high standard, and support the services in promoting the use and understanding of information provided.
2. To support operational teams with the delivery of performance targets.
3. To monitor performance against service targets and give appropriate feedback using Excel and presentations such as on PowerPoint.
4. To support the management and achievement of waiting time targets across PCMHS.
5. To assist with the development and delivery of training for operational teams around the achievement of KPI targets.
6. To support the development and maintenance of the performance management framework involving high level skills in Microsoft Excel and other information systems as necessary.
7. High level analysis of data and interpretation of trends etc using Excel. Ability to reflect this graphically.
8. To support the development of systems, improving and adapting existing reports and designing reports for use by PCMHS staff.
9. Support the implementation of new performance management systems and communication with staff.
10. Work closely with the IM&T team in the development of performance management report writing.
Person specification
QUALIFICATIONS/EDUCATION/TRAINING
1. Degree level qualification or equivalent
2. Evidence of continuing professional development or equivalent experience.
PREVIOUS EXPERIENCE
1. Minimum of 2 years’ experience within large or complex organisation that necessitated working independently without day to day direction.
2. Understanding of performance principles and processes and ability to translate into working practices.
3. Understanding of data sources and performance information for both the Trust and within the wider NHS and social care agenda.
4. Experience of analysis and interpretation of complex information from different sources.
COMMUNICATION SKILLS
1. Ability to communicate verbally and written to senior managers and work effectively in partnership with them.
2. Ability to convey complex information in a clear and concise format.
3. Proven report writing skills.
4. Proven presentation skills.
ANALYTICAL SKILLS
1. Ability to analyse and interpret complex information and reflect this graphically.
2. Excellent IT skills including Excel, Word, PowerPoint.
3. Excellent eye for ‘detail’ and ability to proofread complex data within documents.
About us
Hertfordshire Partnership University NHS Foundation Trust (HPFT) is rated by the Care Quality Commission as a provider of mental health and learning disability services. In 2021, we won the prestigious Health Service Journal award for Mental Health Trust of the Year. Our staff rated us the 4th best mental health and learning disability trust to work for out of all 52 trusts in the country. Our staff tell us that they are proud to be part of the HPFT team, proud of the standard of care we provide and proud that service users are our top priority. Our people tell us they feel supported through a great development, wellbeing and work-life balance offer and a highly compassionate, values-driven culture.
If you would like to join a team to be proud of and you share our values and passion for great care and outcomes for our service users and carers, we would love to hear from you.
Additional Information
HPFT is committed to being an equal opportunities employer and in order to reflect the diversity of its population, positively encourages applications from all areas of the community. We aim to be a representative organisation with regards to age, disability, ethnicity, gender, beliefs and sexual orientation and are fully committed to equality, diversity and human rights and encourage applications from all sections of the community including users of mental health services.
The Trust is committed to helping staff balance work and home life and welcomes applications from candidates wishing to work part-time or under flexible working arrangements.
Infection Control
All our staff will need to comply with current Infection Prevention and Control measures which could include wearing a mask on all our Trust sites and in all roles.
Application numbers
This vacancy may close early if we receive a high number of applications. Please complete and submit your application promptly.
#J-18808-Ljbffr