Category Analyst-Merchandising (Jewellery)

Job Requirements

• Perform deep-dive category analysis by mining and in sighting large datasets from ERP and POS systems using SQL and advanced Excel.
• Analyze category performance metrics such as sales velocity, sell-through rates, gross margin return on investment (GMROI), stock aging, and inventory turnover, segmented by jewellery product types and attributes (carat, clarity, design, metal purity).
• Conduct pricing elasticity and markdown analysis to identify optimal pricing strategies that maximize profitability while maintaining competitive positioning.
• Use basket analysis and customer segmentation techniques to understand buying behaviors and cross-category purchase patterns specific to jewellery shoppers.
• Track and analyze the impact of seasonal trends, festival buying cycles, and promotional campaigns on category revenue and margin.
• Identify slow-moving and dead stock items, recommending assortment rationalization and clearance strategies.
• Support new product launch analysis by benchmarking expected performance against historical data and market trends.
• Develop, automate, and maintain dynamic dashboards and reports that visualize key category KPIs for stakeholders.
• Collaborate with merchandising, buying, marketing, and supply chain teams to translate analytical insights into actionable business strategies.
• Continuously monitor competitor pricing, assortment, and promotional activities, providing competitive intelligence relevant to jewellery retail.
• Lead ad-hoc analytics projects to uncover emerging trends, risks, and opportunities within the jewellery category.
• Implement and improve forecasting models and demand planning inputs to better align inventory levels with anticipated sales.

Work Experience

• Master s degree in Business, Analytics, Statistics, Finance, or related field.
• 3 5 years of hands-on experience in category analytics or retail analytics; experience in jewellery or luxury retail preferred.
• Expert-level proficiency in SQL and Excel (pivot tables, advanced formulas, macros, Power Query).
• Experience with data visualization tools such as Power BI or Tableau preferred.
• Strong knowledge of jewellery product attributes and market dynamics is a plus.
• Ability to interpret complex data and generate actionable recommendations for assortment, pricing, and promotions.
• Excellent communication skills with the ability to present insights clearly to cross-functional teams and senior management.
• Strong business acumen, analytical mindset, and problem-solving skills.