MIS Executive - Cost Accounting

Job Title: MIS Executive - Cost Accounting

Industry: Iron & Steel
Experience: 4-8 Years
Qualification: Graduate (B. Com / BBA / BMS preferred; MBA Finance is a plus)
Department: Finance / Costing / MIS
Location: Tadipatri, Andhra Pradesh

Job Summary:
The MIS Executive will be responsible for preparing, analyzing, and maintaining management information systems with a focus on department-wise cost accounting in the iron and steel manufacturing environment. The role involves tracking production costs, variance analysis, budgeting support, and generating actionable insights for management.

Key Responsibilities:

1. MIS & Reporting
   -Prepare daily, weekly, and monthly MIS reports for management.
   -Develop department-wise cost reports (production, procurement, logistics, etc.).
   -Automate MIS reports using Excel (Pivot Tables, Power Query, Macros).
   -Ensure data accuracy and timely reporting.

2. Cost Accounting (Core Role)
   -Monitor and analyze production costs (raw material, labor, overheads).
   -Maintain cost sheets for steel/iron products.
   -Conduct variance analysis (actual vs standard cost).
   -Track per ton cost of production and identify cost-saving opportunities.
   -Support inventory valuation and reconciliation.

3. Department-wise Cost Tracking
   -Allocate costs across departments (Melting, Rolling Mill, Furnace, Dispatch, etc.).
   -Analyze department efficiency and cost utilization.
   -Provide insights to reduce wastage and improve operational efficiency.

4. Data Analysis & Controls
   -Collect and validate data from plant, stores, and accounts.
   -Maintain dashboards for cost trends and KPIs.
   -Ensure internal controls for data accuracy and compliance.

5. Budgeting & Forecasting
   -Assist in preparation of annual budgets and monthly forecasts.

• Compare actual performance against budgets and highlight deviations.

6. Coordination
   -Work closely with production, procurement, and finance teams.
   -Coordinate with plant teams for real-time data collection.

Key Skills Required:
-Strong knowledge of Cost Accounting & MIS reporting
-Advanced MS Excel (Pivot, VLOOKUP/XLOOKUP, Power Query; VBA is a plus)
-Understanding of iron & steel manufacturing processes
-Analytical and problem-solving skills
-Knowledge of ERP systems (SAP / Tally / Oracle preferred)
-Attention to detail and accuracy

Key KPIs / Performance Metrics:
-Accuracy and timeliness of MIS reports
-Cost variance reduction
-Efficiency in department-wise cost tracking
-Quality of insights provided to management

Preferred Candidate Profile:
-Experience in steel plants, rolling mills, or manufacturing units
-Exposure to production costing and inventory management
-Ability to handle large datasets and generate insights