AM- Inventory Analytics | Lenskart
Key Responsibilities
Inventory Analytics & Reporting
1. Prepare and maintain inventory MIS, analytical dashboards, and periodic management
reports.
2. Analyze inventory performance metrics, including stock aging, shrinkage, stock
availability, inventory turnover, and excess/obsolete inventory.
3. Monitor inventory trends and provide actionable insights to improve inventory accuracy
and operational efficiency.
4. Develop KPI dashboards and track key inventory performance indicators for business
reviews.
5. Support inventory planning, forecasting, and decision-making through data-driven
analysis.
6. Collaborate with Operations, Supply Chain, Finance, and Business teams to provide
inventory-related data and insights.
7. Identify process improvement opportunities and drive reporting automation initiatives.
8. Perform ad hoc analysis to support business requirements and strategic projects.
9. Ensure data accuracy, integrity, and consistency across inventory reporting systems.
Required Skills & Qualifications
Bachelor's degree in Engineering, Supply Chain, Operations, Statistics, Computer
1. Strong proficiency in Power BI for creating interactive dashboards and data
visualization.
2. Advanced knowledge of SQL for data extraction, manipulation, and reporting.
Good working knowledge of Python for data analysis, automation, and reporting.
3. Strong understanding of inventory management concepts such as stock aging,
shrinkage, inventory accuracy, replenishment, and inventory KPIs.
4. Experience working with large datasets and ERP/WMS systems is preferred.
5. Advanced Microsoft Excel skills (Pivot Tables, Power Query, Power Pivot, and advanced
formulas).