21 Nov
|
Ravi Sachdev
|
Vadodara
21 Nov
Ravi Sachdev
Vadodara
Reports To: Management
Experience: 4–6 years in data analysis/MIS, including 2+ years working with large dataset.
Role Objective: Own reporting, analysis, and decision support for management by building and running the automated reports and planning tools that convert ERP and operational data into accurate, actionable outputs for sales, inventory, replenishment, and procurement decisions.
Key Responsibilities
- Own report design, business logic, and quality checks for all management reporting, and guide and review the work of the Jr Analyst.
- Prepare and maintain periodic management reports covering sales performance, stock position and ageing, stock coverage, product movement, and procurement planning.
- Run the inventory planning tools: supplier re-order sheets, warehouse-to-store replenishment, and tracking of pending orders and shipments.
- Build demand forecasts and planning analysis (Pareto classification, lost-sales estimates, product performance and margin) to support purchasing decisions.
- Maintain and extend the existing automated report pipelines (SQL extracts from SAP B1, Python processing, Excel and HTML outputs), with a documented run procedure for each.
- Ensure consistency and accuracy between analytical outputs and ERP/accounting data; validate every report before it is issued.
- Own the item master and product classification data used across reports.
- Partner with sales, operations, procurement, logistics, and finance teams to understand workflows and reflect them accurately in reports.
- Take up additional analysis, dashboards, and management presentations as required by Management.
Required Skills
- Exposure to Python for data work (pandas, numpy, openpyxl): experience using AI coding assistants (e.g., Code X, Claude Code, Cursor etc) with proper testing of their output would be an added advantage.
- Hands-on SAP Business One experience: sales and purchasing document flow, inventory, warehouses, and batches.
- Advanced proficiency in Excel, including formulas, pivot tables, Power Query, and formula-driven planning sheets.
- Solid analytical and reconciliation ability: able to identify errors, trace differences, and validate numbers independently.
- Clear written communication and ability to present findings and recommendations to management.
- Ability to work independently, handle multiple recurring deadlines (including month-end), and guide a junior analyst.
Pay: ₹30,000.00 - ₹70,000.00 per month
Benefits:
- Health insurance
- Leave encashment
- Provident Fund
Work Location: In person
📌 Data Analyst (Vadodara)
🏢 Ravi Sachdev
📍 Vadodara