Workforce Information Trainee Analyst

Portsmouth Hospitals University NHS Trust; Newport; On-site; GBP 22,000 - 28,000; Full time

Benefits offered by this job

On-site Nursery

Beach Hut access

Wellness Centre with gym & pool

Staff networks: LGBTQ

Staff networks: Race Equality

Staff networks: DisAbility

Awards ceremonies

Job summary

Portsmouth Hospitals University NHS Trust is seeking a motivated Workforce Information Trainee Analyst to join the Workforce Information & Planning team. You will gain hands-on experience in data, reporting and business intelligence within the NHS setting.

You will work with experienced analysts to deliver routine and ad hoc workforce reporting, learn to automate processes and produce clear visual dashboards for managers and senior leaders across trust sites.

Qualifications

• Educated to Diploma level or equivalent experience.

Responsibilities

• Coordinate responses to workforce FOI requests and monitor team inboxes.
• Deliver training on dashboards and provide user support.
• Produce workforce reports and analytics for managers and leaders.
• Identify data quality issues and support improvement actions.
• Develop knowledge of workforce systems and BI tools.

Skills

Advanced IT skills

Effective communication

Time management

Attention to detail

Education

Diploma level or equivalent

Tools

Power BI

Power Query

MS Excel

ESR

RLDatix Optima

Job description

Specific Core Functions

• Responsible for the co-ordination, delegation and collation of responses to workforce related Freedom of Information requests.
• Monitor the team group mailboxes, answering ad hoc queries and delegating/ escalating tasks where appropriate.
• To manage access to the Workforce Insights Dashboard, and relevant Teams groups and to deliver training on our dashboards on a 1-1 or small group basis and reviewing and updating user guides as necessary.
• Update data on information systems to improve the quality and integrity of our reports.
• Develop skills in new technologies to support the team in improving and automating our current and future processes.
• To understand and interpret information requirements, assess the purpose for which the information is required and develop and deliver appropriate solutions using various information tools and techniques.
• Escalate issues of concern to the Principal Workforce Analyst, identify any trends or areas which require further in-depth analysis.
• The successful candidate will work closely with experienced Workforce Analysts, supporting the production of routine and ad hoc workforce information, delivering reporting solutions and helping to improve data quality across a range of workforce systems.
• We welcome applications from individuals with strong IT and analytical skills who are eager to learn and develop their expertise in workforce information, reporting tools and business intelligence systems.
• Support the production and delivery of workforce reports and analytics for managers, senior leaders and external stakeholders.
• Run daily, weekly and monthly workforce reporting processes, ensuring information is accurate, timely and reliable.
• Analyse workforce data, identify trends and highlight areas requiring further investigation or action.
• Support the coordination and completion of workforce-related Freedom of Information (FOI) requests.
• Monitor team mailboxes and respond to workforce information queries, escalating issues where appropriate.
• Manage access to workforce reporting systems and dashboards, providing user support and training.
• Assist in improving data quality by identifying anomalies, validating information and supporting corrective actions.
• Develop knowledge of workforce systems, reporting tools and new technologies to support automation and service improvement.
• Produce meaningful visualisations, reports and dashboards that support operational and strategic decision-making.
• Deliver training and guidance to managers and service users on workforce dashboards and reporting functionality.
• Contribute to the development of user guides, training materials and support resources.
• Work collaboratively with colleagues across the People Directorate and wider organisation to promote the effective use of workforce information.

Job description,

We are looking for a motivated, analytical and enthusiastic individual to join our Workforce Information & Planning team as a Workforce Information Trainee Analyst.

This is an exciting development opportunity for someone who has a keen interest in data, reporting and business intelligence and is looking to build a career in workforce analytics within the NHS.

Person Specification - Qualifications Essential

• Educated to Diploma level or equivalent experience.

Person Specification - Experience Essential

• Advanced IT skills Microsoft Word, Outlook, PowerPoint, and Excel to a high level including manipulation and present data in user friendly formats.
• Ability to communicate effectively, verbally and in writing, to differing audiences, using negotiation skills.
• Ability to plan and manage time effectively.
• Strong attention to detail.

Person Specification - Desirable

• Advanced Excel knowledge including Power Query.
• An understanding of the NHS and various education and training needs of its staff.
• Power BI or equivalent software skills.
• Experience of manipulating and analysing data to create effective visual charts using Microsoft Excel and Business Intelligence Software.
• Experience of information governance and data protection.
• Experience creating and analysing surveys and responses.
• Experience of training and developing others.
• Problem solving skills, able to trace a story back to the original problem.
• Previously worked within an NHS setting with knowledge of NHS processes and structures.
• Knowledge and experience of using ESR (Electronic Staff Record) and RLDatix Optima.
• Experience managing of junior staff and task delegation.

Benefits

• our on-site Nursery
• access to our free Beach Hut for those long summer days
• our on-site Wellness Centre including a gym and a swimming pool
• access to our fantastic staff networks including LGBTQ, Race Equality and DisAbility
• and awards ceremonies to recognise your achievements

Workforce Information & Planning team

The Workforce Information & Planning team plays a vital role in supporting leaders and services across Portsmouth Hospitals University NHS Trust and Isle of Wight NHS Trust by providing high-quality workforce information, analysis and insight. We are passionate about helping managers and clinicians make informed decisions that support our workforce and enable the best possible care for our patients.

Working as a partnership, both Isle of Wight NHS Trust and Portsmouth Hospitals University NHS Trust have a shared vision for excellence in care for our patients and communities; with a set of strategic aims underpinning how we will achieve this.

The single corporate service is delivered across both organisations. You may be based at either IWT or PHU and individuals may be required to undertake business travel between sites. For leaders managing staff across multi-site locations, you will need to be visible and provide in person leadership. The arrangements and frequency will be agreed locally. The health and wellbeing of our staff is at the forefront of everything we do. We are proud to be able to offer our staff some fantastic benefits including our on-site Nursery, access to our free Beach Hut for those long summer days, our on-site Wellness Centre including a gym and a swimming pool, access to our fantastic staff networks including LGBTQ, Race Equality and DisAbility, and awards ceremonies to recognise your achievements. We believe we can offer support to all of our staff when they need it the most.