MIS Executive - Sector 28 ( Gurgoan )

Capital Placement; Gurugram District; On-site; INR 150,000 - 350,000; Full time

Job summary

Capital Placement in Gurgaon seeks an MIS Executive to manage and analyze large ERP data files. You will prepare MIS reports, reconcile data, and perform variance analysis using advanced Excel features. The role emphasizes accuracy and timely management reporting.

The ideal candidate has 1–4 years of MIS/ERP data experience and a strong command of Excel, including XLOOKUP, Pivot Tables, and conditional formatting.

Qualifications

• Graduate with 1–4 years of experience in MIS or similar fields.
• Proficient in MS Excel with hands-on data analysis experience.
• Experience handling large ERP/MIS data files and data integrity.

Responsibilities

• Prepare, maintain, consolidate, and analyze daily, weekly, and monthly MIS reports.
• Manage large operational and ERP data files with a focus on accuracy.
• Apply Excel techniques such as XLOOKUP/VLOOKUP, Pivot Tables, and conditional formatting.
• Perform data reconciliation, identify discrepancies, and report variances.
• Create and maintain Excel trackers and dashboards for management.
• Consolidate data from multiple sources for management reporting.

Skills

Microsoft Excel

XLOOKUP/VLOOKUP

Pivot Tables

IF functions

Data reconciliation

Variance analysis

MIS reporting

ERP data management

Education

Graduate in any discipline

Job description

Job openings for Mis Executive in Sector 28 Gurgaon

We are looking for an experienced and detail-oriented MIS Executive with strong proficiency in Microsoft Excel and hands-on experience in managing, analyzing, and maintaining large operational and ERP data files. The candidate will be responsible for preparing MIS reports, data reconciliation, variance analysis, tracking exceptions, and providing accurate operational reports to management.

Key Responsibilities

• Prepare, maintain, consolidate, and analyze daily, weekly, and monthly MIS reports.
• Manage large operational and ERP data files and ensure data accuracy.
• Use XLOOKUP/VLOOKUP, IF functions, Pivot Tables, filters, sorting, conditional formatting, and other advanced Excel tools.
• Perform data reconciliation and identify discrepancies, mismatches, and data errors.
• Conduct variance analysis and prepare exception reports.
• Create and maintain complex Excel trackers and dashboards.
• Consolidate data from multiple sources and prepare management reports.

Required Skills

• Strong to advanced proficiency in Microsoft Excel.
• Hands-on experience with XLOOKUP/VLOOKUP, IF, Pivot Tables, Filters, Sorting, Conditional Formatting, etc.
• Good understanding of data reconciliation and variance analysis.
• Ability to independently create, edit, maintain, and analyze complex Excel reports and trackers.
• Advanced MS Excel VLOOKUP Pivot Tables MIS Reporting Data Reconciliation MIS ERP.

Qualification

Graduate in any discipline.

Experience 1 - 4 Years

Salary 1 Lac 50 Thousand To 3 Lac 50 Thousand P.A.

Industry IT Software - ERP / CRM / EDP / MIS