Financial Planning and Analysis Analyst

The Inn Collection Group; Newcastle upon Tyne; On-site; GBP 30,000 - 45,000; Full time

Job summary

A leading hospitality company in Newcastle upon Tyne is seeking an ambitious FP&A Analyst to support financial processes and analysis. The ideal candidate will own key financial categories, aggregate KPI data, and conduct variance analysis, utilizing strong Excel and analytical skills. This role requires a proactive approach to problem-solving and effective communication within the finance team. Competitive perks include paid holidays, food discounts, and 24/7 support for team members.

Benefits

Extra paid holiday for birthdays

50% off food at Inns

Discounted stays during off-peak

Free on-site parking

Qualifications

• Highly proficient in Excel, with strong analytical skills.
• Previous experience in budgeting, forecasting, and modeling.
• Able to adapt quickly to changing business needs.

Responsibilities

• Own the actual and forecasting of key financial categories.
• Prepare high-quality financial presentations.
• Conduct analysis and investigate variances.

Skills

Excel proficiency

Budget and forecast modeling

Problem-solving

Interpersonal skills

Analytical skills

Presentation skills

SQL experience

Sage200 experience

Job description

What makes the perfect pub? It’s great ales, delicious food, a welcoming atmosphere, and the warm welcome from a team that’s at the heart of everything we do.

The Inn Collection Group is a multi‑award‑winning pubs with rooms company, proudly located in some of the most outstanding destinations across the North of England and Wales. At ICG, we deliver exceptional hospitality by living and breathing our core values of respect, customer focus, warmth, and honesty, all with the goal of Making People Happy.

How we say thank you!

• Celebrate your birthday with an extra paid holiday.
• Enjoy 50% off food at any of our Inns.
• Relax with a stay at any of our Inns during January, February, and March for just £1.
• Take advantage of the chance to explore our beautiful locations, with 1/3 off room bookings all year round.
• Experience a spontaneous trip away with £50 on same‑day bookings.
• It’s not just for you—your loved ones can enjoy 15% off bed and breakfast too.
• 24/7 confidential support is always there when you need it with our Employee Assistance Programme.
• Contribute to a company that gives back through our Give‑inn‑back scheme.
• Join an award‑winning team recognised as the Best Pub Employer at the Publican Awards.
• Enjoy the convenience of free on‑site parking.

Rooted in the North, our support hub at Quorum Business Park in Newcastle serves as a central space where all our departments come together to collaborate and innovate. Located in a thriving business community, it reflects our strong connection to the region while providing a modern, dynamic environment to drive our collective success.

You’ll Fit Right Inn

We have an exciting opportunity for an ambitious FP&A Analyst to join our team. You will be instrumental in our financial processes, planning and analysis supporting the business. This role is based at our Head Office in Quorum Business Park, Newcastle Upon Tyne.

Candidates should understand the importance of providing timely and accurate financial information as a basis for insightful analysis and operational data, have an understanding of financial accounting and strong analytical skills, and play a key role in our month‑end process, forecasting and annual budget cycle.

Responsibilities & Duties

• Own actual and forecasting of key financial categories.
• Weekly and monthly KPI data aggregation and calculation.
• Problem solving and investigation where variances arise.
• Support colleagues at site and support hub with queries.
• Develop reports for the organisation to drive value through data‑backed decision making.
• Plan versus actual variance analysis.
• Preparing high‑quality financial presentations, providing analysis and recommendations.
• Key forecast driver variance analysis and reporting.
• Monthly management accounts preparation and balance sheet reconciliations, including forecast data input.
• Data preparation, consolidation and analysis support.

Required Skills

• Highly proficient Excel user.
• Previous experience collating budget and forecast inputs and modelling.
• Self‑starter with effective time management and prioritisation.
• Problem solver.
• Excellent interpersonal and communication skills and the ability to relate to a wide range of people of all levels.
• Strong analytical and presentation skills.
• Previous experience with SQL.
• Ability to adapt to changing business needs, working quickly and accurately.
• Balance sheet reconciliation experience.
• Previous experience with Sage200 desirable.