MIS Executive

Job highlights

• 1-2 years as MIS Executive in manufacturing with advanced Excel, Google Sheets, Tally integration, AI tools, and FMS proficiency
• Integrate and analyze financial data, automate reporting, design Google Forms, manage Flow Management Systems, and prepare MIS reports

Location: Factory Site (Candidate must reside within a 45-minute travel radius)

Industry: Transformer Manufacturing / Electrical Equipment Manufacturing

Experience: 1 to 2 Years

Employment Type: Full-Time

Job Overview

We are seeking an analytical, detail-oriented MIS Executive with 12 years of experience in a manufacturing environment. The ideal candidate will be proficient in Advanced Excel, Google Sheets, AI tools, and data automation, with hands-on experience integrating Tally data into spreadsheets to perform financial, production, and profitability calculations. You will also design Google Forms and set up Flow Management Systems (FMS) to streamline cross-departmental operations.

Key Responsibilities & Essential Functions

1. Data Integration & Financial/Profitability Analysis

• Import, clean, and consolidate financial and transactional data from Tally Prime / ERP into Advanced Excel and Google Sheets.
• Calculate product-wise and batch-wise profit margins, contribution margins, and cost variances for transformer production.
• Analyze Raw Material vs. Finished Goods consumption (e.g., copper, core material, transformer oil, steel) to track material yield and wastage.
• Maintain monthly P&L trackers, cost-sheet analysis, and overhead distribution reports for management decision-making.

2. Advanced Excel, Google Sheets & AI Automation

• Build and manage dynamic dashboards using complex formulas (XLOOKUP, INDEX-MATCH, SUMIFS, nested logic statements, Array Formulas, and Query functions).
• Automate data workflows using Google Apps Script, Excel VBA/Macros, and AI tools (ChatGPT, Gemini, Power Automate) to reduce manual reporting time.
• Standardize reporting formats across departments (Sales, Procurement, Production, Quality, and Stores).

3. Form Creation, Workflow Management & FMS

• Design and deploy Google Forms to capture shop-floor data, inspection reports, raw material receipts, and daily shift output.
• Set up and maintain Flow Management Systems (FMS) to track process pipelines, pending tasks, lead times, and dispatch schedules.
• Trigger automated email/WhatsApp alerts or status notifications using linked Google Apps Script triggers.

4. Daily, Weekly & Monthly Reporting (MIS)

• Prepare Daily Production Reports (DPR), Inventory Valuation Reports, and Reorder Level (ROL) trackers.
• Monitor Accounts Receivable/Payable aging reports and maintain cash flow monitoring spreadsheets.
• Generate variance analysis reports comparing budgeted metrics against actual shop-floor performance.

Candidate Requirements & Qualifications

• Experience: 1 to 2 years of hands-on experience as an MIS Executive or Data Analyst, preferably in a manufacturing unit.

• Proximity Constraint: Must reside within a 45-minute commute radius of the factory location.

• Technical Skills:

• Spreadsheets: Advanced Excel (Pivot Tables, Power Query, Macros/VBA) & Google Sheets (QUERY, IMPORTRANGE, Apps Script).

• Accounting System: Working knowledge of extracting/exporting reports and raw data from Tally.

• AI & Modern Tools: Familiarity with AI tools for formula creation, script writing, and process automation.

• Process Tools: Proficiency in Google Forms, Google Drive structure, and FMS methodology.

• Educational Background: Bachelors degree in Commerce (B.Com), Business Administration (BBA), Statistics, Computer Applications (BCA), or related field.

• Soft Skills: Strong logical reasoning, numerical accuracy, and effective cross-departmental communication skills.