Workforce Information Analyst

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.

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.

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.

Please see the attached

Job Description and Person Specification which will provide further information on this role.

• 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

• 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

• 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

• 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

• Strong analytical and requirements gathering skills.
• Be able to interpret results from the analysis, apply the…