Trainee Analyst

Role description

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.

This vacancy is open to employees of Isle of Wight NHS Trust and Portsmouth Hospitals University NHS Trust only.

NHS Band 4: £28,392 - £31,157 per annum

Hours Per Week: full time 37.5

Contract Type: Permanent

Location Base: Portsmouth Hospitals University NHS Trust Corporate Hub, Block 4000, Lakeside North Harbour, Western Road, Cosham, Portsmouth, PO6 3EN Or

St Mary's Hospital, Parkhurst Road, Newport, Isle of Wight, PO30 5TG

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.

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.

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.

This role offers excellent opportunities for learning and development, with exposure to a wide range of workforce datasets, reporting tools and analytical techniques. You will be supported by a knowledgeable and friendly team committed to helping you grow your skills and reach your full potential.

Key Responsibilities

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.

We are looking for someone with excellent communication skills, strong attention to detail and a passion for using data to support improvement. If you enjoy problem-solving, working with information and developing new analytical skills within a supportive NHS environment, we would love to hear from you.

For full details of the role and person specification, please refer to the attached job description.

Essential

Educated to Diploma level or equivalent experience.

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

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

Skills & Knowledge

Essential

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.

Desirable

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

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.

We welcome the unique contributions that you can bring in terms of your education, opinions, culture, ethnicity, race, sex, gender identity and expression, nation of origin, age, languages spoken, veteran’s status, colour, religion, disability, sexual orientation, and beliefs.

For more information, please see our People and OD Strategy 2026