We are looking for a Senior DME who can handle a team and take ownership of MIS, automation and internal business systems.

The candidate should have strong practical knowledge of Advanced Google Sheets, Google Apps Script, FMS, PMS, Stock, Debtors, Sales MIS and business process automation.

Along with MIS and automation knowledge, the candidate should have good understanding of HTML, CSS and JavaScript and should be capable of understanding and designing basic internal web-based systems.

React knowledge will be an added advantage.

Key Responsibilities:

* Team Handling

* Handle and guide the DME/MIS team.

* Allocate work and monitor daily activities.

* Review the work and reports prepared by team members.

* Ensure accuracy and timely completion of MIS.

* Train junior team members on formulas, Google Sheets and Apps Script.

* Solve complex technical and reporting issues faced by the team.

* Set working standards and processes for the team.

* Monitor team performance and deliverables.

* Coordinate with different departments for data and system requirements.

* MIS & Advanced Google Sheets

* Handle advanced business MIS and reporting requirements.

* Develop complex Google Sheets solutions using advanced formulas.

* Advanced VLOOKUP / XLOOKUP.

* INDEX + MATCH and multi-condition lookup.

* Advanced QUERY and customised QUERY.

* QUERY with multiple conditions, GROUP BY, PIVOT, ORDER BY, LABEL etc.

* ARRAYFORMULA and advanced array-based calculations.

* FILTER, SORT, UNIQUE and energetic reporting.

* SUMIFS, COUNTIFS, SUMPRODUCT and complex conditional formulas.

* IF, IFS, IFERROR, IFNA and nested formulas.

* REGEXMATCH, REGEXEXTRACT and REGEXREPLACE.

* SPLIT, TEXTJOIN, FLATTEN and other data transformation functions.

* IMPORTRANGE and integration between multiple Google Sheets.

* Dynamic ranges and automated reporting structures.

* Large-data handling and formula optimisation.

* Create customised formulas based on actual business requirements.

* Google Apps Script & Automation

* Develop and maintain business automation using Google Apps Script.

* Automate daily, weekly and monthly reports.

* Consolidate data from multiple Sheets.

* Automate data processing, validation and reconciliation.

* Develop custom functions, menus, buttons and workflows.

* Automate PDF creation and report distribution.

* Automate email notifications and follow-ups.

* Work with Google Drive and Google Workspace.

* Use triggers and scheduled automation.

* Optimise Apps Script for performance.

* Debug and improve existing scripts.





* Review code developed by junior team members.

* Design reusable automation instead of creating one-time scripts.

* FMS / PMS

* Understand and manage complete FMS/PMS workflows.

* Design step-wise processes and responsibility structures.

* Track pending activities, ageing and TAT.

* Create escalation and follow-up systems.

* Identify bottlenecks in existing processes.

* Improve existing FMS/PMS systems.

* Convert manual processes into automated workflows.

* Prepare management-level FMS/PMS reports.

* Stock / Inventory

* Develop and maintain stock MIS.

* Track opening, inward, outward and closing stock.

* Branch-wise and item-wise stock analysis.

* Stock ageing and slow-moving stock.

* Stock reconciliation and mismatch analysis.

* Stock availability and requirement reports.

* Automate stock-related reporting wherever possible.

* Debtors / Outstanding

* Customer-wise and invoice-wise outstanding MIS.

* Ageing analysis and overdue tracking.

* Collection follow-up reports.

* Customer payment analysis.

* Reconciliation of sales, receipts and outstanding.

* Develop automated debtor and ageing reports.

* Sales & Business MIS

* Daily, weekly and monthly sales MIS.

* Branch-wise, employee-wise, customer-wise and product-wise reports.

* Target vs achievement.

* Sales growth and comparison.

* Pending order and dispatch reports.

* Management dashboards.

* Develop customised MIS as per management requirements.

* HTML / CSS / JavaScript

* Good practical knowledge of HTML, CSS and JavaScript.

* Develop basic internal web applications and business tools.

* Create forms, dashboards, data-entry screens and reporting interfaces.

* Work with APIs and Google Apps Script-based web applications.

* Understand DOM, events, forms and JavaScript logic.

* Create practical and user-friendly internal systems.

* Debug and modify existing frontend applications.

* System Design & Requirement Understanding

* Understand the business requirement before starting development.

* Discuss requirements with management and concerned departments.

* Convert business requirements into system requirements.

* Design modules,



workflows and data flow.

* Decide how data should be collected, processed and reported.

* Design master data and transaction data structures.

* Understand user roles and access requirements.

* Plan automation and system architecture.

* Identify dependencies between different modules.

* Consider performance, data accuracy and scalability while designing systems.

* Identify whether a requirement should be handled through Google Sheets, Apps Script, web application or database.

* Prepare proper process flow before implementation.

* Improve existing systems instead of creating temporary workarounds.

* React – Added Advantage

* React knowledge will be an added advantage.

* Experience in developing dashboards, internal tools or business applications using React will be preferred.

* Knowledge of components, API integration, forms, state management and routing will be an advantage.

Required Skills:

* Team Handling

* Advanced Google Sheets

* Advanced Google Sheets Formulas

* Advanced QUERY

* Advanced VLOOKUP / XLOOKUP

* INDEX + MATCH

* ARRAYFORMULA / Array Functions

* FILTER / SORT / UNIQUE

* SUMIFS / COUNTIFS / SUMPRODUCT

* REGEX Functions

* IMPORTRANGE

* Google Apps Script

* FMS / PMS

* Stock / Inventory MIS

* Debtors / Outstanding / Ageing

* Sales MIS

* HTML

* CSS

* JavaScript

* System Design

* Business Process Understanding

* Requirement Analysis

* Automation

* Problem Solving

* React – Added Advantage

Candidate should be:

* Strong in practical implementation, not only theoretical knowledge.

* Capable of independently handling complex MIS and automation requirements.

* Capable of managing and guiding a team.

* Able to understand business processes and convert them into systems.

* Comfortable interacting with management and different departments.

* Able to analyse an existing process and identify where automation is required.

* Able to design a solution before starting development.

* Capable of troubleshooting complex formulas, scripts and system issues.

* Good in logical thinking and data analysis.

* Responsible for the complete requirement-to-implementation cycle.

Key Expectation:

The person should be able to take a business requirement, understand the complete process, design the solution, guide the team and ensure the final system is implemented properly.

This is a senior ownership role and not limited to preparing MIS reports.

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

Work Location: In person

📌 Sr. Data management Executive (Rajajinagar)
🏢 MARUTI FLEX TRADERS
📍 Rajajinagar