Workforce Information Analyst
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.
Job description
Job responsibilities
Please see the attached Job Description and Person Specification which will provide further information on 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
- Attention to detail
- 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.
- Knowledge of NHS processes
Employer details
Employer name
Devon Partnership NHS Trust
Address
Wonford House
Dryden Road
Exeter
Devon
EX2 5AF
Employer's website
https://www.dpt.nhs.uk/