The role
delivers data-driven insight into supplier contract performance, pricing integrity, promotional effectiveness, product ranging, and budget management. The analyst helps optimise profitability, strengthen supplier partnerships, and enhance the value delivered to customers.
Key Duties
1. Conduct data-led analysis to support optimal product ranging across C&C channels
2. Assist buyers on range reviews to assess SKU performance: rate of sale, distribution, velocity, contribution per case/litre, and customer relevance.
3. Identify opportunities for SKU rationalisation, tail reduction, NPD growth, and pack/format optimisation for both category and supplier portfolio’s.
4. Support Category and Buying teams with evidence-based recommendations for channel-specific assortments.
5. Build product range insight dashboards (e.g., tail performance, top-seller shifts, NPD tracking).
6. Enable better customer range reviews and supplier negotiations through clear, insight-led portfolio recommendations.
7. Support buying and promotions team to monitor budget performance and reforecast cycles for supplier income, and promotional spend.
8. Perform variance analysis and explain drivers behind budget vs. actual performance.
9. Partner with Finance on supplier income accruals and commercial governance.
10. Deliver reporting to key commercial forums, highlighting risks, opportunities, and trend insights.
11. Supplier Contract Terms & Performance (C&C Growth, Trade Terms, JBPs)
12. Analyse supplier agreements including JBPs, rebates, growth incentives, marketing contributions, and volume commitments across GB & Ireland.
13. Work with finance team to track performance vs. contracted terms and identify leakage, missed income, and compliance issues.
14. Provide reporting and negotiation insight to Buyers, Category, for supplier business reviews.
15. Analyse commercial commitments such as DGS and DKI agreements.
16. Monitor supplier cost changes YoY, duty implications, and competitive market pricing across routes to market.
17. Work with pricing and finance team to analyse margin performance at SKU, brand, supplier, and channel level using C&C pricing tools and Power BI.
18. Identify drivers of margin erosion (mix, cost, promo depth, freight, duty) and recommend corrective action.
19. Evaluate promotional mechanics: Price deals, basket offers, loyalty deals etc, working with the Implementation team to analyse supplier-funded agreements, brand activation support, and digital support. Assess ROI and profitability for supplier-funded and internally funded promotions, recommending improvements.
20. Produce promo scorecards detailing uplift, incremental volume, contribution, cannibalisation, and retention impact.
About you
21. Commercial analytics experience within FMCG, drinks, retail, or wholesale.
22. Strong understanding of supplier terms, trade promotions, and commercial finance.
23. Advanced Excel and Power BI (DAX, modelling); comfortable handling large datasets.
24. Ability to convert data into actionable commercial insights.
25. Effective stakeholder management across commercial and finance teams.
26. Experience with C&C systems
27. SQL or Python analytics capability.
28. UK On-Trade, Off-Trade, or wholesaling experience.
29. Category management or revenue management exposure.