Job Description – Data Analyst (Merchandising)Position
Data Analyst – Merchandising
Department
Merchandising / Retail Operations
Reporting To
Commercial Manager / Head of Merchandising
Location
As per company requirement (Travel to stores as and when required)
About the Role
We are looking for a highly analytical and detail-oriented Data Analyst to support merchandising and inventory decisions across multiple Tanishq stores. The ideal candidate will transform sales, inventory, customer, and product data into actionable insights that improve product availability, inventory productivity, sales performance, and customer satisfaction.
This role requires strong analytical abilities, advanced Excel skills, and the capability to work closely with merchandising, store operations, buying, and management teams.
Key ResponsibilitiesSales Analysis
- Analyze daily, weekly, and monthly sales performance across all stores.
- Identify fast-moving, slow-moving, and non-moving products.
- Monitor category-wise, collection-wise, design-wise, and SKU-wise performance.
- Track achievement against sales targets and provide actionable recommendations.
- Analyze seasonal and festival sales trends.
Inventory & Merchandising Analysis
- Monitor inventory health across all stores.
- Identify excess, ageing, and dead stock.
- Recommend stock transfers between stores based on demand.
- Ensure optimum assortment across all locations.
- Analyze replenishment requirements and suggest purchase quantities.
- Monitor stock availability to minimize lost sales.
Product Performance Analysis
- Evaluate new product launches.
- Analyze conversion rates of new collections.
- Recommend continuation or discontinuation of products.
- Track sell-through percentages.
- Identify product gaps by region or store.
Store Performance Analysis
- Compare performance across stores.
- Prepare benchmarking reports.
- Identify best-selling designs by location.
- Recommend merchandising improvements for underperforming stores.
Dashboard & Reporting
- Create automated dashboards using Excel or Power BI.
- Generate Daily Sales Reports (DSR).
- Generate Weekly Business Review (WBR).
- Generate Monthly Business Review (MBR).
- Prepare management presentations with key insights.
- Ensure data accuracy across reports.
Demand Forecasting
- Forecast future demand using historical sales data.
- Support festive and seasonal inventory planning.
- Assist management in purchase planning.
- Predict inventory requirements to avoid stock-outs.
Commercial Support
- Monitor stock rotation efficiency.
- Calculate inventory turnover ratios.
- Track gross margin by category.
- Support pricing and discount analysis.
- Analyze impact of promotional campaigns.
Data Management
- Maintain accurate master data.
- Validate sales and inventory data.
- Identify data inconsistencies.
- Coordinate with store teams for data corrections.
Cross-functional Coordination
- Work closely with:
- Store Managers
- Cluster Merchandisers
- Inventory Team
- Commercial Team
- Finance Team
- Retail Operations
- Support business review meetings with analytical inputs.
Key Performance Indicators (KPIs)
- Inventory Turnover
- Sell-through Percentage
- Stock Availability
- Reduction in Ageing Inventory
- Stock Transfer Efficiency
- Forecast Accuracy
- Dashboard Accuracy
- Report Timeliness
- Sales Growth through Merchandising Interventions
- Reduction in Stock-outs
- Data Accuracy
Required SkillsTechnical Skills
- Advanced Microsoft Excel (Pivot Tables, Power Query, Advanced Formulas, Dashboards, VBA preferred)
- Power BI or Tableau
- SQL (Preferred)
- Google Sheets
- Strong analytical and reporting skills
- Data visualization
- Forecasting techniques
- Statistical analysis (Preferred)
Business Skills
- Inventory management
- Retail merchandising
- Sales analysis
- Business reporting
- Commercial understanding
- Problem-solving
- Process improvement
Soft Skills
- Strong analytical thinking
- Attention to detail
- Excellent communication skills
- Time management
- Decision-making ability
- Team collaboration
- Ability to work under deadlines
Educational Qualification
- Bachelor's Degree in Commerce, Mathematics, Statistics, Economics, Business Analytics, Engineering, or a related field.
- MBA (Operations, Retail, Business Analytics, or Supply Chain) is preferred.
Experience
- 2–5 years of experience in retail analytics, merchandising, inventory planning, business intelligence, or commercial analysis.
- Experience in jewellery, fashion, apparel, lifestyle, or luxury retail will be preferred.
Preferred Knowledge
- Retail KPIs
- Inventory planning
- Assortment planning
- ABC analysis
- FSN analysis
- Ageing analysis
- Sell-through analysis
- Demand forecasting
- Inventory replenishment
- Multi-store retail operations
- Jewellery retail business (Preferred)
Success in This Role
A successful Data Analyst will enable management to make faster, data-driven merchandising decisions, improve inventory productivity, reduce ageing stock, optimize product assortment across stores, and ultimately drive higher sales and customer satisfaction through actionable business insights.
Pay: ₹40,000.00 - ₹50,000.00 per month
Benefits:
- Leave encashment
- Provident Fund
Work Location: In person
