Data Modelling Analyst (Strategy and Planning / PMO)
Whitehall Resources require a Data Modelling Analyst to work with a key client on a 6 month initial contract.
*This role requires on site work in Sheffield 3 days per week.
*Inside IR35.
Data Modelling Analyst (Strategy and Planning / PMO)
Role Description:
About the Role:
We are seeking a highly analytical and technically skilled Data Modeler with strong data analysis capabilities and prior experience supporting enterprise 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.
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).
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.