Retail Data Analyst - FMCG

Duties & Responsibilities:

Analyze consumer behaviour across online and offline channels, identifying purchasing patterns, shopping preferences, customer segments and factors influencing buying decisions.

Analyze the complete customer journey, including product discovery, browsing, store visits, purchases, fulfillment, returns and repeat purchases, identifying conversion barriers and opportunities for improvement.

• Develop customer segmentation models using behavioral, transactional and lifecycle data, applying RFM, cohort, retention, churn and market basket analysis.
• Evaluate sales performance across stores, regions, channels, product categories and SKUs, identifying trends, performance gaps and commercial opportunities.
• Analyze category performance, product assortment, customer demand, product affinity and cannibalization to support merchandising and range optimization decisions.
• Evaluate pricing strategies, promotional campaigns, discount effectiveness and price elasticity, measuring incremental sales, profitability and customer response.

Analyze inventory and supply chain performance, including demand forecasting, replenishment, stock availability, inventory turnover, stock aging, stock-outs and fulfillment efficiency.

Assess gross and contribution margins across customer segments, products, categories, stores and channels, identifying opportunities to improve commercial profitability.

• Develop and maintain performance dashboards, KPI frameworks and management reports using Power BI or Tableau, ensuring visibility of key retail and commercial metrics.
• Extract, consolidate, validate and reconcile data from POS, ERP, CRM, loyalty programs, e-commerce platforms and other business systems.
• Use SQL, Excel and relevant analytical tools to investigate business performance, identify root causes, develop hypotheses and provide data-driven recommendations.

Work closely with merchandising, marketing, retail operations, e-commerce, finance and supply chain teams to translate analytical findings into measurable business improvements.

Identify operational bottlenecks across physical store operations, supply chain and e-commerce workflows, recommending process improvements and tracking their impact.

Support ERP-related initiatives involving SAP, Oracle, Microsoft Dynamics or similar platforms, including data extraction, workflow optimization, process efficiency assessments and system transition initiatives.

Ensure data accuracy, consistency and reliability, clearly documenting analytical assumptions, data limitations and reporting methodologies.

Present findings and recommendations to management and key stakeholders, translating complex analytical information into clear business insights and actionable strategies.

Required Qualifications and Skills:

Bachelor's Degree in Business Analytics, Statistics, Economics, Mathematics, Business Administration, Supply Chain Management or a related discipline.

Preferred Qualification: Master's Degree in Business Analytics, Data Science, Business Intelligence or a related field. Relevant certifications in Power BI, Tableau, SQL, Python or data analytics are an advantage.

Minimum of 5–10 years of experience in Retail Industry with Data Analytics, Business Intelligence or Retail Analytics, preferably within organized retail, large retail chains, FMCG, e-commerce or multi-channel retail environments.

Strong practical experience in analyzing retail consumer behaviour, customer journeys, sales performance, merchandising, pricing, promotions, inventory planning and supply chain operations.

• Hands-on experience in customer segmentation, cohort analysis, retention analysis, churn analysis, RFM modelling, market basket analysis and demand forecasting.
• Strong proficiency in SQL, Advanced Microsoft Excel and Power BI or Tableau. Python or R programming experience is an advantage.
• Experience working with POS, ERP, CRM, loyalty management, e-commerce and digital analytics platforms.

Direct experience with ERP systems such as SAP, Oracle or Microsoft Dynamics, particularly in data extraction, workflow optimization, process improvement or operational reporting.

Practical understanding of retail KPIs, including conversion rates, average transaction value, basket size, customer lifetime value, repeat purchase rates, sell-through, inventory turnover, gross margin and promotional ROI.

• Experience working with both physical retail operations and digital commerce channels, with the ability to connect customer and commercial data across channels.
• Proven track record of identifying operational inefficiencies, investigating business problems and implementing data-driven process improvements.
• Language Skills:
• Fluent verbal and written English communication skills.
• Ability to prepare professional analytical reports, management presentations and business recommendations in English.
• Additional languages are an advantage.