Senior Workforce Information Analyst

Job responsibilities

JOB SUMMARY

The post holder will be required to work with delegated authority from the People Planning and Performance Lead to manage Trust-wide Workforce Information systems, both in the continuous development and maintenance of systems and processes to enable the Trust to effectively manage and use information to support clinical needs and strategic business planning. They will provide in-depth analysis of workforce information, identifying trends and hot spots, benchmarking workforce data both internally and externally to the Trust and triangulating data with other Trust data sources. The role will be pivotal in progressing and maintaining a quality and responsive service to internal and external stakeholders, helping to develop workforce reports using the Trusts business intelligence tools and methodologies.

The post holder will use their initiative to identify opportunities for improvements and to produce high quality outputs, as well as prioritise their workload, work independently and professionally and with flexibility to meet the high demands of the post. Must be able to work under pressure, to tight deadlines exercising a high degree of autonomy, initiative and professionalism.

KEY RESULT AREAS:

The postholder will:

1.1 Care/service/function provision:

Establish and maintain efficient reporting mechanisms by collaborating with Trust Services to understand their business needs and how the People Planning & Performance Function can provide workforce information support.

Ensure the implementation of robust reporting systems that meet the requirements of the Trust Board, Performance Boards, Data Warehouse, and statutory bodies such as NHS England, NHS Improvement, Health Education England, and the Department of Health.

Offer expert guidance to colleagues across the wider team, ensuring the production of high-quality workforce information reports in appropriate formats for the intended audience.

Assist colleagues within the People Directorate in ensuring the accuracy and high standard maintenance of data held in the Electronic Staff Record (ESR). Support regular audits and data validation exercises conducted by the teams responsible for data management and input.

Develop and implement data governance frameworks and processes, where appropriate, to ensure the accuracy, integrity, and security of workforce data across the Trust.

Conduct highly complex workforce analysis, leveraging business intelligence tools and statistical analysis techniques to triangulate workforce information with finance and activity data. Identify trends and link them to the Trust's strategic aims.

Perform comprehensive analysis of people data, identifying patterns, trends, and improvement opportunities related to areas such as recruitment, retention, employee engagement, and workforce planning.

Contribute to the development and maintenance of data visualisation dashboards and interactive reporting tools to enhance data accessibility and promote self-service analytics.

Support workforce planning initiatives by conducting workforce scenario modelling, forecasting, and gap analysis. Provide strategic and tactical recommendations to address workforce challenges and optimise resource allocation.

Support the continuous development of Trust's business intelligence (BI) tools and methodologies, enabling effective workforce reporting. Provide training and support to users and collaborate with services to embed these tools.

Interpret workforce information and Key Performance Indicators (KPIs), advising key stakeholders within the People Directorate, Service Managers and Leads, and other relevant colleagues on trends and areas requiring attention. Offer advice and potential solutions to address issues, as needed.

Respond to data requests and obligations by preparing cyclical and ad-hoc benchmarking reports for internal and external audiences and stakeholder groups. Ensure compliance with local and national requirements.

Provide specialist knowledge and advice on various workforce information systems and methodologies. Effectively communicate complex technical issues to non-technical audiences and provide coaching and training to Trust staff on the effective use of workforce information systems and reporting tools.

Contribute to the development and refinement of policies and procedures directly impacting the systems under the purview of this role.

Support the implementation of workforce systems and provide expert advice on workforce information requirements.

1.2 Working as part of a Team:

Act as a subject matter expert in workforce information analysis, providing guidance and mentoring as appropriate, contributing to a culture of knowledge sharing and professional development within the People Planning & Performance Function.

Collaborate with stakeholders within the People Directorate to understand their data and reporting requirements, specifically related to workforce management and people analytics.

Manage effective relationships with stakeholders from across the Trust, acting as a first point of call for workforce reporting related queries and activities, leveraging sound team working to ensure the best possible levels of service are maintained.

Responsibly represent the People Planning and Performance Function, in a variety of forums, both internally and externally.

1.3 Managing Self:

Stay up-to-date with emerging trends and advancements in data analytics, business intelligence tools, and workforce planning methodologies. Apply this knowledge to enhance the Trust's workforce information capabilities and drive continuous improvement.

