MIS Executive

Job Description – MIS Executive

Position: MIS Executive
Department: MIS / Operations
Location: Delhi
Experience: 2–4 Years
Salary: ₹25,000–₹35,000 per month, depending on experience and skills
Employment Type: Full-Time

Job Summary

We are looking for a detail-oriented and analytical MIS Executive who can manage daily MIS activities, prepare reports, analyze data, maintain dashboards, and automate reporting processes.

Key Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports.
• Collect, verify, consolidate, and analyze data from different departments.
• Develop and maintain Excel-based reports, dashboards, trackers, and management reports.
• Monitor data accuracy and ensure timely submission of MIS reports.
• Use formulas, Pivot Tables, Power Query, and other advanced Excel functions for data analysis.
• Develop and maintain Google Sheets-based reports and dashboards.
• Read, understand, modify, and troubleshoot Google Apps Script used for report automation.
• Automate repetitive reporting and data-management activities using Google Apps Script.
• Coordinate with different departments for data collection and clarification.
• Identify data discrepancies and ensure timely correction.
• Prepare reports and presentations for management review.
• Maintain proper documentation and data records.
• Support management in data analysis and decision-making through accurate MIS reporting.

Mandatory Skills

The following two skills are mandatory:

• Advanced Excel – Mandatory
• VLOOKUP / XLOOKUP
• INDEX & MATCH
• SUMIFS / COUNTIFS
• IF / Nested IF
• Pivot Tables & Pivot Charts
• Conditional Formatting
• Data Validation
• Power Query
• Excel Dashboards
• Data Cleaning & Analysis
• Google Sheets & Google Apps Script – Mandatory
• Good working knowledge of Google Sheets.
• Ability to read and understand Google Apps Script code.
• Ability to modify existing scripts and troubleshoot basic script-related issues.
• Understanding of spreadsheet automation and data flow.
• Knowledge of automated reports, email triggers, formulas, and data consolidation will be preferred.

Eligibility

• Graduate in any discipline; B.Com/BBA/BCA/IT/Computer-related qualification preferred.
• 2–4 years of relevant MIS/reporting experience.
• Strong analytical and problem-solving skills.
• Good communication and coordination skills.
• High attention to detail and accuracy.

Important Requirement

Advanced Excel and the ability to read/understand Google Apps Script are mandatory. Candidates who do not possess both skills should not be considered for this position.

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

Work Location: In person