Workforce Information Analyst

Devon Partnership NHS Trust; Exeter; On-site; GBP 30,000 - 40,000; Full time

Job summary

A healthcare organization in the UK is seeking a proactive Information Analyst to manage workforce data and reporting. The role involves working closely with a Senior Analyst on ETL processes, ensuring high-quality data management for reports and KPIs. Candidates should have experience in SQL querying, analytical skills, and the ability to develop Power BI dashboards. Joining this inclusive team will offer opportunities to improve mental health services across the region.

Benefits

Inclusive work culture

Flexible working options

Qualifications

• Considerable experience as an Information Analyst or similar role focused on data analysis.
• Experience with analytical systems and processes.
• Capability to manage conflicting agendas and prioritize tasks.

Responsibilities

• Provide high-quality workforce information and manage report timelines.
• Collaborate on ETL processes and develop Power BI dashboards.
• Answer ad-hoc queries and manage team mailbox responses.

Skills

Data analysis and reporting

SQL querying

Analytical skills

Power BI Dashboard creation

Organisational skills

Problem-solving

Education

GCE/GCSE including English and Mathematics

A level or equivalent experience

Degree level in IT or equivalent experience

Tools

R Studio

SQL Server/T-SQL

Excel

Job description

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.

Job responsibilities

Please see the attachedJob Description and Person Specification which will provide further informationon this role.

Person Specification

Experience

• 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
• 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

• Good general education to GCE/GCSE level to include English Language and Mathematics
• Educated to A level or equivalent experience
• Education to degree level (preferably in an IT discipline) or equivalent experience

Analytical Skills

• 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

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

Knowledge

• 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
• 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.