Job requirements
Essential
15 listedRequirements the employer expects applicants to meet.
- Experience
Strong knowledge of creation and maintenance of Power BI Dashboards
- Experience
Good working knowledge of Spreadsheets including use of pivot tables and formulae
- Experience
Considerable experience working as an Information Analyst or equivalent experience in a role which is focused on data analysis and reporting
- Experience
Experience of working with analytical systems and processes
- Experience
Experience of identifying and managing areas where there are shared and conflicting agendas.
- Experience
Experience of querying in an SQL language
- Experience
Experience of working on projects to deliver quality outcomes to deadline and identifying risks.
- Qualifications
Good general education to GCE/GCSE level to include English Language and Mathematics
- Qualifications
Educated to A level or equivalent experience
- Knowledge and skills
Strong analytical and requirements gathering skills.
- Knowledge and skills
Able to present and explain results of analysis via written and verbal communication.
- Knowledge and skills
Understanding of a wide range of data quality issues and the application of the appropriate data validation techniques
- Knowledge and skills
Able to communicate effectively with both external and internal customers and colleagues to understand the work required and present or explain work completed.
- Knowledge and skills
Ability to complete complex tasks to tight deadlines and deal with challenging / conflicting deadlines
- Knowledge and skills
Ability to prioritise and work well under pressure
Desirable
2 listedAdditional qualities the employer would prefer.
- Experience
Experience of working in the NHS or Public Sector.
- Qualifications
Education to degree level (preferably in an IT discipline) or equivalent experience
Job summary
An exciting opportunity has arisen for a process-oriented, enthusiastic and proactive individual with strong Power BI and SQL skills and the willingness to learn advanced NHS Workforce coding datasets to join our small and busy Workforce Systems and Information Team. Working directly with senior leads in Workforce and across the Organisation, you will manage provision of key aspects of information / reporting related to Operational Planning and activity. You will be supporting our Workforce Planning and Systems Manager directly as well as working closely with our Workforce Information Analysts.
In this specialist role, you will develop new processes to support operational planning, data collection and monitoring as well as creating / updating Workforce reports. This will be done using a wide variety of tools, such as R Studio, SQL (including subqueries/CTEs), Power BI and Excel.
Interviews will be held on Thursday 24th September.
Main duties of the job
The main responsibilities of the role are to support the Workforce Planning and Systems Manager in the delivery of the Operational Workforce Plan and in the delivery of ongoing information associated with the Operational Plan.
The role will include developing and administering the information production process and report delivery for Workforce Operational Planning monitoring and supporting the ongoing reconciliation with Finance. It will also include the provision of regular reports and ad-hoc requests for information in relation to the Trusts information needs in this area, using industry-standard tools such as SQL and Power BI as well as national templates.
You will develop and collate data and reports to deliver recruitment pipeline and widening participation engagement monitoring and analysis, working with our Senior Workforce Information Analyst on certain projects.
You will also work closely with Finance and Organisational Change leads on development of vacancy control monitoring and organisational change tracking.
About us
About Devon Partnership Trust
We provide mental health, learning disability and neurodiversity services, as well as a range of specialist & secure services for the wider south west region & nationally. We are passionate about promoting good mental health & wellbeing. We strive to use the expertise & resources within our organisation, and through our partnerships, to deliver high quality services that are safe & focused on people's recovery.
We are committed to developing a culture of coproduction, involving patients, families & carers in everything we do
Our values
We not only recruit based on qualifications & experience - we recruit individuals who possess & demonstrate the behaviours which underpin our Trusts core values. These include such attributes as showing a commitment to quality of care, improving lives of others, giving respect, dignity & compassion. We can bring those values to life in our everyday tasks by giving a smile; making time for people; challenging ourselves & others, & being open to new ideas.
We are committed to being an inclusive employer & applications are encouraged & welcomed from all sections of the community, regardless of any protected characteristics as governed by the Equality Act 2010. Part time & flexible working applications will be considered & supported, where possible. We particularly encourage applicants with lived experience of mental health conditions, neurodiversity or learning disabilities. We are a Disability Confident Leader.
Details
- Date posted: 11 September 2026
- Pay scheme: Agenda for change
- Band: Band 5
- Salary: £32,073 to £39,043 a year
- Contract: Permanent
- Working pattern: Full-time, Flexible working
- Reference number: C9369-26-0695
- Job locations: Wonford House, Dryden Road, Exeter, Devon, EX2 5AF, United Kingdom
Job responsibilities
Please see the attached Job Description and Person Specification which will provide further information on this role.
WhatsApp job alerts
Get instant WhatsApp alerts for Band 5 Analyst roles in Exeter
Create your Job Clerk account first. We'll collect your alert preferences during onboarding and help you turn on WhatsApp notifications for matching healthcare roles.
Applying for this NHS job
This advert is for Workforce Intelligence Analyst with Devon Partnership NHS Trust in Exeter, England. It is listed as a Band 5 Analyst role. The advertised salary is £32,073 to £39,043 a year. The contract type is Permanent. The application deadline is 18 Sep 2026.
Before you apply, compare the job description with the person specification and mirror the employer's essential criteria in your supporting information. Use the vacancy title, employer, location, salary, contract type, closing date and posted date (11 Sep 2026) to decide whether this role fits your current NHSjob search. If the employer can close applications early, prepare the application before the stated deadline rather than waiting for the final day.
For more context, review related Job Clerk pages for the same profession, band or location where they exist, then use the application-support guides to tailor your statement and prepare for interview.