Business Analyst

Everest Fleet; Gurugram District; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Everest Fleet is seeking a detail-oriented Business Analyst in Gurugram to manage end-to-end operational data, validation, and reporting. You will reconcile data across sources, coordinate with cross-functional teams, and drive process improvements to enhance accuracy and efficiency.

The role requires strong MS Excel skills, experience with large datasets, and excellent stakeholder communication. You will contribute to MIS reporting, case follow-ups, and documentation to ensure timely

Qualifications

• Strong proficiency in MS Excel, incl Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, data cleaning.
• Experience handling large datasets and structured reporting.
• Analytical thinking, problem-solving, and root-cause analysis skills.
• Excellent communication and stakeholder management skills.
• Strong attention to detail, ownership, and ability to manage multiple priorities within deadlines.

Responsibilities

• Data Management & Validation: Collect, consolidate, and validate operational data for accuracy and completeness.
• Reconciliation & Analysis: Perform data reconciliation across multiple sources, identify discrepancies, and coordinate with stakeholders for resolution.
• Cross-Functional Coordination: Collaborate with central teams and operations to ensure accurate data flow and timely information sharing.
• Issue Resolution: Analyze data-related issues, identify root causes, and coordinate with teams to minimize impact.
• Reporting & MIS: Prepare and maintain MIS reports, reconciliation trackers, dashboards, and exception reports.
• Case Management & Follow-up: Maintain tracker of discrepancies and unresolved cases, ensuring follow-up until closure within timelines.
• Stakeholder Coordination: Share finalized data and case details with concerned teams for action.
• Process Improvement: Identify recurring errors and inefficiencies, and propose improvements to enhance data quality and efficiency.
• Documentation & Compliance: Maintain records and audit trails for reconciliations and resolutions.

Skills

MS Excel

Data analysis

Reconciliation

Stakeholder management

Communication

Tools

Pivot Tables

VLOOKUP/XLOOKUP

Job description

We are looking for a detail-oriented Business Analyst to manage end-to-end operational data, reconciliation, validation, and reporting activities. The role involves analyzing large datasets, identifying discrepancies, coordinating with cross-functional teams, and ensuring timely resolution of data-related issues. The ideal candidate should possess strong analytical skills, proficiency in MS Excel, and the ability to drive data accuracy and process efficiency.

Role & responsibilities:

• Data Management & Validation: Collect, consolidate, and validate operational data, including financial adjustments, penalties, deductions, and other relevant inputs to ensure data accuracy and completeness.
• Reconciliation & Analysis: Perform data reconciliation across multiple sources, identify discrepancies, investigate mismatches, and coordinate with relevant stakeholders for resolution.
• Cross-Functional Coordination: Collaborate with central teams and operations stakeholders to ensure accurate data flow, timely information sharing, and smooth execution of business processes.
• Issue Resolution: Analyze data-related issues, identify root causes, and coordinate with relevant teams to minimize operational impact.
• Reporting & MIS: Prepare and maintain MIS reports, reconciliation trackers, dashboards, and exception reports to monitor data accuracy, pending issues, and process performance.
• Case Management & Follow-up: Maintain a tracker of critical discrepancies and unresolved cases, ensuring consistent follow-up until closure within defined timelines.
• Stakeholder Coordination: Share finalized data and relevant case details with concerned teams, including recovery and field support teams, for further action.
• Process Improvement: Identify recurring errors, process gaps, and inefficiencies, and recommend improvements to enhance data quality, reporting accuracy, and operational efficiency.
• Documentation & Compliance: Maintain accurate records, supporting documents, and audit trails for reconciliations, adjustments, and issue resolutions.

Preferred candidate profile

• Strong proficiency in MS Excel, including Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, data cleaning, and reconciliation.
• Experience in handling large datasets and preparing structured reports.
• Strong analytical thinking, problem-solving, and root-cause analysis skills.
• Excellent communication and stakeholder management skills.
• Strong attention to detail, ownership, and ability to manage multiple priorities within deadlines.