Portsmouth Hospitals University NHS Trust
Trainee Analyst

How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Company 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.
Job Description
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
Job Overview
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.
Key Responsibilities
Reasons to use Rodeo
I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?
Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.
Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
Graduate Consultant — 2026 Scheme
Why you're a good match
StrongYour economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.
See breakdownIt searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Why you're a good match
You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.
Experience fit
Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
- 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.
Qualifications
Essential
- Educated to Diploma level or equivalent experience.
- 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


Get help with your application
Your very own career expert that helps elevate your application to the next level.
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
Additional Information
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
Weekly Hours / Programmed Activities: 37.5
Salary Band: Band 4
Staff Group: Administrative and Clerical
Contract Type: Permanent
Job Area: Admin and Corporate
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills