MIS Coordinator

MIS EXECUTIVELocation: Gurugram

Employment Type: Full-Time | Work from Office

Department: MIS & Operations

Job SummaryWe are looking for a detail-oriented and highly organized MIS Executive to manage business data, prepare regular reports, maintain complex Excel records, and provide data and reporting support to management and internal teams.

The candidate should be proficient in Microsoft Excel, comfortable handling large and complex datasets, and must have practical working knowledge of VLOOKUP, Pivot Tables and commonly used Excel formulas.

Accuracy, attention to detail and timely reporting will be extremely important for this position.

• Key ResponsibilitiesMaintain and update daily business data in Excel.
• Handle large and complex datasets with a high level of accuracy.
• Perform regular data entry, data cleaning and data validation.
• Maintain proper records and ensure information is updated on time.
• Prepare daily, weekly and monthly MIS reports for management.
• Create management summaries using Excel and Pivot Tables.
• Use VLOOKUP and other formulas for data matching and reconciliation.
• Consolidate data received from different teams and sources.
• Identify duplicate, missing, incomplete or incorrect entries.
• Reconcile data and highlight discrepancies to management.
• Maintain status-wise and category-wise reports.
• Track pending and completed cases/tasks through Excel.
• Coordinate with internal teams for collection and verification of required data.
• Prepare reports and information requested by management.
• Maintain organized historical records for future reference.
• Ensure confidentiality and accuracy of company and client data.

Excel Skills RequiredThe candidate must have good practical knowledge of:

• VLOOKUP
• Pivot Tables
• IF Formula
• SUM / SUMIF
• COUNT / COUNTIF
• Sorting & Filtering
• Data Validation
• Conditional Formatting
• Removing Duplicates
• Data Cleaning
• Data Reconciliation
• Creating summary reports
• Formatting and managing large Excel worksheets

Candidate Requirements

• Graduate in any discipline.
• 1–3 years of experience as an MIS Executive, Data Executive, Back Office Executive or similar role preferred.
• Strong practical knowledge of Microsoft Excel.
• Good data-entry speed with high accuracy.
• Comfortable working with large and complex datasets.
• Strong analytical and numerical ability.
• Excellent attention to detail.
• Good communication and coordination skills.
• Ability to manage multiple reports and deadlines simultaneously.
• Responsible and capable of handling confidential business information.

Key Skills

MIS Reporting

Advanced Excel

VLOOKUP

Pivot Table

Data Entry

Data Management

Data Reconciliation

Data Cleaning

Reporting

Microsoft Office

Back Office Operations

Key Performance Parameters

Performance will primarily be evaluated on:

• Accuracy of data entry
• Accuracy of MIS reports
• Timely preparation and submission of reports
• Excel proficiency
• Data reconciliation accuracy
• Ability to identify discrepancies and errors
• Proper maintenance of records
• Turnaround time for assigned reports and tasks

Compensation

Salary:

Competitive and based on experience and Excel proficiency.

Final compensation will depend on the candidate's practical Excel knowledge, data-handling ability, accuracy, experience and overall suitability for the position.

Ideal CandidateWe are looking for someone who is very comfortable working on Excel, good with numbers and highly particular about data accuracy.

The candidate should be able to independently manage complex data, prepare accurate MIS reports and provide timely information to management for day-to-day business decisions.

Strong Excel skills, accuracy and attention to detail are essential for this position.