Management Information System Executive

About the Role

We are looking for a highly organized, analytical, and detail-oriented professional to manage the end-to-end reporting activities of our shoe and leather chemicals manufacturing unit. The primary objective is to provide management with accurate, timely, and comprehensive reports to monitor manufacturing performance, control wastage, maintain inventory accuracy, and improve operational efficiency.

Key Responsibilities

• Production Reporting
• Prepare daily, weekly, and monthly production reports.
• Maintain product-wise and batch-wise production records.
• Compare planned production with actual output.
• Track raw materials issued against finished goods produced.
• Raw Material & Inventory Management
• Maintain records of raw material stock, work-in-progress, and finished goods.
• Track opening stock, purchases, consumption, transfers, and closing stock.
• Reconcile physical stock with recorded inventory and investigate discrepancies.
• Monitor material availability and highlight shortages or excess inventory.
• Wastage & Consumption Analysis
• Record production wastage and process losses in kilograms.
• Calculate wastage percentages and compare actual consumption against standard requirements.
• Identify unusual material losses and report discrepancies to management.
• Maintain batch-wise records of raw material input and finished goods output.
• Purchase & Sales Reporting
• Maintain supplier-wise purchase records, quantities, rates, and material receipts.
• Prepare product-wise sales and dispatch reports.
• Track pending purchase orders and material deliveries.
• Reconcile purchase, production, sales, and stock data.
• Manufacturing Costing
• Assist in calculating product-wise manufacturing costs.
• Track raw material cost per kg, production cost per kg, and wastage-related costs.
• Prepare consumption and production variance reports.
• Help management identify opportunities to improve cost efficiency.
• MIS & Management Reporting
• Prepare daily, weekly, and monthly MIS reports for management.
• Develop structured Excel reports and dashboards for production, inventory, purchases, sales, and wastage.
• Coordinate with production, stores, purchase, sales, and accounts teams to collect accurate data.
• Highlight important discrepancies, unusual trends, and operational issues requiring management attention.

Requirements & Tech Stack

• MS Excel (strong working knowledge, including formulas, PivotTables, SUMIFS, and VLOOKUP/XLOOKUP)
• Tally Prime or ERP knowledge (an advantage)

Qualifications

• B.Com / M.Com (preferred for accounting, inventory, and costing knowledge)
• BBA / MBA in Operations or Supply Chain Management
• B.Tech/B.E. in Industrial, Mechanical, or Chemical Engineering (suitable for candidates with strong reporting and analytical skills)
• Candidates from reputed colleges or universities will be preferred.
• Freshers with excellent analytical skills and Excel proficiency may apply.

Ideal Candidate Profile

• Takes ownership of reporting.
• Verifies data instead of simply entering it.
• Identifies discrepancies.
• Ensures that management receives reliable information.
• Comfortable working with factory teams.
• Handles large volumes of data.
• Maintains systematic records.
• Prior manufacturing experience is an advantage but not mandatory for candidates who demonstrate strong practical skills.