Data & Analytics Analyst

About The Magnum Ice Cream Company

The Magnum Ice Cream Company is a global leader in the ice cream industry, championing iconic brands such as Magnum, Ben & Jerry's, Cornetto, and Wall's. With a workforce of 19,000 experts and presence in 76 countries, the organization is dedicated to growth, innovation, and fostering entrepreneurial spirit among its people. The company emphasizes creating extraordinary ice cream experiences and aims to cultivate performance and ownership mindset.

Role Overview

We are seeking a Data & Analytics Analyst to join our UK team focused on wholesaler sales. The position is full-time and temporary for a duration of six months, requiring 36.25 hours per week, Monday through Friday. The role offers a hybrid working model with a combination of onsite presence in Kingston Upon Thames and remote working, adaptable depending on organizational needs. Remuneration is competitive at up to £52,500 per annum pro rata based on experience.

Responsibilities

• Integrate and visualize various wholesaler sales data sources including EPOS, shipment/sell-in, CRM, and partner data.
• Utilize Databricks to query, analyze, and interpret extensive sales datasets.
• Collaborate with data engineers to onboard new wholesale partners and manage data pipelines for reliable and current wholesaler data.
• Ensure consistent mapping of SKU, customer, and channel data for accuracy.
• Assist with data ingestion processes to secure necessary information for reporting and perform validation to maintain data integrity.
• Develop and maintain Power BI dashboards to showcase wholesale and sales performance, presenting key commercial metrics such as sales trends, distribution, range adherence, and customer performance.
• Translate complex sales data into clear, actionable insights for sales, account management, and operations teams.
• Identify opportunities to leverage new technological solutions for optimal data presentation.
• Support scalable data solutions to accommodate increased wholesaler partnerships and data complexity.
• Maintain rigorous standards for data quality, governance, and documentation including definitions and dictionaries.
• Collaborate with commercial teams to discover trends, risks, and growth opportunities, offering proactive insights and translating business needs into analytical frameworks.

Required Skills

• Expertise in Power BI, including data modeling, DAX scripting, and dashboard development.
• Experience working with Databricks or equivalent platforms for handling and transforming large datasets.
• Advanced SQL proficiency with the capability to manage complex, large-scale sales datasets.
• Knowledge of data pipelines and data ingestion methodologies.
• Demonstrated ability to integrate multiple data sources efficiently.
• Preferably experienced with sales, wholesaler, or FMCG sector data analytics.
• Understanding of commercial metrics and KPI reporting frameworks.
• Excellent collaboration skills with data engineers and non-technical stakeholders.

Key Attributes

• Strong commercial acumen with curiosity about sales performance drivers.
• Attention to detail and commitment to data accuracy and consistency.
• Proactive problem-solver with ability to manage multiple priorities under tight deadlines.
• Effective communicator skilled at translating complex data into actionable business insights.
• Beneficial experience includes participating in large-scale transformation programs and change initiatives.
• Outstanding stakeholder engagement capabilities and analytical skills.

Additional Information

This is a temporary full-time role based in Kingston Upon Thames, Surrey requiring a weekly commitment of 36.25 hours from Monday to Friday over a 6-month term. Compensation is competitive, up to £52,500 annually pro rata depending on experience. The working arrangement includes a blend of onsite and remote work with adjustments as necessitated by business demands.