Capgemini
N/A, UK
Salary : 15,500 - 19000
Role Title: Strategy and Planning Data Modelling Analyst
Location: Hybrid 60% office-40% home -Sheffield HSBC, Grosvenor House, 1 Wellington St, Sheffield City Centre, Sheffield S1 4NB
Duration: 30/11/2026
Rate to SSC (including supplier charge): £413.38
MUST BE PAYE THROUGH UMBRELLA
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.?
Location: Hybrid 60% office-40% home -Sheffield HSBC, Grosvenor House, 1 Wellington St, Sheffield City Centre, Sheffield S1 4NB
Duration: 30/11/2026
Rate to SSC (including supplier charge): £413.38
MUST BE PAYE THROUGH UMBRELLA
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.?