Position overview
We are looking for a technically capable and detail-oriented MIS Executive to manage MIS reporting, data analysis, dashboard development, and reporting automation across departments and branches.
The candidate will be responsible for preparing accurate reports, managing large datasets, maintaining FMS/PMS trackers, developing dashboards, and supporting the automation of repetitive reporting processes.
The ideal candidate should have hands-on knowledge of Advanced Excel, Google Sheets, Google Apps Script, Looker Studio, HTML, JavaScript, and AI tools. The candidate should be able to independently manage reporting requirements, identify data errors, troubleshoot formulas, and provide useful insights to management.
Candidates with experience in MIS reporting, data analytics, business reporting, retail operations, or NBFC operations will be preferred.
Key responsibilities
MIS & Management Reporting
- Prepare and maintain daily, weekly, and monthly MIS reports.
- Collect, consolidate, validate, and analyse data from different departments and branches.
- Develop management reports, KPI dashboards, performance trackers, and reporting formats.
- Monitor operational performance, productivity, business targets, and key performance indicators.
- Ensure all reports are accurate, consistent, and submitted within deadlines.
- Identify data errors, gaps, trends, and reporting discrepancies.
- Provide useful data analysis and performance insights to management.
- Standardise reporting formats to improve accuracy and reduce repetitive work.
Advanced Excel & Google Sheets
- Manage and analyse large datasets using Advanced Excel and Google Sheets.
- Use Pivot Tables, VLOOKUP, XLOOKUP, HLOOKUP, INDEX-MATCH, IF, IFS, IFERROR, SUMIF, SUMIFS, COUNTIF, and COUNTIFS.
- Apply Data Validation, Conditional Formatting, Advanced Filters, charts, and dashboard features.
- Use Google Sheets functions such as QUERY, IMPORTRANGE, FILTER, and ARRAYFORMULA.
- Integrate data from multiple Google Sheets and Google Forms.
- Create and maintain FMS, PMS, checklists, trackers, and reporting templates.
- Identify formula errors, duplicate records, missing data, and inconsistencies.
- Improve spreadsheet performance and reporting accuracy through suitable formulas and structured data management.
Dashboard Development & Data Management
- Create and maintain dashboards using Excel, Google Sheets, and Looker Studio.
- Develop performance dashboards and KPI reports for management and different departments.
- Create and maintain web-based reporting tools where required.
- Consolidate data from different departments and branches into centralised reporting systems.
- Ensure data accuracy, validation, consistency, and completeness.
- Identify reporting gaps and implement corrective measures.
- Troubleshoot formula errors, dashboard issues, incorrect data connections, and data-flow problems.
- Ensure dashboards display reliable and updated information.
Automation & Workflow Management
- Automate recurring MIS reports and repetitive data-related tasks.
- Use Google Apps Script to automate Google Sheets reporting and workflow processes.
- Automate data collection, consolidation, and transfer between Google Sheets and Google Forms.
- Support automated email notifications, reminders, and reporting workflows.
- Assist in WhatsApp notification automation using approved Meta Business / WhatsApp Business Platform integrations.
- Develop automated alerts for pending tasks, deadlines, approvals, and reporting requirements.
- Troubleshoot scripts, triggers, formula errors, permissions, and data-flow issues.
- Identify manual processes and recommend practical automation solutions.
- Maintain documentation of formulas, scripts, workflows, and reporting systems.
HTML, JavaScript & Web Apps
- Use basic HTML and JavaScript to support web-based reporting tools and internal business applications.
- Assist in developing and maintaining simple web apps for internal reporting and workflow management.
- Support integration of reporting systems with different data sources and business tools.
- Apply basic troubleshooting techniques to identify issues in web apps, scripts, and data connections.
- Understand basic API integration concepts and assist with integrations where required.
- Coordinate with relevant technical teams or developers for advanced technical requirements.
AI Integration & Process Improvement
- Use AI tools such as ChatGPT and other approved AI solutions for data analysis, formula development, reporting, and process improvement.
- Support AI-assisted automation for reporting, communication, and workflow management.
- Identify opportunities to reduce manual work and improve reporting efficiency.
- Use AI tools to assist with troubleshooting formulas, scripts, and data-related problems.
- Validate AI-generated formulas, code, and analytical outputs before implementation.
- Recommend improvements to existing MIS processes and reporting systems.
- Ensure confidential company information is handled only through approved tools and authorised processes.
FMS, PMS & KPI Monitoring
- Create and maintain FMS, PMS, checklists, trackers, and workflow monitoring systems.
- Track departmental activities, business performance, pending tasks, and completion status.
- Develop reporting formats that improve accountability and visibility of assigned activities.
- Monitor KPIs and identify deviations from expected performance.
- Follow up with concerned departments for missing data and pending updates.
- Maintain accurate records of task status, reporting deadlines, and outstanding requirements.
- Recommend improvements to existing tracking and monitoring systems.
Coordination & Documentation
- Coordinate with HODs, branch teams, and different departments for data collection and validation.
- Understand reporting requirements and prepare reports according to business needs.
- Follow up with departments to ensure timely submission of accurate information.
- Maintain documentation of MIS processes, formulas, dashboards, scripts, and automation workflows.
- Provide reporting support and troubleshoot routine MIS-related issues.
- Maintain proper records of data sources, report formats, and reporting logic.
- Perform other MIS, analytics, and automation-related responsibilities assigned by the reporting manager.
Job requirements
- Minimum 2 years of relevant experience in MIS, Data Analysis, Reporting, or Automation.
- Bachelor's degree in a relevant field.
- Strong hands-on knowledge of Advanced Excel and Google Sheets.
- Practical experience with Pivot Tables, lookup functions, conditional formulas, and advanced reporting.
- Knowledge of QUERY, IMPORTRANGE, FILTER, ARRAYFORMULA, and other Google Sheets functions.
- Good knowledge of Google Apps Script; practical automation experience is preferred.
- Good knowledge of Looker Studio / Google Data Studio and dashboard development.
- Good working knowledge of HTML and JavaScript.
- Basic understanding of API integration will be an advantage.
- Experience in MIS reporting, FMS/PMS, data validation, and dashboard creation.
- Knowledge of AI tools and process automation.
- Ability to independently manage large datasets and reporting requirements.
- Strong analytical, problem-solving, and troubleshooting skills.
- Good verbal and written communication skills.
- Strong coordination skills and attention to detail.
- Ability to manage multiple reports and meet deadlines.
- Experience handling multiple branches or departments will be preferred.
- Comfortable working six days a week, 10 AM to 7 PM, WFO at Gurgaon.
Educational qualification
- Bachelor's degree in Business Administration, Commerce, Computer Applications, Information Technology, Data Analytics, or another relevant discipline preferred.
- Relevant training or certification in Excel, Data Analytics, Business Intelligence, Google Sheets, or Automation will be an advantage.
Ideal candidate
The ideal candidate should be a detail-oriented, analytical, and technically capable MIS professional who can independently prepare accurate reports, manage large datasets, create dashboards, troubleshoot data issues, and automate recurring reporting processes.
The candidate should be comfortable using advanced Excel formulas, Google Sheets functions, reporting tools, and automation scripts to improve data accuracy and reporting efficiency.
Candidates with practical experience in Google Apps Script, Looker Studio, HTML, JavaScript, AI-assisted reporting, and multi-department reporting systems will be preferred.