with strong analytical skills to join our jewellery company. The ideal candidate will leverage SQL and advanced Excel expertise to perform comprehensive category analytics--driving assortment optimization, pricing strategy, and promotional effectiveness for jewellery categories. Your insights will directly impact category growth and profitability by aligning data-driven recommendations with customer preferences and market trends.
Key Responsibilities:
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
Qualifications:
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.
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.