MIS Executive
Duas Knowledge Potli · Kolkata, West Bengal · Full Time · Onsite
Posted
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 environment. 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