MIS Executive

Indovision Services Pvt. Ltd.; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

Indovision Services Pvt. Ltd. is seeking an MIS Executive with 4–5 years of experience to manage MIS reporting, data management, and dashboard preparation.

The role emphasizes advanced MS Excel, data analysis, report automation, and maintaining accurate operational records. The candidate will publish daily, weekly, and monthly MIS reports and contribute to management presentations. The ideal candidate will develop dashboards, handle large data sets, automate processes, and monitor KPIs while

Qualifications

• Advanced Excel capabilities including Pivot Tables and multiple functions.
• PowerPoint for management reports and presentations.
• Power BI dashboard development and data visualization.

Responsibilities

• Prepare daily, weekly, and monthly MIS reports.
• Develop dashboards, trackers, and performance reports.
• Handle large datasets with data consolidation, validation and reconciliation.
• Automate recurring reports using Excel formulas, Power Query and VBA.
• Monitor KPIs, identify data discrepancies and trends.
• Coordinate with departments to collect and consolidate data.
• Ensure data accuracy, confidentiality and timely submission of reports.
• Prepare management presentations and summaries.
• Maintain structured databases and historical reporting records.
• Identify opportunities to improve reporting processes.

Skills

Advanced Excel

Data analysis

Dashboard creation

Report automation

Attention to detail

Education

Graduate degree (B.Com/BBA/B.Sc/BCA)

Tools

Power BI

Power Query

SQL

VBA

Pivot Tables

Job description

Job highlights

• Qualification: Graduate in any stream

Shift

Day

5 days

Immediate

Brief roles and responsibilities are as below :-

We are looking for a detail-oriented MIS Executive with 4–5 years of experience in MIS reporting, data management, dashboard preparation, and business reporting. The candidate should have strong expertise in Advanced MS Excel, data analysis, report automation, and maintaining accurate operational records.

Prepare, maintain, and publish daily, weekly, and monthly MIS reports for management and business operations.

Develop and maintain dashboards, trackers, and performance reports using MS Excel.

Handle large datasets, perform data consolidation, validation, reconciliation, and analysis.

Automate recurring reports using Excel formulas, Power Query, and VBA/Macros wherever applicable.

Monitor key performance indicators (KPIs), identify data discrepancies, and highlight operational trends.

Coordinate with internal departments to collect, verify, and consolidate data within defined timelines.

Ensure data accuracy, consistency, confidentiality, and timely submission of reports.

Prepare management presentations and summary reports highlighting business performance and exceptions.

Maintain structured databases, master data, and historical reporting records.

Identify opportunities to improve reporting processes, reduce manual effort, and enhance reporting efficiency.

Educational Qualification

Graduate in B.Com, BBA, B.Sc, BCA, or any relevant discipline.

Required Experience

4–5 years of relevant experience in MIS reporting, data analysis, business reporting, or operations reporting.

Tools & Technical Skills

Mandatory

• Advanced MS Excel – Pivot Tables, VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, Conditional Formatting, and dashboard creation.
• MS PowerPoint – Preparation of management reports, presentations, and business performance summaries.

Preferred

• Power BI – Dashboard development, data visualization, KPI monitoring, and basic DAX.
• Power Query – Data cleaning, transformation, consolidation, and reporting automation.
• SQL – Basic to intermediate knowledge of queries, data extraction, filtering, and joins.

Good to Have

• VBA / Macros – Automation of repetitive reports and Excel-based processes.
• Strong analytical and numerical skills.
• Excellent attention to detail and data accuracy.
• Good communication and coordination skills.
• Ability to manage multiple reporting requirements and meet deadlines.
• Strong problem-solving and process improvement mindset.