MIS Executive

Western Electrical Unit No 2; Bhopal; On-site; INR 350,000 - 550,000; Full time

Job summary

Western Electrical Unit No 2 is seeking an MIS Executive to perform data integration, profitability analysis, and automated reporting in a manufacturing setting. The role emphasizes Advanced Excel, Google Sheets, and AI-driven automation to streamline cross-department processes.

The candidate will design data capture forms, implement FMS workflows, and maintain monthly financial dashboards and variance analyses to support management decisions.

Qualifications

• 1–2 years of MIS Executive/Data Analyst experience in manufacturing.
• Proficient in Advanced Excel, Google Sheets, AI tools, and data automation.
• Experience integrating Tally data into spreadsheets for financial, production and profitability calculations.
• Must reside within a 45-minute commute of the factory.

Responsibilities

• Import, clean, and consolidate financial/transactional data from Tally Prime/ERP into Excel and Google Sheets.
• Compute product/batch-wise profit margins, contribution margins, and cost variances.
• Analyze material consumption to track yield and wastage (copper, core, transformer oil, steel).
• Maintain monthly P&L trackers, cost-sheet analyses, and overhead distribution reports.
• Build dynamic dashboards using complex formulas and automate workflows with Google Apps Script/Excel VBA/AI tools.
• Standardize reporting formats across Sales, Procurement, Production, Quality, Stores.
• Design Google Forms to capture shop-floor data and set up FMS to track pipelines and lead times.
• Trigger automated alerts via email/WhatsApp using Apps Script.

Skills

Advanced Excel

Google Sheets

AI tools

Data automation

Tally data integration

FMS knowledge

Google Forms

Automation triggers

Education

B.Com

BBA

Statistics

BCA

Tools

Tally Prime / ERP

Google Apps Script

Excel VBA/Macros

Google Sheets QUERY

FMS

Power Automate

Job description

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.