MIS Executive

Job Type: Full-Time

Location: Dwarka, Delhi

Experience: 1–3 Years

Salary: ₹12,000 – ₹18,000 per month

Job Summary

We are looking for a detail-oriented and analytical MIS Executive to manage business data, prepare daily/weekly/monthly reports, maintain dashboards, and provide accurate information to management.

The ideal candidate should have strong hands-on knowledge of MS Excel and Google Sheets, excellent attention to detail, good analytical skills, and the ability to manage large datasets and identify data discrepancies.

Key Responsibilities

- Prepare and maintain daily, weekly, and monthly MIS reports.
- Collect, organize, validate, and analyze data from different departments.
- Maintain and update MS Excel and Google Sheets reports, trackers, and databases.
- Create and maintain dashboards, performance reports, and management trackers.
- Use advanced Excel formulas and functions for data analysis and reporting.
- Prepare Pivot Tables, charts, summaries, and analytical reports.
- Monitor data accuracy and identify errors, discrepancies, and inconsistencies.
- Coordinate with different departments for data collection, verification, and consolidation.
- Track team performance, targets, achievements, and key business KPIs.
- Provide accurate and timely reports and data insights to management.
- Maintain proper documentation of reports, trackers, and databases.
- Automate repetitive reporting tasks wherever possible.
- Improve existing MIS formats, dashboards, and reporting processes.
- Ensure all reports are prepared and shared within defined deadlines.
- Prepare ad-hoc reports and perform data analysis as required by management.

Required Skills
- 1–3 years of experience in MIS, Reporting, Data Management, or Data Analysis.
- Strong hands-on knowledge of MS Excel and Google Sheets.
- Good knowledge of:
- VLOOKUP / XLOOKUP
- INDEX-MATCH
- IF / IFS formulas
- SUMIF / SUMIFS
- COUNTIF / COUNTIFS
- Pivot Tables
- Charts and Graphs
- Data Validation
- Conditional Formatting
- Robust data analysis and problem-solving skills.




- Good understanding of MIS reporting and dashboard creation.
- Excellent attention to detail and data accuracy.
- Ability to handle and analyze large volumes of data.
- Good communication and coordination skills.
- Strong time-management and organizational skills.
- Ability to work independently and meet strict reporting deadlines.

Preferred Skills
- Knowledge of Power BI or other data visualization tools.
- Basic knowledge of reporting automation.
- Knowledge of Google Sheets automation is an advantage.
- Basic knowledge of Power Query is a plus.
- Understanding of business KPIs and performance reporting.
- Experience creating management dashboards and automated reports.

Key Performance Areas
- Accuracy and timely submission of MIS reports.
- Maintaining high data quality and minimizing reporting errors.
- Timely updating of dashboards, trackers, and databases.
- Efficient handling and analysis of business data.
- Timely identification and resolution of data discrepancies.
- Improvement in reporting processes and efficiency.
- Providing reliable data and insights to support management decisions.

Ideal Candidate The ideal candidate should be detail-oriented, analytical, organized, and comfortable working with large datasets. The candidate should have strong Excel skills, be capable of preparing reports independently, and have the ability to identify data errors and convert raw data into clear and useful reports for management.

What We Offer

- Practical exposure to MIS reporting and business analytics.
- Opportunity to work with real-time business data.
- Hands-on experience with Excel, Google Sheets, dashboards, and reporting.
- Opportunity to enhance advanced Excel and data analysis skills.
- Professional growth and learning opportunities.

Key Skills MIS Executive, MIS Reporting, MIS Analyst, MS Excel, Advanced Excel, Google Sheets, Data Analysis, Data Management, Reporting, Dashboard, Pivot Table, VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, Power Query, Power BI, KPI Reporting, Management Reporting, Data Validation, Excel Reports.

Pay: ₹11,182.26 - ₹17,834.31 per month

Work Location: In person

📌 MIS Executive (Dwarka)
🏢 Pathcore
📍 Dwarka