Strategy & Planning PMO Modelling Analyst

Job Title:Strategy & Planning PMO Modelling Analyst
Location: Sheffield (3x days on-site per week)
Salary/Rate: £438 Per Day inside IR35
Start Date: 15/01/2026
Job Type: Initial 6 month contract

Company Introduction

We have an exciting opportunity now available with one of our sector-leading consultancy clients! They are currently looking for a skilled Strategy & Planning PMO Modelling Analyst to join our clients team in Sheffield on a hybrid basis.

Job Responsibilities/Objectives

• You will be responsible for developing and maintaining sophisticated data models and analytical frameworks that drive HSBC's enterprise infrastructure planning and strategic decision-making-translating complex datasets into actionable insights, automating key processes, and delivering high-quality dashboards and reports that support executive-level strategy and performance tracking.
• Develop and maintain advanced data models to support strategic planning, risk analysis, and financial forecasting.
• Perform complex data analysis and scenario modelling to inform planning decisions.
• Design and implement dashboards and reporting tools using Power BI, Power Query, and Excel VBA.
• Automate processes and prepare structured data for seamless Power BI integration.
• Collaborate with cross-functional teams to gather requirements and deliver tailored analytical solutions.
• Present findings and recommendations to senior leadership, including C-suite executives.
• Support strategic projects with data-driven insights, scenario modelling, and performance tracking.
• Ensure data integrity and consistency across systems and reporting platforms.
• Contribute to the development of data governance and best practices.

Required Skills/Experience
The ideal candidate will have the following:

Candidate Profile:

• We're looking for candidates who combine analytical rigour with strong stakeholder management and a passion for strategic impact.

Ideal Background:

• 3-5 years in consulting, banking, corporate strategy, or a similar analytical role.
• Proven ability to work with senior stakeholders and communicate complex ideas clearly.
• Experience in finance or risk analytics is a plus.
• Understanding of IT infrastructure - network, storage, data centre, cloud.

Technical Skills:

• Strong Excel skills required, including advanced formulas, pivot tables, Power Query, data modelling using Power Pivot, and scenario analysis tools.
• Experience in building dashboards, process automation, and preparing structured data for Power BI integration is essential.
• Power BI and Power Query.
• SQL for data extraction and manipulation.
• Python (preferred but not required).
• SharePoint.

Personal Attributes:

• Strategic thinker with a hands-on approach to problem-solving.
• Strong interpersonal and communication skills.
• Motivated by career growth and exposure to executive-level strategy.

If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.

Disclaimer
Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.