At a Glance
- Tasks: Unlock the power of sales data and create impactful 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 experts and enjoy excellent career growth opportunities.
- Why this job: Make a real impact in a fast-paced FMCG setting while enjoying ice cream culture.
- Qualifications: Experience with Power BI, SQL, and data analysis; passion for sales performance.
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 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
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those connected to Magnum or similar FMCG companies. Attend events, webinars, or even local meetups to make those valuable connections that could lead to job opportunities.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and any data projects you've worked on. This will give potential employers a taste of what you can do and how you can add value to their team.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and Databricks knowledge. Be ready to discuss how you've tackled data challenges in the past and how you can help Magnum unlock insights from their wholesaler data.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Data & Analytics Analyst
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! Use it to explain why you're passionate about data analytics and how you can contribute to our mission at Magnum. Keep it engaging and personal – we love a good story!
Showcase Your Data Skills:In your application, don’t forget to showcase your technical skills, especially in SQL and data visualisation. Mention specific projects where you've transformed data into actionable insights. We’re keen to see your analytical prowess!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you get all the updates directly from us. Plus, it’s super easy!
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 be ready to discuss how you've used it in past projects. Be prepared to share specific examples of dashboards you've created and how they impacted decision-making.
✨Understand the FMCG Landscape
Familiarise yourself with the FMCG sector, especially around wholesaler sales data. Research Magnum Ice Cream Company and its brands, and think about how your analytical skills can contribute to their mission of growth and innovation.
✨Prepare for Technical Questions
Expect questions about SQL, Databricks, and data pipelines. Brush up on your technical knowledge and be ready to explain how you would approach connecting and transforming large datasets to derive actionable insights.
✨Show Your Collaborative Spirit
This role involves working closely with data engineers and commercial teams. Be ready to discuss how you've successfully collaborated in the past, highlighting your communication skills and ability to translate complex data into clear insights for non-technical stakeholders.
