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