Retail Data Analyst

SUMMARY:
Our client, a manufacturer of protective paints and coatings, is searching for a reliable Retail Data Analyst, reporting to the National Sales Manager, to support their Sales teams with retail data insights to optimise assortment, placement, pricing, and promotions across key retail accounts.

POSITION INFO:
Preferable Skills:

• Analytical Mindset: Strong attention to detail, shopper-centric thinking.
• Communication: Excellent presentation and stakeholder engagement.
• Collaboration: Cross-functional teamwork across sales, supply, marketing.

• Bachelor’s Degree in Marketing, Business, Economics, Statistics, Data Analytics or related field.
• Minimum 2 to 5 years of experience in retail analytics, FMCG/CPG category management, pricing analytics, or a similar role.
• Experience with retailer channels (DIY, home improvement, e‑comm) and syndicated data preferred.
• Familiarity with pricing analysis or promotional effectiveness recommended.
• Advanced Excel: PivotTables, VLOOKUP/INDEX-MATCH, Power Query/Pivot/Query.
• Data Visualization: Power BI / Tableau.
• Retail Tools: SAP (or equivalent) data extraction.

• Analyse POS, internal sales to identify performance trends, growth segments, and opportunities.
• Benchmark the company against competitors in coatings and small-project paint markets.

• Lead range reviews and assortment gap analyses with major retailers.
• Generate planograms, maintaining product libraries and assets.
• Present shelf strategies and execution plans to retailers using data-driven approaches.

• Implement Pricing Analytics to integrate pricing and promo data in category strategies.

• Perform basket-level and promotional lift analysis to assess campaign success.
• Translate shopper behaviour data into actionable insights.

• Partner with Sales, Marketing, Supply Chain, and e‑Comm teams to align strategies and execution.
• Provide category insights in retailer business reviews and Joint Business Plans.

• Build and maintain dashboards (Power BI, Tableau, Excel PivotTables, Power Query) to track key metrics like sales, market share, assortment width, and promo performance.
• Deliver monthly and adhoc analytical reporting.