Operational Planning Analyst

Operational Planning Analyst

London Full-Time 46600 - 51600 £ / year (est.) Home office (partial)
K

At a Glance

  • Tasks: Join our team as an Operational Planning Analyst, focusing on data analysis and forecasting.
  • Company: Be part of King's College Hospital, a leading NHS Trust with a commitment to outstanding care.
  • Benefits: Enjoy flexible working options and a supportive environment that values work/life balance.
  • Why this job: Make a real impact in healthcare by developing analytical tools for patient care and operational efficiency.
  • Qualifications: Strong Excel, SQL, and Power BI skills are essential; experience with R and Python is a plus.
  • Other info: This role is primarily based at Denmark Hill, with opportunities for remote work.

The predicted salary is between 46600 - 51600 £ per year.

This post is only open to internal applicants.

Main area: Analytics

Grade: NHS AfC: Band 7

Contract: Permanent

Hours: Full time - 37.5 hours per week

Salary: £54,320 - £60,981 per annum, including Inner London HCAS rate

Closing: 08/07/2025 23:59

King’s College Hospital NHS Foundation Trust is one of the UK’s largest and busiest teaching Trusts with a turnover of c£1.8 billion, 1.5 million patient contacts a year and more than 15,000 staff based across 5 main sites in South East London. The Trust provides a full range of local hospital services across its different sites, and specialist services from King’s College Hospital (KCH) sites at Denmark Hill in Camberwell and at the Princess Royal University Hospital (PRUH) site in the London Borough of Bromley.

The King’s Operational Planning Team sits within the Trust’s Business Intelligence Unit (BIU) and has responsibility for activity planning, performance forecasting and demand and capacity modelling. The team provides the forward-looking part of the Trust’s data function and works closely with clinical teams and other corporate functions within King’s, as well as local and national commissioners to deliver this.

We are currently looking for a talented analyst to join the team to support the ongoing delivery of our existing portfolio and develop new modelling and analytical tools to help King’s respond effectively to emerging challenges and the evolving NHS operational landscape.

Main duties of the job:

  • Developing the Trust’s annual activity plan
  • Leading on demand vs capacity modelling across the Trust
  • Leading on all forms of performance forecasting across the Trust

The post holder will be expected to contribute to all three of the above departmental responsibilities. The post-holder’s primary role will be to use their analytical and SQL skills to provide detailed analytical support to the Operational Planning Managers in the development and maintenance of:

  • The Trust’s annual activity planning model and the associated outputs.
  • The Trust’s demand vs capacity models.
  • The Trust's performance forecasting and benchmarking tools.

The ideal post-holder would have detailed knowledge of demand, capacity and performance modelling in the NHS. They will use this knowledge to support the development of sophisticated data models that demonstrate the short- and long-term Trust capacity and performance requirements.

Analytical & Judgemental Skills:

  • Expert analytical and SQL skills
  • Analyse, investigate and resolve complex issues and problems which arise during the development of the Trust’s annual activity plan.
  • Identify any unusual data trends in the model which may be used to highlight errors in analysis / reporting.
  • Ensure that there are insightful outputs from the analysis which can be presented to operational leads in a structured and meaningful way.

Planning & Organisational Skills:

  • Required to work on a range of different analytical / modelling areas, including: activity planning, performance forecasting and demand vs capacity modelling.
  • The post-holder will be adept at planning their time and resources and will need to formulate and adjust their plans to meet business need.

Mental Effort:

  • The role is very mentally challenging. The post-holder will be expected to concentrate for long periods when analysing data and developing models.
  • Developing accurate outputs is critical to this role and the post-holder will need to check and verify their analysis thoroughly.

Communication & Relationship Skills:

  • Work closely with operational colleagues to develop a detailed understanding of the expected activity impact of upcoming service changes.
  • Provide and receive highly complex information.
  • Present complex analytical outputs to colleagues within and beyond the operational planning team / business intelligence unit.

Person specification:

  • Masters/MBA or equivalent experience
  • Exceptionally high level of numeracy and numerical reasoning
  • A strategic thinker with highly developed communication skills
  • In depth specialist knowledge of data and using data to develop analysis used to support critical decisions in healthcare or another sector
  • Significant relevant experience within an informatics or performance / planning setting

IMPORTANT: Check your email account regularly as this is how we will communicate with you. If you delete the job from any of your accounts, you may be prevented from accessing further communications.

Operational Planning Analyst employer: Kings College Hospital

King's College Hospital NHS Foundation Trust is an exceptional employer, offering a dynamic work environment that prioritises employee well-being and professional growth. With a commitment to flexible working arrangements, a focus on sustainability, and a culture of collaboration, staff are empowered to make a meaningful impact in healthcare while enjoying a supportive atmosphere that values diversity and innovation.
K

Contact Detail:

Kings College Hospital Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Operational Planning Analyst

✨Tip Number 1

Familiarise yourself with the specific analytical tools mentioned in the job description, such as SQL, Power BI, R, and Python. Having hands-on experience or projects that showcase your skills with these tools can set you apart from other candidates.

✨Tip Number 2

Network with current employees in the Operational Planning Team or related departments at King's College Hospital. Engaging with them can provide insights into the team dynamics and expectations, which can be invaluable during interviews.

✨Tip Number 3

Stay updated on the latest trends and challenges in NHS operational planning and analytics. Being able to discuss current issues and how they relate to the role will demonstrate your commitment and understanding of the field.

✨Tip Number 4

Prepare to discuss specific examples of how you've used data to influence decision-making in previous roles. Highlighting your ability to translate complex data into actionable insights will resonate well with the hiring managers.

We think you need these skills to ace Operational Planning Analyst

Advanced Excel Skills
SQL Proficiency
Power BI Experience
Data Analysis
Statistical Modelling
Knowledge of NHS Demand and Capacity Modelling
Experience with R and Python
Analytical Thinking
Problem-Solving Skills
Attention to Detail
Communication Skills
Ability to Present Complex Information
Collaboration Skills
Time Management
Strategic Thinking

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your analytical skills, particularly in SQL and Excel, as well as any experience with Power BI, R, or Python. Emphasise your previous roles that align with the responsibilities of the Operational Planning Analyst position.

Craft a Strong Cover Letter: In your cover letter, explain why you are interested in this specific role at King’s College Hospital NHS Foundation Trust. Mention your understanding of the NHS operational landscape and how your skills can contribute to the team’s goals.

Highlight Relevant Experience: When detailing your work history, focus on experiences that demonstrate your ability to analyse complex data, identify trends, and support decision-making processes. Use specific examples to illustrate your achievements in similar roles.

Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for an analytical role.

How to prepare for a job interview at Kings College Hospital

✨Showcase Your Analytical Skills

As an Operational Planning Analyst, your analytical skills are crucial. Be prepared to discuss specific examples of how you've used Excel, SQL, or Power BI in previous roles. Highlight any complex data analysis you've conducted and the insights you derived from it.

✨Understand the NHS Landscape

Familiarise yourself with the current challenges and trends within the NHS, especially regarding operational planning and performance forecasting. Being able to discuss these topics will demonstrate your commitment and understanding of the role's context.

✨Prepare for Scenario-Based Questions

Expect questions that assess your problem-solving abilities. Prepare for scenario-based questions where you might need to explain how you would approach a specific demand vs capacity modelling challenge or how to handle unexpected data trends.

✨Communicate Clearly and Effectively

Strong communication skills are essential for this role. Practice explaining complex analytical concepts in simple terms, as you'll need to present your findings to colleagues who may not have a technical background. Clear communication can set you apart from other candidates.

Operational Planning Analyst
Kings College Hospital
K
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>