Data Analyst (FMCG Distribution — Sales, Inventory & Pricing Analytics)

We are an emerging Fast-Moving Consumer Goods (FMCG) distribution business scaling our footprint in the market. We are seeking a hands-on Data Analyst to turn raw market, distributor, and retail data into actionable strategies for growth, margin optimization, and inventory movement. What You Will Do Data Preparation: Clean, transform, and structure raw sales, logistics, and retail data from spreadsheets, CSVs, and internal databases. Inventory & Velocity Analysis: Identify fast-moving (SKU turnover) vs. slow-moving stock, track sell-through rates, and recommend optimal reorder points to prevent stockouts. Pricing & Margin Strategy: Analyze competitor pricing, trade discounts, and landed costs to recommend optimal retail price points and channel margins across product categories. Retailer & Channel Insights: Map sales performance by retailer, wholesaler, and geographic route—identifying key accounts and tracking payment reliability. Reporting & Dashboards: Build interactive BI dashboards and deliver a concise weekly insight digest for business leaders. Must-Have Skills Advanced Excel: Mastery of Power Query, PivotTables, complex formulas, and data modeling. BI Tools: Proficiency in Power BI, Tableau, or Looker Studio. SQL: Ability to extract, clean, and join multi-table datasets. (Python or R is a strong plus) Relevant Experience: Proven track record in FMCG, retail, sales, inventory, or pricing analytics. Communication: Ability to translate complex data into clear business narrative and presentation slides. Nice to Have Background in FMCG, food & beverage, personal care, or broad route-to-market distribution. Experience with demand forecasting and trade promotion analytics. PL-300 (Microsoft Certified: Power BI Data Analyst) certification. Application Requirements To apply, please submit: Case Example: A brief note detailing a similar FMCG or retail analysis you executed and the commercial outcome it achieved. Portfolio Sample: One dashboard, report, or visual analytics sample you built. Skills Test: Your response to the attached short paid technical test.