Job Title: MIS EXECUTIVE (Manufacturing Sector)

Location: Gyaspura Chowk, GT Road

Industry: Manufacturing / Production

Experience: 3+ Years in a Factory/Plant setting

Job Summary

We are seeking an MIS specialist in Google Sheets, Appscripts, Appsheets, etc with a background in the manufacturing industry. You will bridge the gap between the manufacturing company's processes and management by tracking all department processes. You must be a "power user" of Google Sheets, capable of turning complex manufacturing logs into actionable insights.

We need a systems-builder. Your goal is to move our company from manual/fragmented processes to a structured, automated, and scalable system. You will be responsible for creating the frameworks that our entire team will use to input, track, and analyze work.

Core Responsibilities

- System Architecture: Design end-to-end workflows for production, quality control, and supply chain using Google Workspace.
- Standardization: Create the "Single Source of Truth." Ensure all departments (Procurement, Production, Sales) are using linked systems that talk to each other.
- Production Tracking: Maintain real-time reports on daily production output vs. targets (Yield Analysis).
- Inventory & OEE: Track Raw Material (RM) consumption, Work-in-Progress (WIP), and Production Management System (PMS).

Technical Requirements (The "Must-Haves")

- Google Sheets:



Expertise in IMPORTRANGE and QUERY functions to pull data from various department sheets into one Master Management Dashboard.
- Appscripts: Experience in appscripts.
- Automation: Ability to use Macros/VBA or Apps Script to automate the daily shift-end reports or actions.

Advanced Technical Skills Required

- System Logic: Deep understanding of relational data. You must know how to link a Bill of Materials (BOM) to Inventory, and Inventory to Sales Orders without breaking the chain.
- Advanced Google Sheets: Expertise in ARRAYFORMULA, QUERY, IMPORTRANGE, and specifically Google Apps Script to create automation (e.g., auto-sending an email when stock is low).
- UI/UX for Workers: Ability to design "Data Entry Forms" that are so simple a worker on the factory floor cannot mess them up.

Manufacturing Experience Requirements

- Must understand Production Workflows (Input -> Process -> Output).
- Experience in Inventory Logic (FIFO/LIFO) and BOM Management and inventory aging.
- Proven track record of taking a manual process (like paper logs) and turning it into a digital system.

Job Types: Full-time, Permanent

Pay: ₹20,000.00 - ₹30,000.00 per month

Benefits:

- Cell phone reimbursement
- Leave encashment
- Provident Fund

Ability to commute/relocate:

- Giaspura, Ludhiana, Punjab: Reliably commute or planning to relocate before starting work (Required)

Education:

- Bachelor's (Preferred)

Experience:

- IT: 5 years (Required)
- google sheets: 5 years (Required)
- total work: 5 years (Required)

Work Location: In person

📌 MIS Executive- Manufacturing Industry (India)
🏢 ASCO
📍 India