Absolutely. I would use a clearer title than “DME” so you attract someone who can actually build and automate systems, not just prepare MIS reports.

MIS & Business Automation Executive

Department: IT / MIS / Digital Operations

Experience: 3–5 Years

Location: Delhi NCR

Employment Type: Full-Time

About the Role

We are looking for a MIS & Business Automation Executive who can transform our business processes into structured, automated and easy-to-use digital systems.

The role will involve working closely with Sales, Projects, Procurement, Stores, Production, Accounts, HR and Management to understand business requirements and develop practical solutions using Google Sheets, Google Apps Script, JavaScript and internal web applications.

This is not a conventional MIS reporting role. The candidate must be capable of understanding a business problem, designing the data structure, building the solution, automating the workflow and maintaining the system.

⸻

Key Responsibilities

- MIS & Business Data Management
- Create and maintain structured MIS databases.
- Develop daily, weekly and monthly MIS reports.
- Build management dashboards with real-time or scheduled data.
- Maintain master data, transaction data and reporting structures.
- Implement data validation and controls to improve data accuracy.
- Identify data gaps, inconsistencies and duplication.
- Create automated alerts for pending, overdue and exceptional cases.
- Google Sheets Automation
- Develop advanced Google Sheets-based systems.
- Use formulas, functions, data validation and conditional formatting effectively.
- Build interconnected databases and dashboards.
- Design user-friendly trackers for different departments.
- Automate repetitive reporting and data-entry processes.
- Google Apps Script Development
- Develop automation using Google Apps Script.
- Build custom workflows and internal applications.
- Create automated email, notification and approval systems.
- Develop triggers and scheduled processes.
- Automate Google Sheets, Drive, Gmail and other Google Workspace functions.
- Maintain, troubleshoot and improve existing Apps Script applications.
- Internal Web Applications

Develop simple internal web applications using:

- Google Apps Script
- JavaScript
- HTML
- CSS
- Google Sheets
- Google Drive
- APIs

Applications may include forms, dashboards, approval portals, trackers, data-entry systems and departmental applications.

- Business Process Automation





Work with departments to identify manual processes and convert them into automated workflows.

Examples

Sales → Quotation → Order → Production → Dispatch → Installation → Closure

Purchase → PO → Material Receipt → GRN → Inventory → Vendor Payment

BOM → Raw Material → Production → QC → Finished Goods

Lead → Follow-up → Opportunity → Quotation → Order

Employee → Attendance → Leave → Approval → MIS The candidate should be able to identify where a process is getting stuck and build visibility around the problem.

⸻

Key Systems / Projects The candidate will be involved in developing and maintaining systems such as:

- Order Management System
- Sales MIS & Sales Tracker
- Project Management System
- Inventory / Godown Management System
- Purchase & Procurement Tracker
- BOM & Material Tracking System
- Production Tracking System
- QC Tracking System
- Dispatch & Installation Tracker
- Customer / Lead Management System
- Employee / Attendance System
- Approval Management System
- Vendor Management System
- Management MIS Dashboard
- Automated Reporting System

⸻

Required Technical Skills

Must Have

- Strong Google Sheets knowledge
- Strong Google Apps Script knowledge
- JavaScript fundamentals
- HTML & CSS
- Google Sheets as a database
- Google Apps Script Web Apps
- API integration
- REST API / JSON fundamentals
- Data structures and database concepts
- Spreadsheet automation
- Google Workspace automation

Good to Have

- SQL
- MySQL / PostgreSQL / Supabase
- Looker Studio
- Git / GitHub
- CRM / ERP understanding
- Barcode / QR-code systems
- Webhooks
- Third-party API integrations
- Basic UI/UX understanding

⸻

Candidate Profile The ideal candidate should:

- Have 3–5 years of hands-on experience in MIS, automation, Apps Script or internal application development.
- Have robust analytical and problem-solving skills.
- Understand business processes and operational workflows.
- Be able to convert business requirements into working technology solutions.
- Understand databases, data relationships and data integrity.




- Be comfortable working independently.
- Be able to troubleshoot and maintain existing systems.
- Have an automation mindset.
- Be detail-oriented and organised.
- Be comfortable communicating with non-technical teams.
- Be willing to work closely with management and department heads.

⸻

What We Expect From This Person The candidate should be able to take a requirement such as:

“We don’t know where our orders are getting delayed.”

and convert it into a working system showing:

Order → Project → Current Department → Current Stage → Responsible Person → Due Date → Delay → Reason → Next Action → Escalation with automated dashboards and alerts.

The person should be able to independently follow:

Understand → Analyse → Design → Build → Test → Deploy → Train → Monitor → Improve

⸻

Key Performance Indicators

Performance will be measured on:

- Number of manual processes automated
- Accuracy of MIS data
- Timeliness of reports
- Reduction in manual data entry
- Reduction in operational delays
- Number of successful systems implemented
- System reliability
- User adoption
- Response time for system issues
- Data integrity
- Ability to independently complete projects

⸻

Practical Interview / Selection Process

Candidates should be prepared to demonstrate actual working projects developed using Google Apps Script, Google Sheets or JavaScript.

The candidate may be given a simple business problem and asked to:

- Understand the requirement.
- Design the database structure.
- Define the workflow.
- Build a basic working solution.
- Create an automated dashboard.
- Explain alerts and escalation.
- Explain user permissions and data security.
- Explain how the solution can be maintained and scaled.

Important

Candidates with only Excel/MIS reporting experience and no practical Apps Script or application-development experience should not be considered for this position.

⸻

Ideal Candidate

We are looking for someone who thinks:

“How can I automate this?”

rather than:

“How can I prepare this report manually?”

The right candidate will become an important part of building Luxaddi’s digital operating system, connecting sales, projects, procurement, inventory, production, installation and management MIS into structured and measurable workflows.

Pay: ₹15,000.00 - ₹35,000.00 per month

Benefits

- Cell phone reimbursement

Work Location: In person

📌 Data Management Executive (Ghitorni)
🏢 Imagination Light u0026 Decor
📍 Ghitorni