Job
Description
About the Role: We are seeking for a candidate who is responsible for managing and analyzing organizational data to support decision-making and operational efficiency. The role involves collecting, consolidating, and maintaining accurate data from various departments, generating regular and ad-hoc reports, and creating dashboards using tools like Excel, SQL, and Power BI. They analyze data to identify trends, track key performance indicators (KPIs), and provide actionable business insights. The role also includes ensuring data integrity, automating repetitive tasks, supporting system implementation, and coordinating with cross-functional teams. Key Responsibilities: MIS & Data Management Develop and maintain daily, weekly, and monthly MIS reports across sales, warehouse, dispatches, and order tracking. Consolidate data from SAP S/4HANA (SD/MM/WM modules) and prepare actionable dashboards. Track KPIs like order fulfillment, dispatch lead time, warehouse stock levels, vehicle TAT, and sales achievement vs targets. Automate repetitive reports using Excel formulas, pivot tables, Power Query, and macros if needed. Logistics & Dispatch Monitoring Monitor daily dispatches against Sales Orders and PRNs. Maintain transport tracking sheets and delivery compliance reports. Coordinate with transporters and warehouses for timely shipment, material return (if any), and POD collection. Support freight invoice verification and exception handling. Warehouse & Inventory Reporting Analyze warehouse stock levels by material code (A/B/C Grade, reel/sheet format). Ensure FIFO adherence, stock aging, and batch-wise tracking. Report slow/non-moving inventory and support warehouse audit data. Sales & Order Management Support Maintain database of customer-wise orders, dispatches, and pending deliveries. Help Sales/Marketing team with customized reports on customer-wise liftings, state-wise sales, or grade-wise trends. Support the team during quarter/month-end reviews and data presentation. Process Improvement & Compliance Identify and implement improvements in reporting cycles. Ensure timely and accurate documentation to support statutory, audit, and internal control requirements. Preferred Skills: Proficiency in MS Excel (VLOOKUP, Pivot, Power Query, Dashboards). Working knowledge of SAP S/4HANA (especially SD/MM/WM modules). Strong analytical and communication skills. Basic understanding of warehouse/logistics operations in a manufacturing setup. Ability to coordinate with multiple departments and prioritize work. Qualifications: Graduate in Commerce/Science/Engineering or MBA/PGDM in SCM, Operations related fields Experience: 2–6 years’ experience in MIS/SCM/Operations roles, preferably in paper or FMCG manufacturing. Show more Show less
