Data & Analytics Analyst

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.