Devon Partnership NHS Trust

Workforce Information Analyst

The closing date is 11 January 2026

Job summary

An exciting opportunity has arisen for a process-oriented, enthusiastic and proactive individual to join our small and busy Workforce Information team. Working directly with senior leads in Workforce and across the Organisations, you will manage provision of certain aspects of information / reporting and work closely with our Senior Workforce Information Analyst to deliver other requirements in partnership. You will be working alongside our Senior Workforce Information Analyst for a period of up to 12 months covering the current postholder's internal secondment.

In this unique role, you will work with the Senior Workforce Information Analyst to help with the Extraction, Load and Transformation (ETL) process of Workforce data from the Electronic Staff Record (ESR) and Healthroster systems to create / update various Workforce reports. This will be using a wide variety of tools such as R Studio, SQL (including subqueries / CTEs), Power BI and Excel. There is a wide support network available to you with various subject matter experts (SMEs) in these areas.

Main duties of the job

The main responsibilities of the role are provision of high-quality and timely workforce information, managing both a scheduled report timeline and delivery of ad-hoc queries such as Freedom of Information requests.

You will hold responsibility for certain of our scheduled reports and Key Performance Indicators (KPIs), ensuring delivery in a timely way with accurate data sets and validated information. You will also be responsible for answering some ad-hoc queries, working within the team mailbox to manage responses and allocation of work.

There will be some elements of development work as we move forward with our workforce reporting into a more interactive and focused presentation rather than purely spreadsheets. This may involve some development of Power BI Dashboards.

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.

Date posted

18 December 2025

Pay scheme

Agenda for change

Band

Band 5

Salary

£31,049 to £37,796 a year

Contract

Fixed term

Duration

12 months

Working pattern

Full-time, Flexible working

Reference number

C9369-25-0703

Job locations

Wonford House

Dryden Road

Exeter

Devon

EX2 5AF

Job description

Job responsibilities

Please see the attached Job Description and Person Specification which will provide further information on this role.

Job description

Job responsibilities

Please see the attached Job Description and Person Specification which will provide further information on this role.

Person Specification

Experience

Essential

Considerable experience working as an Information Analyst or equivalent experience in a role which is focused on data analysis and reporting
Experience of working with analytical systems and processes
Experience of querying in an SQL Language
Understanding and significant experience of relational databases

Desirable

Experience of working in the NHS or Public Sector.
Experience of identifying and managing areas where there are shared and conflicting agendas.
Ability to manage and prioritise own and related work in line with organisational priorities
Experience of working on projects to deliver quality outcomes to deadline and identifying risks.
Experience of SQL Server / T-SQL

Qualifications

Essential

Good general education to GCE/GCSE level to include English Language and Mathematics
Educated to A level or equivalent experience

Desirable

Education to degree level (preferably in an IT discipline) or equivalent experience

Analytical Skills

Essential

Ability to work with large amounts of data using critical faculties to closely check the outputs and verify accuracy
Ability to interpret complex information for a wider audience
Ability to complete complex tasks to tight deadlines

Planning and Organising Skills

Essential

Ability to prioritise and work well under pressure
Can meet challenging and conflicting deadlines
Organised and methodical
Dependable and reliable
Attention to detail
Ability to problem solve
Can work on ones own
Can work within a team

Knowledge

Essential

Strong analytical and requirements gathering skills.
Be able to interpret results from the analysis, apply the results to the given problem and suggest conclusions to be drawn.
Able to present and explain results of analysis via written and verbal communication.
Knowledge of creation and maintenance of Power BI Dashboards
Good working knowledge of Spreadsheets with experience of wider functionality including use of pivot tables and formulae
IT skills particularly Microsoft Office applications and use of Internet, Intranet and email

Desirable

Knowledge of DAX/M Coding
Knowledge of R Studio
Knowledge of ESR and HealthRoster
Understanding of a wide range of data quality issues and the application of the appropriate data validation techniques
Good working knowledge and experience of databases including database interrogation tools.
Knowledge of NHS processes

Person Specification

Experience

Essential

Considerable experience working as an Information Analyst or equivalent experience in a role which is focused on data analysis and reporting
Experience of working with analytical systems and processes
Experience of querying in an SQL Language
Understanding and significant experience of relational databases

Desirable

Experience of working in the NHS or Public Sector.
Experience of identifying and managing areas where there are shared and conflicting agendas.
Ability to manage and prioritise own and related work in line with organisational priorities
Experience of working on projects to deliver quality outcomes to deadline and identifying risks.
Experience of SQL Server / T-SQL

Qualifications

Essential

Good general education to GCE/GCSE level to include English Language and Mathematics
Educated to A level or equivalent experience

Desirable

Education to degree level (preferably in an IT discipline) or equivalent experience

Analytical Skills

Essential

Ability to work with large amounts of data using critical faculties to closely check the outputs and verify accuracy
Ability to interpret complex information for a wider audience
Ability to complete complex tasks to tight deadlines

Planning and Organising Skills

Essential

Ability to prioritise and work well under pressure
Can meet challenging and conflicting deadlines
Organised and methodical
Dependable and reliable
Attention to detail
Ability to problem solve
Can work on ones own
Can work within a team

Knowledge

Essential

Strong analytical and requirements gathering skills.
Be able to interpret results from the analysis, apply the results to the given problem and suggest conclusions to be drawn.
Able to present and explain results of analysis via written and verbal communication.
Knowledge of creation and maintenance of Power BI Dashboards
Good working knowledge of Spreadsheets with experience of wider functionality including use of pivot tables and formulae
IT skills particularly Microsoft Office applications and use of Internet, Intranet and email

Desirable

Knowledge of DAX/M Coding
Knowledge of R Studio
Knowledge of ESR and HealthRoster
Understanding of a wide range of data quality issues and the application of the appropriate data validation techniques
Good working knowledge and experience of databases including database interrogation tools.
Knowledge of NHS processes