Finance reconciliation - Team Lead

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, 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. Investigateopen items and variances, and drive timely resolution by coordinating with internal teams (Tech, Ops, Finance) and external vendors.

5. Preparereconciliation 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. Potentially leverage Python for data analysis and automation tasks.

• 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.