Category Analyst - Merchandising (Jewellery)
- Titan Company
- 3 - 5 years
- Bengaluru
- 5 months ago
- Email to a friend
- Report this job
Job Description
Job RequirementsExperienced and detail-oriented Category Analyst with strong analytical skills to join our jewellery company. The ideal candidate will leverage SQL and advanced Excel expertise to perform comprehensive category analyticsu2014driving 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.
Qualifications:
- Master 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.
Job Classification
Industry: RetailFunctional Area / Department: Merchandising, Retail & eCommerceRole Category: Category Management & OperationsRole: Category ExecutiveEmployement Type: Full timeContact Details:
Company: Titan CompanyLocation(s): Bengaluru
Keyskills: macros power bi pivot table business acumen sql python data warehousing demand planning merchandising retail analytics power query customer segmentation tableau jewellery java data integration tools buying pricing strategy luxury sales html etl
Similar positions
Titan Company
A leading firm in Engineering, Architecture, Construction, Environmental and Consulting Solutions.
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in