Contact: Shaikh Abdulla (Recruitment Manager)
No. 8356828820
Job Location: Andheri (MIDC)
Experience: Minimum 5 years in Diamonds/ Jewellery Merchandising and Inventory Planning.
Key Responsibilities:
- Maintain accurate SKU database including metal weights, diamond specifications, stock, WIP and pricing.
- Track inventory movement across manufacturing/WIP, warehouse and stores.
- Monitor ageing stock, low stock alerts and inventory discrepancies.
- Maintain historical sales data for planning and trend analysis.
- Support store-wise assortment planning based on sales trends and customer demand.
- Ensure availability of NOOS (Never-Out-of-Stock) products while minimizing slow/non-moving inventory.
- Plan stock allocation for new launches and collections.
- Analyze sell-through and historical trends to forecast demand.
- Coordinate purchase requests with production and procurement teams.
- Analyze the impact of promotions on margins and sell-through.
- Publish DSR, inventory health reports and planning dashboards.
- Identify dead stock and recommend stock transfers or markdown strategies.
- Support working capital optimization initiatives.
Required Skills
- Strong data analysis and reporting skills.
- Advanced Excel skills including XLOOKUP, VLOOKUP, INDEX-MATCH, SUMIFS, Pivot Tables, formulas & functions and dashboards.
- Experience in data cleaning, automation, reporting, and creating auto-updating dashboards (Power BI preferred).
- Good understanding of inventory planning, replenishment, stock ageing and merchandising processes.
Key Competencies
- Strong analytical and problem-solving skills.
- High attention to detail and accuracy.
- Effective stakeholder coordination and communication skills.
- Ability to present inventory and sales insights to management.
Job Type: Full-time
Pay: ₹45,000.00 - ₹60,000.00 per month
Work Location: In person
