Category Analyst-Merchandising

21 hours ago

Bengaluru, Karnataka, India Titan Full time ₹ 4,20,000 - ₹ 5,40,000 per year
Job Requirements

Experienced 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 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.

  • Merchandising Executive-Category

    1 week ago

    Bengaluru, Karnataka, India Titan Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Job Requirements Job Description: Merchandising Executive-Category at TitanCompany Name: TitanJob Title: Merchandising Executive-CategoryJob Type: Full-TimeJob Category: Jewellery-SMRDepartment: Merchandising-TanishqLocation: Bengaluru, Karnataka, IndiaOverview:Titan, a leading jewellery brand, is seeking a highly motivated and experienced Merchandising...

  • Category Merchandising Manager

    1 week ago

    Bengaluru, Karnataka, India Titan Full time ₹ 4,00,000 - ₹ 6,00,000 per year

    Job Requirements Job Title: Category Merchandising ManagerJob Type: RPWe are seeking a Category Merchandising Manager to join our team. The primary responsibility of this role is to ensure the appropriate product/merchandise mix in the stores by analyzing overall market trends and competition. The ideal candidate will study the respective store catchment...

  • Site Merchandiser Category

    2 weeks ago

    Bengaluru, Karnataka, India Target Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    About us:As a Fortune 50 company with more than 400,000 team members worldwide, Target is an iconic brand and one of America's leading retailers.​Working at Target means the opportunity to help all families discover the joy of everyday life. Caring for our communities is woven into who we are, and we invest in the places we collectively live, work and...

  • Merchandising Executive-Category

    1 week ago

    Bengaluru, Karnataka, India Titan Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Job Requirements Job Description: Executive- Category Merchandising JewelleryJob DescriptionUnique Job RoleExecutive - Category Merchandising JewelleryFunctionMerchandising Reporting toManager Category Merchandising JewelleryBusinessJewellery Grade Date---Job DetailsTo ensure right product/ merchandise mix in the stores by analysing overall market trends...

  • Category Merchandising Manager

    21 hours ago

    Bengaluru, Karnataka, India Titan Full time ₹ 12,00,000 - ₹ 25,00,000 per year

    Job Requirements  Job DetailsTo ensure right product/ merchandise mix in the stores by analysing overall market trends & competition while studying the respective store catchment areas to ensure continuity in the product supply to improve the profit marginsExternal InterfacesInternal InterfacesKey customersVendors Third Party Service ProvidersExternal...

  • Specialist_Digital Category

    3 days ago

    Bengaluru, Karnataka, India The businesses of Merck KGaA, Darmstadt, Germany Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Work Your Magic with us  Ready to explore, break barriers, and discover more? We know you've got big plans – so do we Our colleagues across the globe love innovating with science and technology to enrich people's lives with our solutions in Healthcare, Life Science, and Electronics. Together, we dream big and are passionate about caring for our rich mix...

  • Specialist_Digital Category

    3 days ago

    Bengaluru, Karnataka, India Merck Group Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Work Your Magic with usReady to explore, break barriers, and discover more? We know you've got big plans – so do we Our colleagues across the globe love innovating with science and technology to enrich people's lives with our solutions in Healthcare, Life Science, and Electronics. Together, we dream big and are passionate about caring for our rich mix of...

  • Category Manager

    2 weeks ago

    Bengaluru, Karnataka, India Talks About People HR Solutions Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    We're Hiring | Manager – Category Merchandising (Luxury/ Jewellery/ Apparel)Location:Corporate Office, BangaloreExperience:5–8 Years ( Fashion / Jewellery / Garments industry)Qualification:GraduateAbout the Role:We're looking for aManager – Category Merchandising (Jewellery)to ensure the right product mix across stores by analyzing market trends,...

  • Category Associate

    4 days ago

    Bengaluru, Karnataka, India Unacademy Full time ₹ 2,50,000 - ₹ 7,50,000 per year

    The Category Associate supports the category team in driving sales, profitability, and market share for assigned product categories. This role involves data analysis, supplier coordination, inventory management, and execution of category plans to ensure an optimal product mix, pricing, and promotional strategy.Key Responsibilities:Category OperationsSupport...

  • Category Manager

    1 week ago

    Bengaluru, Karnataka, India Titan Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Requirements Job Title: Category ManagerCompany Name: TitanJob Type: Regular/PermanentJob Category: Jewellery-SMRDepartment: Mia-MerchandisingLocation: Bengaluru, Karnataka, IndiaPosition Overview:To craft and introduce the right product/ merchandise mix in the stores by analysing overall market trends & competition while studying the respective store...