RGM Analyst
Job Location:
Monthly Salary:
Posted on:
Yesterday
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Data handling & structure
Clean structure and reconcile large datasets (SKU Channel Customer).
Build flat analysisready tables from messy source files (sellin sellout Nielsen price trackers).
Strong discipline on master data mapping(SKU codes pack sizes /L or price/kg normalisation).
Key Excel tools
Pivot Tables (advanced slicing calculated fields timelines).
Power Query (data import cleaning appending transformation).
Named ranges and structured tables.
Conditional formatting for governance thresholds (e.g. SPI vs API red/green logic).
Musthave formulas
SUMIFS COUNTIFS AVERAGEIFS
INDEX / MATCH or XLOOKUP / VLOOKUP
SUMPRODUCT (crucial for weighted price indices & profit pools)
Nested IF IFS
Array formulas (dynamic arrays where possible)
2. Capability to create scalable Excel based Tools & Templates.
3. PPT Skills
Clean structure and reconcile large datasets (SKU Channel Customer).
Build flat analysisready tables from messy source files (sellin sellout Nielsen price trackers).
Strong discipline on master data mapping(SKU codes pack sizes /L or price/kg normalisation).
Key Excel tools
Pivot Tables (advanced slicing calculated fields timelines).
Power Query (data import cleaning appending transformation).
Named ranges and structured tables.
Conditional formatting for governance thresholds (e.g. SPI vs API red/green logic).
Musthave formulas
SUMIFS COUNTIFS AVERAGEIFS
INDEX / MATCH or XLOOKUP / VLOOKUP
SUMPRODUCT (crucial for weighted price indices & profit pools)
Nested IF IFS
Array formulas (dynamic arrays where possible)
2. Capability to create scalable Excel based Tools & Templates.
3. PPT Skills
