Job Title: MIS Executive

Department: Operations / Commercial / Management Support

Location: Kolkata

Employment Type: Full-Time

Experience: 1–4 Years

Industry: Steel / Metal Manufacturing

Job Purpose

The MIS Executive will be responsible for collecting, validating, analysing, and reporting operational, commercial, and financial data to support day-to-day business decisions in a steel manufacturing workplace.

The role will primarily focus on production, raw materials, inventory, dispatch, quality, costing, and sales reporting using ERP systems and advanced Microsoft Excel.

Key Responsibilities

1. Production & Operations Reporting

- Prepare daily, weekly, and monthly MIS reports on production output.

- Monitor planned vs. actual production, shift-wise performance, yield, rejection, rework, and machine downtime.

- Maintain trackers for machine utilisation, power consumption, fuel consumption, scrap generation, and manpower productivity.

- Monitor key manufacturing KPIs, including production tonnage, conversion cost, yield percentage, downtime hours, OEE, and rejection rates.

- Coordinate with production, maintenance, quality, stores, and dispatch departments for accurate data collection.

2. Inventory, Purchase & Stores MIS

- Maintain stock reports for raw materials, semi-finished goods, finished goods, scrap, consumables, spares, and packing materials.

- Track inward receipts, GRN details, material issues, WIP movement, stock reconciliation, ageing, and reorder levels.

- Prepare purchase, supplier, rate comparison, pending PO, and material shortage reports.

- Support physical stock verification and reconcile ERP stock with physical stock.

3. Sales, Dispatch & Commercial MIS

- Prepare reports on order booking, dispatch, pending orders, customer-wise sales, product-wise sales, freight, and target vs. achievement.

- Track dispatch plans,



vehicle loading, delivery status, customer complaints, and sales returns.

- Support invoicing, rate master, customer master, and commercial documentation.

- Prepare receivables ageing, collection follow-up, and customer outstanding reports in coordination with the accounts department.

4. Costing, Finance & Management Reports

- Assist in preparing production cost, conversion cost, variance analysis, scrap loss, power cost, freight cost, and profitability reports.

- Prepare monthly management reports, dashboards, and variance analysis.

- Support budgeting, target setting, cost-control initiatives, and other management-related analytical requirements.

5. ERP, Data Management & Automation

- Extract, clean, reconcile, and validate data from ERP, Excel, Google Sheets, weighbridge records, and manual registers.

- Maintain accurate master data, including item codes, BOMs, customer/vendor details, rates, units, and product specifications.

- Develop Excel dashboards, pivot-based reports, automated trackers, and standard reporting formats.

- Identify data discrepancies and coordinate corrective actions with concerned departments.

- Suggest and implement automation and process improvements to reduce manual reporting efforts.

Required Qualifications & Experience

- Graduate in Commerce, Business Administration, Statistics, Mathematics, Computer Applications, Engineering, or a related field.

- 1–4 years of experience in MIS, Data Analysis, ERP Reporting,



Production Planning, Stores, Commercial, or Manufacturing Operations.

- Experience in the steel or metal manufacturing industry will be preferred.

- Knowledge of manufacturing processes such as melting, rolling, forging, casting, finishing, quality checks, packing, and dispatch will be an advantage.

- Experience working in an MSME or multi-department manufacturing environment is desirable.

Technical Skills

- Advanced Microsoft Excel, including:

- Pivot Tables

- VLOOKUP / XLOOKUP

- INDEX-MATCH

- SUMIFS / COUNTIFS

- IF Formulas

- Data Validation

- Conditional Formatting

- Charts and Dashboards

- Working knowledge of ERP systems.

- Ability to extract and understand reports related to production, inventory, GRN, BOM, WIP, dispatch, and finished goods.

- Knowledge of Power BI, Google Sheets, Power Query, Macros/VBA, or SQL will be an added advantage.

- Strong analytical and data interpretation skills.

Required Competencies

- High accuracy and attention to detail.

- Strong numerical, analytical, and problem-solving abilities.

- Good written and verbal communication skills.

- Ability to coordinate with production, accounts, sales, and management teams.

- Ability to manage multiple deadlines independently.

- Maintaining confidentiality of commercial, customer, vendor, and cost-related information.

Key Performance Indicators (KPIs)

- Timely submission of daily, weekly, and monthly MIS reports.

- Accuracy of production, inventory, dispatch, and commercial reports.

- Reduction in reporting errors and manual reconciliation efforts.

- Maintaining reliable dashboards for management decision-making.

- Improved visibility of production, cost, quality, stock, and sales performance.

Pay: Up to ₹25,000.00 per month

Work Location: In person

📌 MIS Executive (Kolkata)
🏢 Duas Knowledge Potli
📍 Kolkata