RGM Analyst

Data handling & structure<br /> Clean, structure, and reconcile large datasets (SKU Channel Customer).<br /> Build flat, analysis?ready tables from messy source files (sell?in, sell?out, Nielsen, price trackers).<br /> Strong discipline on master data mapping(SKU codes, pack sizes, /L or price/kg normalisation).<br /> Key Excel tools<br /> Pivot Tables (advanced slicing, calculated fields, timelines).<br /> Power Query (data import, cleaning, appending, transformation).<br /> Named ranges and structured tables.<br /> Conditional formatting for governance thresholds (e.g. SPI vs API red/green logic).<br /> Must?have formulas<br /> SUMIFS, COUNTIFS, AVERAGEIFS<br /> INDEX / MATCH or XLOOKUP / VLOOKUP<br /> SUMPRODUCT (crucial for weighted price indices & profit pools)<br /> Nested IF, IFS<br /> Array formulas (dynamic arrays where possible)<br /> 2. Capability to create, scalable Ex...