Strategy and Planning PMO Modelling Analyst

Strategy and Planning PMO Modelling Analyst

Posted 4 days ago by eTeam Workforce Limited

£438 Per day
Inside
Hybrid
Sheffield (Hybrid), UK

Summary: The Strategy and Planning PMO Modelling Analyst role is designed for a highly analytical professional with expertise in data modeling and analysis, aimed at supporting enterprise infrastructure planning programs. The position requires collaboration with senior stakeholders to develop data-driven strategies and present insights that influence executive-level decisions. This role is ideal for candidates with a background in consulting, banking, or corporate strategy, seeking to enhance their career through direct exposure to C-suite initiatives. The position is hybrid, requiring three days on-site in Sheffield, UK.

Key Responsibilities:

  • 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.

Key Skills:

  • 3-5 years of experience 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.
  • 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.
  • Strong interpersonal and communication skills.
  • Motivated by career growth and exposure to executive-level strategy.

Salary (Rate): £438 per day

City: Sheffield

Country: UK

Working Arrangements: hybrid

IR35 Status: inside IR35

Seniority Level: Mid-Level

Industry: IT

Detailed Description From Employer:

We are a Global Recruitment specialist that provides support to the clients across EMEA, APAC, US and Canada. We have an excellent job opportunity for you.

Role Title: Strategy and Planning PMO Modelling Analyst
Location: Sheffield S1 4NB Hybrid 60%office-40% remote (3 days onsite is mandatory)
Duration: 3-6 months contract initially
Pay Rate: £438 per day through FCSA Umbrella

Role Description:

  • We are seeking a highly analytical and technically skilled Data Modeler with strong data analysis capabilities and prior experience supporting enterprise infrastructure planning programmes. This role is ideal for professionals with a background in consulting, banking, or corporate strategy who are looking to accelerate their career through direct exposure to C-suite decision-making and high-impact strategic initiatives.
  • As a Data Modeler, you will play a pivotal role in shaping data-driven strategies by building robust models, dashboards, and analytical frameworks that inform executive-level decisions. You'll collaborate closely with senior stakeholders across finance, risk, and technology, translating complex data into actionable insights.

Key Responsibilities:

  • 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.

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 of experience 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 position and would like to learn more, please send through your CV and we will get in touch with you as soon as possible. Please note, candidates are often Shortlisted within 48 hours.