Finance reconciliation - Team Lead

One97 Communications Limited; Dadri; On-site; INR 400,000 - 800,000; Full time

Job summary

An established industry player is looking for a detail-oriented Finance Reconciliation Analyst with a strong analytical mindset. This role involves end-to-end reconciliation of travel bookings and settlements, ensuring accuracy across various systems. You will leverage your SQL skills to handle large datasets and collaborate with multiple teams to drive process improvements. If you have a solid background in finance operations and a passion for the travel industry, this is an exciting opportunity to make a significant impact in a dynamic environment.

Qualifications

• 3-6 years of experience in Finance Reconciliation roles, preferably in travel.
• Proficiency in SQL and financial reporting tools.

Responsibilities

• Perform end-to-end reconciliation of bookings, invoices, and settlements.
• Analyze mismatches in transactions to ensure data integrity.

Skills

SQL

Finance Reconciliation

Analytical Skills

Problem-solving

Excel

Root Cause Analysis

Tools

SAP

GDS (e.g., Amadeus, Galileo)

LCC (e.g., Indigo, Air India Express, SpiceJet)

Job description

About the Role: We are seeking a detail-oriented and analytically strong Finance Reconciliation Analyst with experience in the travel domain, specifically working with GDS and LCC vendors. The ideal candidate will have a solid background in finance operations, a deep understanding of travel booking and settlement processes, and strong hands-on skills in SQL for handling large transactional data sets.

Key Responsibilities:

1. Perform end-to-end reconciliation of bookings, invoices, and settlements related to GDS (e.g., Amadeus, Galileo) and LCC (e.g., Indigo, Air India Express, SpiceJet) vendors.
2. Analyze mismatches in transactions across booking, payment, and accounting systems to ensure data integrity and accuracy.
3. Build and run SQL queries to extract, match, and validate large volumes of transactional data.
4. Investigate open items and variances, and drive timely resolution by coordinating with internal teams (Tech, Ops, Finance) and external vendors.
5. Prepare reconciliation dashboards and reports for internal reviews and audits.
6. Work closely with Tech/Product teams for process automation and identifying leakage risks.
7. Participate in monthly/quarterly closure activities and support audit/compliance requirements.
8. Document SOPs, RCA reports, and reconciliation logs in a structured and auditable manner.
9. Leverage Python for data analysis and automation tasks, if applicable.

Requirements:

• 3–6 years of experience in Finance Reconciliation roles, preferably in the travel / OTA / fintech industry.
• Proficiency in SQL – ability to write optimized queries for large, complex data sets.
• Strong knowledge of GDS and LCC settlement workflows, fare rules, and cancellation/refund processes.
• Hands-on experience in Excel, Pivot Tables, and financial reporting tools.
• Strong analytical and problem-solving skills with an eye for detail.
• Experience in root cause analysis (RCA) and identifying leakages in reconciliation processes.
• Exposure to accounting principles and financial systems (SAP preferred).
• Background in working with payment gateways, wallets, or UPI transactions in travel.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Finance and Sales

Industries

• Technology, Information and Internet