Manage highly complex or sensitive information that might affect staff and where appropriate, recommend evidence-based solutions in line with Human Resource policy.

Deputise, where appropriate, for the People Planning & Performance Lead at key service meetings to determine the implications arising for possible workforce reporting activity.

1.3 Trust Values:

The Trust is committed to ensuring the highest standards of care and treatment and expects that all staff treat people e.g, service users, their carers, relatives, friends, colleagues, visitors etc, with dignity and respectat all time. The post holder must all time act in accordance with the Trusts Values:

Honest, open, transparent

Respectful

Person first and in the centre

Improve and be outstanding

Relevant today, ready for tomorrow

Families and carers matter

1.4 Safeguarding:

Report any concerns regarding the safety or wellbeing of children, adults service users, members of their families etc, in accordance with Trust Policy.

Prevent and respond appropriately to abuse and understand own role in this by undertaking Safeguarding training.

For full details of the role please see the supporting documents attached.

Qualifications

Essential

• Degree in a related subject or able to demonstrate competencies working at that level in NHS Information department

Desirable

• Computing, IT or Data-related qualification

Experience

Essential

• NHS experience or experience in an information department working with large datasets
• Experience of making judgements involving complex facts or situations requiring analysis and interpretation from a range of options.
• Development and ongoing maintenance of relational databases preferably using Access, Oracle, SQL Server or similar
• Use and application of business data standards and data definitions
• Management and analysis of data in a variety of structures
• Experience of staff management/supervision including day to day supervision, appraisal, objective setting, and development of staff
• Experience of project working as a project manager or a team member
• Communication using a variety of media
• Teamworking

Desirable

• Development and maintenance of Data Warehouse applications
• Project Management using PRINCE2 methodology
• NHS Information background - preferably within HR/Workforce Information
• Training Delivering to end users
• Understanding of change management practices and principles.
• Use and application of NHS data standards and data definitions

SPECIAL KNOWLEDGE/SKILLS

Essential

• Ability to manipulate complex datasets and understand complex data relationships
• Ability to assess impact of system enhancements and amendments considering the implications to end users (administrative & clinical) and reviewing appropriateness of end user system access levels.
• Strong knowledge and understanding of Microsoft Office Suite particularly Access and Excel
• High-level of data presentation skills using various software
• Sound working knowledge of project management techniques
• Clear understanding of the principles of confidentiality and associated legislation and guidelines, e.g., GDPR and Data Protection Act
• Advanced PC skills use of keyboard, mouse, excellent working knowledge of Windows software and/or other mainstream operating systems
• Ability to analyse and interpret service requirements and implement solutions
• Ability to communicate at all levels, both internally and externally

Desirable

• Understanding of Power Apps (Power BI, Power Automate, Power Query, etc)
• Understanding of clinical governance
• Understanding of the National IT agenda and its implications for NHS organisations
• Familiarity with NHS terminology
• Customer care skills
• Knowledge of project management applications
• Advanced data analysis skills to interrogate, interpret and present complex data to meet customer needs
• Expertise in NHS Workforce Systems (eg ESR, Time & Attendance, e-Rostering)

TRAINING

Essential

• Proven commitment to personal development as evidenced through attendance at a range of training/development events
• Evidence of training in leadership / team development.
• Evidence of Systems Training

Desirable

• SQL - Data management and interrogation products
• Standard software applications including Microsoft and other mainstream packages

PERSONAL ATTRIBUTES

Essential

• Ability to work well within a team and supervise other team members for project programme work
• Capable of independent judgement.
• Ability to use initiative and work without supervision
• Ability to manage and prioritise own workload
• Flexible approach to working hours
• Ability to work across the Trust
• Ability to respond flexibly to changing departmental priorities

Desirable

• Exceptional negotiating skills with the ability to influence others

PHYSICAL ATTRIBUTES

Essential

• Ability to undertake the duties and demands of the post
• A satisfactory sickness record over the previous 2 years (subject to the need to act with fairness and equality of opportunity, particularly where the sickness is related to a disability and/or pregnancy).