Factory MIS & Workforce Systems Executive

Flowman Metrix Pvt. Ltd.; Bhopal; On-site; INR 800,000 - 1,600,000; Full time

Job summary

Flowman Metrix Pvt. Ltd. in Bhopal seeks a Factory MIS & Workforce Systems Executive to design and implement attendance, roster, OT and payroll input systems using Excel, Power BI, and MIS.

The role emphasizes hands-on system development and scalable workforce reporting across multiple plants. The ideal candidate will drive operational visibility, standardize processes, and partner with HR, Production, Maintenance, and Accounts to deliver accurate data and actionable insights for factory

Qualifications

• 5+ years of hands-on experience in manufacturing MIS and operational reporting.
• Excel-based systems development and system implementation experience.
• Experience building workforce visibility tools and dashboards in a manufacturing setup.

Responsibilities

• Build and manage employee attendance systems.
• Develop and maintain shift roster, leave, and OT tracking systems.
• Prepare payroll input data and monthly operational MIS reports.
• Build Excel-based workforce and factory reporting systems.
• Develop Power BI dashboards and operational visibility reports.
• Standardize attendance and reporting formats across factories.
• Coordinate with HR, Production, Maintenance, and Accounts teams.
• Develop systems to improve operational visibility and workforce control across plants.

Skills

Advanced Excel

Power Query

Pivot Tables

XLOOKUP / INDEX-MATCH

Power BI

MIS & reporting

Analytical thinking

Manufacturing experience

Tools

VBA

Job description

Factory MIS & Workforce Systems Executive

Location: Bhopal

Industry: Manufacturing / Industrial Operations

Experience: Minimum 5 years of relevant experience (Non-Negotiable)

We are in the process of building a structured Factory Operating System across our manufacturing operations using Excel, Power BI, operational MIS, and process-driven reporting systems.

We are looking for highly capable and execution-oriented professionals who are strong in Excel, Power BI, MIS systems, operational reporting, and systems implementation, and who are interested in building scalable workforce and factory operations systems from the ground up.

The initial focus of the role will be attendance, shift roster, OT, leave, payroll input, and workforce visibility systems across multiple manufacturing plants. Over time, the role is expected to evolve into broader factory systems, reporting, and operational automation initiatives.

Key Responsibilities

• Build and manage employee and contractor attendance systems
• Develop and maintain shift roster, leave, and OT tracking systems
• Prepare payroll input data and monthly operational MIS reports
• Build structured Excel-based workforce and factory reporting systems
• Develop Power BI dashboards and operational visibility reports
• Standardize attendance and reporting formats across factories
• Coordinate with factory HR, Production, Maintenance, and Accounts teams
• Develop systems that improve operational visibility, reporting discipline, and workforce control across plants

Required Skills (Mandatory)

• Advanced Excel
• Power Query
• Pivot Tables
• XLOOKUP / INDEX-MATCH
• Power BI
• Strong MIS and operational reporting capability
• Strong analytical and systems-thinking ability
• Hands‑on experience in manufacturing or factory operations environments

Preferred Exposure

• VBA / Macros
• Payroll and attendance coordination
• Contractor manpower handling
• Shift and workforce planning
• Operational dashboard development

Preferred Background

• Manufacturing
• Steel / Pipe Industry
• Industrial Plants
• Recycling / Process Industries

Ideal Candidate

• Practical and process-oriented
• Strong understanding of workforce systems and operational reporting
• Comfortable working closely with plant teams on-site
• Able to independently build systems and operational controls, not just reports
• Strong execution capability and ownership mindset
• Capable of translating factory operational realities into structured MIS and reporting systems

Important Note

This is a high-accountability execution role with clear operational deliverables. The selected candidate will be expected to independently develop, implement, stabilize, and continuously improve workforce and factory MIS systems across operations.

Strong technical and analytical capability is non‑negotiable for this role.

Minimum 5 years of relevant hands‑on experience is mandatory. Candidates without strong exposure to manufacturing MIS, operational reporting, Excel‑based systems, workforce management, and system implementation environments may not be suitable for this position.

This role is outcome‑driven and intended for candidates who are comfortable working in high‑accountability manufacturing environments with clear execution expectations.