At a Glance
- Tasks: Unlock the power of sales data and create actionable insights for Magnum's iconic brands.
- Company: Join the world's largest ice cream company, known for innovation and growth.
- Benefits: Competitive pay, flexible remote work, and a fun, dynamic environment.
- Other info: Collaborate with passionate teams and enjoy excellent career growth opportunities.
- Why this job: Make a real impact on sales strategies while enjoying the sweet world of ice cream.
- Qualifications: Experience with Power BI, SQL, and data analysis in a fast-paced setting.
The predicted salary is between 35000 - 45000 £ per year.
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. The role currently offers a mix of remote and onsite working, subject to adjustment based on business requirements.
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 consolidate multiple wholesaler sales data sources (including but not limited to EPOS, shipment/sell‑in, CRM, partner data)
- Work with Databricks to query, combine, and transform 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 oversee data ingestion processes for wholesaler and partner data
- Work closely with data engineers to bring in new data sources and improve data availability
- 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
- 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
- Make Data Usable for the Business
- Develop clean, structured datasets to support sales, CRM, and commercial reporting
- Contribute to a single source of truth for wholesaler and customer data
- Ensure consistency in definitions (e.g. sales metrics, customer views, SKUs)
- 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, and trust
- Identify opportunities to improve data coverage, accuracy, and reporting
- 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 desirable (data querying, transformation)
- Strong SQL skills desirable 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
- 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
Success in This Role Looks Like
- Seamless integration of wholesaler sales data across multiple partners
- Trusted, high‑quality datasets supporting commercial decisions
- Widely adopted Power BI dashboards across sales and account teams
- Strong collaboration between analytics, engineering, and commercial teams
- Clear visibility of wholesaler performance, risks, and growth opportunities
Data & Analytics Analyst in Kingston upon Thames employer: The Magnum Ice Cream Company
The Magnum Ice Cream Company is an exceptional employer, offering a dynamic work environment in Kingston upon Thames where innovation and personal growth are at the forefront. Employees benefit from a culture that encourages empowerment and creativity, alongside competitive compensation and flexible working arrangements. With a commitment to developing talent and fostering collaboration, this role as a Data & Analytics Analyst provides a unique opportunity to contribute to the success of iconic brands while enjoying a fulfilling career in the fast-paced FMCG sector.
Contact Details:
The Magnum Ice Cream Company Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Data & Analytics Analyst in Kingston upon Thames
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those connected to Magnum Ice Cream Company. Attend events, join relevant online groups, and don’t be shy about asking for informational interviews. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data visualisation projects, especially using Power BI. This will not only demonstrate your expertise but also give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for the interview by diving deep into Magnum’s products and their market. Understand their sales data needs and think about how you can contribute to their mission. Tailor your examples to show how your experience aligns with their goals.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re genuinely interested in being part of the Magnum team. Let’s get you that Data & Analytics Analyst role!
We think you need these skills to ace Data & Analytics Analyst in Kingston upon Thames
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data & Analytics Analyst role. Highlight your experience with Power BI, Databricks, and any relevant data projects. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Share your passion for data and how you can contribute to our mission at Magnum Ice Cream Company. Be sure to mention specific examples of how you've turned data into actionable insights.
Showcase Your Technical Skills:Don’t forget to highlight your technical skills in SQL, data pipelines, and data visualisation. We love seeing candidates who can demonstrate their ability to work with large datasets and deliver clear insights.
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and we’ll be able to review your application quickly. Plus, it shows you’re serious about joining our team!
How to prepare for a job interview at The Magnum Ice Cream Company
✨Know Your Data Tools
Make sure you brush up on your Power BI skills and understand how to create impactful dashboards. Familiarise yourself with Databricks as well, since you'll be working with it to query and transform data. Being able to discuss specific examples of how you've used these tools in the past will really impress your interviewers.
✨Understand the FMCG Landscape
Since you'll be working with a global FMCG client, it's crucial to have a good grasp of the industry. Research Magnum Ice Cream Company and its brands, like Ben & Jerry's and Cornetto. Be prepared to discuss how data analytics can drive sales performance in this fast-paced environment.
✨Prepare for Technical Questions
Expect questions about SQL, data ingestion processes, and how to handle large datasets. Brush up on your technical knowledge and be ready to explain your thought process when solving data-related problems. Practising common SQL queries and data transformation scenarios can give you an edge.
✨Show Your Collaborative Spirit
This role requires working closely with data engineers and commercial teams. Be ready to share examples of how you've successfully collaborated in the past. Highlight your communication skills and your ability to translate complex data into actionable insights that non-technical stakeholders can understand.
