MIS & Business process Automation - Executive (Gurugram)

MIS & Business process Automation - Executive (Gurugram)

17 Nov
|
Medorah Meditek
|
Gurugram

17 Nov

Medorah Meditek

Gurugram

About the Role

Medorah Meditek is looking for a proactive, analytical, and technically skilled MIS &

Business Process Automation Candidate to develop, implement, and manage data-driven systems across the organisation.

The ideal candidate should have hands-on experience in developing automated MIS reports,

Flow Management Systems (FMS), dashboards, departmental trackers, and workflow automation.

Preference will be given to candidates who have completed the Advanced MIS

Program/Technical workshops by Rahul Jain (Business Coaching India) or have equivalent practical experience implementing similar systems.

The role requires someone who can go beyond data entry and report generation to create structured systems that improve accountability, operational visibility, efficiency, and management decision-making.

Key Responsibilities

1. MIS Development & Management Reporting

 Design and maintain centralised MIS dashboards for Sales, Production, Quality, R&D;, HR, Finance, and other departments.

 Develop automated daily, weekly, and monthly management reports.

 Consolidate data from different departments into structured reporting systems.

 Monitor departmental KPIs, targets versus achievements, and operational performance.

 Identify trends, exceptions, delays, and performance gaps and present actionable insights to management.

1. Flow Management Systems (FMS) & Process Automation

 Design, develop, and implement Flow Management Systems (FMS) for various business processes.  Convert manual workflows into structured, automated tracking systems.

 Develop process flowcharts with defined responsibilities, timelines, dependencies,

and escalation mechanisms.

 Build automated reminders,



task allocation systems, and overdue-task alerts.

 Ensure process visibility from task initiation to completion.

1. Google Sheets & Google Apps Script Automation

 Develop advanced Google Sheets-based systems using formulas, functions, and data validation.  Use Google Apps Script to automate repetitive processes, notifications, reporting, and data consolidation.

 Develop Google Forms integrated with automated trackers and dashboards.

 Create automated approval workflows and escalation systems.

 Integrate multiple Google Workspace applications where required.

1. Dashboard Development & Data Analytics

 Develop interactive dashboards using Google Looker Studio, Power BI, or equivalent tools.  Analyse sales performance, inventory movement, production efficiency, complaint closure, employee performance, and other operational parameters.

 Create management dashboards with drill-down capabilities.

 Ensure dashboards provide accurate, updated, and actionable information.

 Highlight exceptions and deviations requiring management attention.

1. Departmental Tracking & Accountability Systems

 Develop and maintain delegation trackers, task monitoring systems, and departmental checklists.  Establish explicit task ownership, deadlines, and status tracking.





 Implement mechanisms to identify pending activities and delayed closures.

 Coordinate with departmental heads to ensure timely data submission and updates.

 Support the implementation of KPI-based performance monitoring and accountability systems.

1. Data Accuracy & System Improvement

 Ensure data integrity, accuracy, and consistency across reporting systems.  Establish standardised formats and reporting protocols.

 Identify gaps in existing processes and recommend automation opportunities.

 Maintain documentation for developed systems, workflows, and automation scripts.

 Train departmental users on newly implemented systems.

 Continuously improve existing dashboards and automation processes.

Required Technical Skills

Essential:

 Advanced Microsoft Excel and Google Sheets

 Google Apps Script

 Google Forms and Google Workspace

 FMS development and workflow automation

 Advanced formulas, pivot tables, QUERY, FILTER, and data validation

 Dashboard development using Looker Studio or Power BI

 Process flowchart development

 Automated trackers, reminders, and escalation systems

 Data cleaning, consolidation, and analysis

Preferred:

 Completion of Rahul Jain's Advanced MIS Program

 Experience implementing FMS and automated checklists

 Experience with Google Workspace integrations and APIs

 Knowledge of SQL, Power Query, or additional automation tools

 Experience working with manufacturing organisations

 Familiarity with ERP systems and business process improvement

Pay: ₹11,000.00 - ₹60,000.00 per month

Work Location: In person

📌 MIS & Business process Automation - Executive (Gurugram)
🏢 Medorah Meditek
📍 Gurugram

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: mis & business process automation - executive (gurugram) / gurugram

Subscribe to this job alert:

Get the latest job offers by email for: mis & business process automation - executive (gurugram) / gurugram