MIS Executive Advanced Excel

Minivel Services; Bengaluru; On-site; INR 450,000 - 550,000; Full time

Job summary

Minivel Services in Bangalore is seeking an analytical MIS Executive to manage business reporting, data validation, dashboards, and performance analytics. You will collaborate with Sales, Marketing, Finance, and Management to deliver accurate reports and actionable insights.

The ideal candidate has 2–5 years of MIS/Reporting experience with advanced Excel skills (XLOOKUP, INDEX-MATCH, SUMIFS) and experience in CRM reporting and Power Query. Real estate industry experience is mandatory.

Qualifications

• 2–5 years of MIS/Reporting experience.
• Real estate experience is mandatory.
• Strong Advanced Excel skills required.

Responsibilities

• Prepare MIS reports for management.
• Validate data across CRM, sales, and finance.
• Create and maintain Excel dashboards.
• Analyze sales, marketing, revenue performance.
• Automate reporting with Excel and Power Query.

Skills

Advanced Excel

XLOOKUP

INDEX-MATCH

SUMIFS

COUNTIFS

Pivot Tables

Pivot Charts

Power Query

Dashboard Creation

Data Cleaning

Data Validation

Education

Graduate

Tools

Power BI

CRM Reporting

Job description

MIS Executive Advanced Excel

Location: Bangalore
Department: Strategy / MIS
CTC: Up to 5 LPA
Experience: 1-3 Years
Industry: Real Estate Mandatory

About the Role

We are looking for an analytical and detail-oriented MIS Executive to manage business reporting, data validation, dashboards, and performance analytics.

The role will involve working closely with Sales, Marketing, Finance, and Management teams to ensure accurate reporting and provide actionable business insights.

Key Responsibilities

• Prepare accurate and timely MIS reports for management.
• Maintain and validate data across CRM, sales, and finance systems.
• Identify duplicate records, discrepancies, and data gaps.
• Analyse sales, marketing, pipeline, conversion, and revenue performance.
• Create and maintain Excel-based dashboards and performance reports.
• Automate repetitive reporting processes using Excel and Power Query.
• Generate actionable insights and highlight performance trends.
• Support management with data-driven reports and analysis.

Required Skills

Advanced MS Excel – Mandatory

• XLOOKUP
• INDEX-MATCH
• SUMIFS / COUNTIFS
• IF / IFS
• Pivot Tables & Pivot Charts
• Power Query
• Dashboard Creation
• Data Cleaning & Validation

Good to Have

Basic VBA / Macros | CRM Reporting | Power BI | Sales MIS / Business Analytics

Candidate Profile

• Graduate in any discipline.
• 2–5 years of relevant MIS/Reporting experience.
• Real Estate industry experience is mandatory.
• Strong hands-on experience in Advanced Excel.
• Experience with Sales MIS, CRM, sales funnel, revenue, or performance reporting preferred.
• Strong analytical, problem-solving, and communication skills.
• Ability to work with large datasets and multiple reporting requirements.

Key Skills

MIS | Real Estate | Advanced Excel | Power Query | Pivot Tables | XLOOKUP | INDEX MATCH | SUMIFS | COUNTIFS | Dashboard | Data Analysis | Reporting | Sales MIS

Interested Candidates

Parisha Agrahari
HR Executive – Talent Acquisition
[e-mail]