Category Analyst
1 week ago
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\u2014driving 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 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.
-
Category Management Intern
2 weeks ago
Bengaluru, Karnataka, India Wiingy Full time ₹ 6,00,000 - ₹ 12,00,000 per yearJob Overview:We're looking for a hands-onCategory Management Internwho can think strategically and execute creatively. You'll own one of Wiingy's core learning categories such asMusic, Language Learning, Math, or AIand drive its growth fromstrategy to execution.This is not a desk-only role. You'll be researching, experimenting, creating, and executing daily....
-
MIS Finance Analyst
3 hours ago
Bengaluru, Karnataka, India Reliance Retail Full time ₹ 60,000 - ₹ 1,20,000 per yearFinance Analyst Category Financial Management & ReportingAssist in preparing monthly, quarterly, and annual financial reports for the category.Support budget planning and forecasting activities.Track category-specific expenses and revenues.Reconcile financial discrepancies and ensure data accuracy.Data Analysis & InsightsAnalyze category performance metrics...
-
Principal Category Data Analyst
1 week ago
Bengaluru, Karnataka, India Coupang Internal Full time ₹ 12,00,000 - ₹ 36,00,000 per yearCompany IntroductionWe exist to wow our customers. We know we're doing the right thing when we hear our customers say, "How did we ever live without Coupang?" Born out of an obsession to make shopping, eating, and living easier than ever, we're collectively disrupting the multi-billion-dollar e-commerce industry from the ground up. We are one of the...
-
Senior Category Manager, Home Entertainment
1 week ago
Bengaluru, Karnataka, India Amazon Full time ₹ 12,00,000 - ₹ 36,00,000 per yearAmazon India is seeking a Senior Category Manager (SCM) to lead the Home Entertainment (HE) business — one of the largest and most strategically important categories within Consumer Electronics. This role demands high ownership, strategic thinking, and operational excellence to deliver customer-centric growth while driving profitability across a complex...
-
Analyst
1 week ago
Bengaluru, Karnataka, India Euromonitor Full time ₹ 4,00,000 - ₹ 8,00,000 per yearRole OverviewWe are hiring an Analyst/ Senior Analyst to support the building and evolution of Euromonitor's Product Claims solution. Reporting to the Senior Product Manager, New Product Development, this role is ideal for candidates with strong analytical skills, attention to detail, and an interest in understanding how brands position themselves and appeal...
-
Category Analyst
1 week ago
Bengaluru, Karnataka, India PhonePe Full time ₹ 60,00,000 - ₹ 1,50,00,000 per yearAbout PhonePe Limited:Headquartered in India, its flagship product, the PhonePe digital payments app, was launched in Aug 2016. As of April 2025, PhonePe has over 60 Crore (600 Million) registered users and a digital payments acceptance network spread across over 4 Crore (40+ million) merchants. PhonePe also processes over 33 Crore (330+ Million)...
-
Category Analyst
1 week ago
Bengaluru, Karnataka, India PhonePe Full time ₹ 8,00,000 - ₹ 12,00,000 per yearThe Role We're looking for a sharp, driven individual who thrives in a fast-paced environment. This isn't a role for someone who waits for instructions; we need a hustler who's ready to roll up their sleeves, identify opportunities, and get things done. You'll be working on a dynamic portfolio of products—think everything from travel and device insurance...
-
Investment Analyst
2 days ago
Bengaluru, Karnataka, India 16VC Full time ₹ 4,20,000 - ₹ 12,60,000 per yearCompany Description16VC is a global venture capital firm that invests in early-stage startups worldwide. With a focus on category-defining innovations at Pre-Seed and Seed stages, 16VC is dedicated to supporting the next generation of groundbreaking companies. Our mission is to identify and nurture high-potential startups to create substantial tangible...
-
Buyer Analyst
2 days ago
Bengaluru, Karnataka, India Teamware Solutions Full time ₹ 6,00,000 - ₹ 18,00,000 per yearJob Title: Senior BuyerDuration: 6 Months (Contract)Work Location: Bangalore, IndiaDepartment: Group ProcurementAbout the Department:Group Procurement is responsible for delivering value to the business through strategic sourcing, supplier relationship management, and process excellence. The department ensures procurement practices align with business goals,...
-
ERP Functional Analyst III
2 days ago
Bengaluru, Karnataka, India Arrow Electronics Full time ₹ 6,00,000 - ₹ 18,00,000 per yearPosition:ERP Functional Analyst IIIJob Description:15+ Years experience in new implementations of Oracle E-Business Suite Projects in Supply Chain Planning. Industry experience will be an added advantage.Solutioning experience is must for this position.Location:IN-KA-Bangalore, India (SKAV Seethalakshmi) GESCTime Type:Full timeJob Category:Information...