Category Analyst-Merchandising (Jewellery)

Titan Company; Bangalore Rural; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Titan Company is seeking a data-driven analyst in Bangalore to drive category and inventory analytics, customer insights, and digital reporting initiatives. You will build dashboards, support forecasting, and translate data into actionable store and assortment plans.

With 2–5 years in category or retail analytics and a Master's in Business, Analytics, Statistics, Finance, or a related field, you will analyse sales trends, ageing stock, promotions, margins, and pricing effectiveness,

Qualifications

• Master's degree required or equivalent in Business, Analytics, Statistics, Finance or related field.
• 2–5 years hands-on experience in category or retail analytics.
• Experience in jewellery, fashion, or luxury retail is an advantage.
• Strong SQL skills and advanced Excel capabilities.
• Proficiency with reporting tools such as Power BI or Tableau.

Responsibilities

• Analyse product and category performance including sales trends, sell-through, ageing stock, and inventory value.
• Identify slow-moving products and recommend actions (range rationalisation, stock reallocation, clearance).
• Monitor impact of festivals, seasons, and promotions on sales and margins.
• Support demand planning and forecasting to ensure availability of right products at right time.
• Translate sales targets into store-level plans based on category potential.
• Model pricing and discounts to balance customer appeal with margin protection.
• Benchmark pricing and promotions against competitors to stay market relevant.
• Review franchise commercial arrangements and identify cost optimisation opportunities.
• Track margin flow from sourcing to store and flag improvement areas.

Skills

SQL for data extraction and analysis

Advanced Excel

Data visualization (Power BI/Tableau)

ERP/POS familiarity

Data-driven decision making

Effective communication

Education

Master's degree in Business/Analytics/Statistics/Finance or related field

Tools

SQL

Excel

Power BI

Tableau

ERP

POS systems

Job description

Job Requirements

Category & Inventory Analytics

• Analyse product and category performance — looking at sales trends, sell-through rates, ageing stock, and inventory value.
• Identify slow-moving products and recommend practical actions such as range rationalisation, stock reallocation, or clearance.
• Track the impact of festivals, seasons, and promotions on sales and margins.
• Support demand planning and forecasting to ensure the right products are available at the right time.
• Help translate sales targets into store-level plans based on category potential.
• Analyse pricing effectiveness and model discount and offer strategies — balancing customer appeal with margin protection.
• Benchmark pricing and promotional practices against competitors to stay market relevant.
• Review commercial arrangements with franchise partners and identify cost optimisation opportunities.
• Track margin flow across the value chain — from sourcing to store — and flag areas for improvement.

Customer Insights

• Use data to understand who our customers are, what they buy, what they buy together, and what encourages them to purchase.
• Segment customers based on their preferences, spending patterns, and response to offers.
• Combine customer, product, geography, and time data to generate insights that feed directly into business decisions on retention, assortment, and promotions.

Dashboards, Reporting & Digital Initiatives

• Build and maintain dashboards that give teams a clear, up-to-date view of category performance, inventory health, and key business metrics.
• Support the business in moving to newer, more efficient reporting systems — tracking adoption and measuring impact.
• Take on ad-hoc analysis projects as and when the business needs fresh perspectives on emerging trends or risks.

Work Experience

Education

• Master's degree in Business, Analytics, Statistics, Finance, or a related field.

Experience

• 2–5 years of hands-on experience in category or retail analytics.
• Prior experience in jewellery, fashion, or luxury retail is an advantage.

What You Bring

• Strong, working proficiency in SQL for data extraction and analysis.
• Advanced Excel skills — pivot tables, complex formulas, macros, and Power Query.
• Experience with reporting tools such as Power BI or Tableau is preferred.
• Familiarity with ERP or point-of-sale systems is a plus.
• Able to simplify complex data into clear, actionable business insights.
• Organised, thorough, and comfortable managing multiple priorities at once.
• Confident presenting findings to both analytical and non-technical audiences.