Position : MIS Executive
Department : Marketing
Location : Ahmedabad
Reporting : Operations Manager
1. Job Purpose
To collect, analyze, maintain, and present operational, production, inventory, and performance data of the steel plant. Ensure accuracy, timely reporting, and decision-support insights for management.
2. Key Responsibilities
A. MIS & Reporting
- Prepare and maintain daily, weekly, and monthly MIS reports for production, consumption, inventory, manpower, breakdowns, and KPIs.
- Generate dashboards, trend charts, and performance analysis using Excel, SAP, or other ERP tools.
- Consolidate department-wise reports and share with management on time.
- Prepare variance analysis (Plan vs. Actual) for production and raw material consumption.
B. Data Management & Analysis
Collect data from production, maintenance, stores, logistics, and quality departments.Validate data accuracy; identify discrepancies and coordinate corrections.Perform data analysis for cost optimization, productivity improvement, and loss identification.Support management with custom analytical reports as needed.C. SAP Operations
Input and extract data related to production, raw material usage, inventory, and dispatch.Ensure correct mapping of material codes, BOM, and plant process entries.Coordinate with IT / SAP team for system issues or enhancements.
D. Inventory & Material Monitoring
Track RM / PM / consumables inventory, wastage reports, and material movement.Monitor stock levels and highlight shortages / excess.Prepare consumption vs. standard usage reports for cost control.E. Compliance & Documentation
Maintain documentation for audits (ISO, Safety, Quality, Statutory).Support regulatory reporting by providing required data.Ensure secure and systematic record-keeping.F. Cross-Functional Coordination
Work closely with Production, Maintenance, Quality, Purchase, and Stores departments.Assist management in decision-making with real-time data insights.Support improvement projects and digital initiatives.3. Skills & Competencies Required
Technical Skills
Strong command over Excel (Advanced) – pivot tables, macros, charts, dashboards.Good working knowledge of SAP / ERP systems.Understanding of steel plant operations (production processes, raw materials, finished goods).Knowledge of Power BI / Tableau (preferred).Behavioral Skills
High accuracy and attention to detail.Strong analytical and problem-solving skills.Good communication and coordination abilities.Discipline in meeting deadlines.Team collaboration and positive attitude.4. Qualifications & Experience
Education : B.Com / BBA / B.Sc. / Diploma / B.Tech / MBA (preferred).
Experience : 5–10 years of MIS experience in a manufacturing / steel / heavy engineering industry.
Knowledge of SAP is highly preferred.
5. Key Performance Indicators (KPIs)
Accuracy of reports and dashboards.Timeliness of MIS submissions.Reduction in reporting errors.Data-driven insights provided for operational improvement.Effective ERP data management.Support in audits and compliance.