Data & Analytics Analyst

Manpower are currently seeking an interim Data & Analytics Analyst to work with our global FMCG client The Magnum Ice Cream Company, renowned for brands such as Magnum, Ben & Jerry's, Cornetto and Wall's, and become an integral part of their fast-paced FMCG environment. The position is based in Kingston upon Thames, Surrey.

This is a full-time temporary role to run for 6 months, requiring 36.25 hours per week, Monday to Friday. Compensation for this role is competitive paying up to £52,500 per annum, pro rata, depending on experience.

The role currently offers a mix of remote and onsite working, subject to adjustment based on business requirements.

Data & Analytics Analyst – Wholesaler SalesThe Magnum Ice Cream Company is on a mission to create the ultimate snacking company. A place where growth, innovation, founder and ownership mentality, and performance are cultivated and rewarded. And where we craft extraordinary ice cream experiences - transforming ordinary moments into lasting memories.

Because we know, life tastes better with ice cream.ABOUT THE MAGNUM ICE CREAM COMPANYThe Magnum Ice Cream Company is all about growth. Growing our business. Growing our customers’ businesses. Growing our people’s careers. Growth begins with empowerment.

So, we free our people to be innovative, responsible entrepreneurs, driven and equipped to give our consumers more amazing products and unforgettable moments – and having fun doing it.

With 19,000 expert ice cream colleagues and iconic brands like Wall’s, Cornetto and Ben & Jerry’s, loved in 76 countries, we are the world’s largest Ice Cream company leading the industry.

Position Overview

We’re looking for a Data & Analytics Analyst to unlock the value of wholesaler and customer sales data across Magnum’s UK business.

You will play a critical role in connecting multiple wholesaler data sources, working with Databricks and pipelines and transforming raw sales data into clear, actionable insights. This includes enabling visibility on sell-in, sell-out, distribution, range, and performance across wholesale partners.

You will work closely with data engineers to ensure data is ingested, structured, and ready for analysis, while acting as a Power BI super user to deliver dashboards that drive commercial decisions across sales, account management, and operations.

Key Responsibilities

• Connect & Integrate Wholesaler Data
• Connect and visualise multiple wholesaler sales data sources (including but not limited to EPOS, shipment/sell-in, CRM, partner data)
• Work with Databricks to query, review and report on large-scale sales datasets
• Connect to and leverage data pipelines to access reliable, up-to-date wholesaler data
• Partner with data engineers to onboard new wholesale partners and data feeds
• Ensure consistent, accurate mapping of SKU, customer and channel data
• Data Ingestion & Pipeline Collaboration
• Support and advise on data ingestion processes for wholesaler and partner data to ensure you have the information required for reporting usage
• Validate and sense-check incoming data to ensure accuracy and completeness
• Help ensure data pipelines deliver timely, structured, analysis-ready datasets
• Data Visualisation & Commercial Insights
• Act as a Power BI super user, building dashboards focused on wholesale performance and sales performance
• Deliver reporting on key commercial metrics (e.g. sales trends, distribution, range compliance, customer performance)
• Create intuitive data visualisations for sales and account teams
• Translate complex sales data into clear insights and actions
• Maintain and improve existing dashboards to meet business needs
• Identify opportunities to utilise new technology to present data in the best way
• Strong commercial experience designing and implementing Power BI solutions.
• Proven expertise in data modelling, data transformation and report development.
• Experience creating dashboards, data visualisations and management information reporting.
• Strong understanding of KPI and OKR reporting frameworks
• Enable self-serve analytics for commercial teams
• Set Us Up for Success
• Support scalable solutions that accommodate new wholesalers and growing data complexity
• Contribute to data documentation, definitions and data dictionaries
• Ensure high standards of data quality & governance
• Identify opportunities to improve data coverage & accuracy
• Business Partnering & Opportunity Identification
• Work closely with sales, account managers and CRM teams to answer key business questions
• Identify trends and opportunities within wholesaler performance and distribution
• Proactively highlight risks and opportunities (e.g. gaps in distribution, declining accounts, growth pockets)
• Translate business needs into analytical solutions

Required Skills

• Advanced Power BI expertise (data modelling, DAX, dashboard delivery)
• Experience working with Databricks (or similar) (data querying, transformation of large data sets)
• Strong SQL skills and ability to work with large, complex sales datasets
• Experience with data pipelines and ingestion processes
• Proven ability to connect and combine multiple data sources
• Experience working with sales, wholesaler, or FMCG data is highly desirable
• Strong understanding of commercial metrics and reporting
• Experience collaborating with data engineers and non-technical stakeholders
• Key Attributes
• Commercially minded with strong curiosity for sales performance drivers
• Detail-oriented with a strong focus on data accuracy and consistency
• Proactive and solutions-driven
• Ability to manage conflicting priorities and short deadlines
• Strong communicator, able to translate data into actionable business insight
• Experience within large-scale transformation programmes, change initiatives or application modernisation projects would be advantageous.
• Excellent stakeholder engagement and communication skills.
• Strong analytical and problem-solving capabilities.