Workforce Information Analyst

Islet Systems; Exeter; On-site; GBP 31,000 - 38,000; Full time

Job summary

A local healthcare provider is seeking a proactive Information Analyst to join their Workforce Information team in Exeter. In this role, you will assist with data extraction and transformation processes while managing report timelines and ad-hoc queries. The ideal candidate will have considerable experience in data analysis, specifically using SQL and Power BI. This position offers a fixed-term contract of 12 months with a competitive salary and opportunities for professional development.

Benefits

Flexible working options

Supportive team environment

Opportunities for professional development

Qualifications

• Considerable experience as an Information Analyst focusing on data analysis and reporting.
• Experience with analytical systems and processes.
• Ability to interpret complex information for a wider audience.

Responsibilities

• Provision of high-quality and timely workforce information.
• Managing scheduled report timelines and ad-hoc queries.
• Development of Power BI Dashboards.

Skills

Data analysis

SQL querying

Analytical skills

Power BI

Reporting

Problem-solving

Education

Good general education to GCE/GCSE level

Educated to A level or equivalent experience

Tools

Power BI

SQL Server/T-SQL

R Studio

Microsoft Office

Job description

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

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: 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 location: Wonford House, Dryden Road, Exeter, Devon, EX2 5AF

Job responsibilities

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

Experience

Essential

• Considerable experience working as an Information Analyst or equivalent role 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 one’s 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

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

Employer details

Devon Partnership NHS Trust

Address: Wonford House, Dryden Road, Exeter, Devon, EX2 5AF

Website: https://www.dpt.nhs.uk/