Data Analyst

Job description

**Job Requirements** **Category &** **Inventory Analytics** • Analyse product and category performance looking at sales trends, sell-through rates, ageing stock, and inventory value. • Identify slow-moving products and recommend practical actions such as range rationalisation, stock reallocation, or clearance. • Track the impact of festivals, seasons, and promotions on sales and margins. • Support demand planning and forecasting to ensure the right products are available at the right time. • Help translate sales targets into store-level plans based on category potential. • Analyse pricing effectiveness and model discount and offer strategies balancing customer appeal with margin protection. • Benchmark pricing and promotional practices against competitors to stay market relevant. • Review commercial arrangements with franchise partners and identify cost optimisation opportunities. • Track margin flow across the value chain from sourcing to store and flag areas for improvement. **Customer Insights** • Use data to understand who our customers are, what they buy, what they buy together, and what encourages them to purchase. • Segment customers based on their preferences, spending patterns, and response to offers. • Combine customer, product, geography, and time data to generate insights that feed directly into business decisions on retention, assortment, and promotions. **Dashboards, Reporting & Digital Initiatives** • Build and maintain dashboards that give teams a clear, up-to-date view of category performance, inventory health, and key business metrics. • Support the business in moving to newer, more efficient reporting systems tracking adoption and measuring impact. • Take on ad-hoc analysis projects as and when the business needs fresh perspectives on emerging trends or risks. **Work Experience** **Education** - Master's degree in Business, Analytics, Statistics, Finance, or a related field. **Experience** - 3-5 years of hands-on experience in category or retail analytics. - Prior experience in jewellery, fashion, or luxury retail is an advantage. **What You Bring** - Strong, working proficiency in SQL for data extraction and analysis. - Advanced Excel skills pivot tables, complex formulas, macros, and Power Query. - Experience with reporting tools such as Power BI or Tableau is preferred. - Familiarity with ERP or point-of-sale systems is a plus. - Able to simplify complex data into clear, actionable business insights. - Organised, thorough, and comfortable managing multiple priorities at once. - Confident presenting findings to both analytical and non-technical audiences.