Category Analyst
3 days 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.
-
Bengaluru, Karnataka, India Lowe's Home Improvement Full time ₹ 15,00,000 - ₹ 25,00,000 per yearLowe's is a FORTUNE 100 home improvement company serving approximately 16 million customer transactions a week in the United States. With total fiscal year 2024 sales of more than $83 billion, Lowe's operates over 1,700 home improvement stores and employs approximately 300,000 associates. Based in Mooresville, N.C., Lowe's supports the communities it serves...
-
Category Management Intern
7 days 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....
-
Category Management Intern
6 days ago
Bengaluru, Karnataka, India, Karnataka Wiingy Full timeJob Overview:We’re looking for a hands-on Category Management Intern who can think strategically and execute creatively. You’ll own one of Wiingy’s core learning categories such as Music, Language Learning, Math, or AI and drive its growth from strategy to execution.This is not a desk-only role. You’ll be researching, experimenting, creating, and...
-
Senior Category Manager, Home Entertainment
5 days 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
3 days 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
3 days 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...
-
Category Analyst
3 days 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)...
-
Prjt Mgmt Analyst
2 weeks ago
Bengaluru, Karnataka, India Target Full time ₹ 15,00,000 - ₹ 25,00,000 per yearProject Management Analyst, MarketingAbout 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. Joining Target means promoting a culture of mutual care and respect and striving to make the most meaningful and positive impact. Becoming a Target team member means joining a...
-
SOC Analyst
2 weeks ago
Bengaluru, Karnataka, India Outworx Solutions Full time ₹ 9,00,000 - ₹ 12,00,000 per yearLevel: L1+L2A level one (L1) Security Operation Center (SOC) analyst performs several activities in addition to the monitoring activity:Monitor security alertsParticipate in use case and rule workshopsParticipate in rule tuning sessionsParticipate in response procedure workshopsParticipate in lessons learned workshopsParticipate in education sessions as...
-
Business Analyst with QA Automation
3 days ago
Bengaluru, Karnataka, India giridhara software services Full time ₹ 9,00,000 - ₹ 12,00,000 per yearJob Description:We are looking for an experienced Business Analyst with QA Automation expertise to join on a contract basis for 3 months at our Bangalore location. The ideal candidate should have strong business analysis skills combined with hands-on QA automation experience.ResponsibilitiesGather, analyze, and document business requirements and translate...
