Team Lead - Finance Reconciliation

Paytm; Dadri; On-site; INR 6,00,000 - 10,00,000; Full time

Job summary

A leading fintech company in India is seeking a Finance Reconciliation Analyst to handle end-to-end reconciliation of travel bookings and settlements. The ideal candidate will have strong SQL skills, a solid background in financial operations, and experience with GDS and LCC workflows. This role requires analytical thinking and proficiency in handling large datasets, along with a detail-oriented approach to ensuring data accuracy.

Qualifications

• 3–6 years of experience in Finance Reconciliation roles in travel or fintech.
• Ability to write optimized SQL queries for complex data.
• Strong knowledge of GDS and LCC settlement workflows.

Responsibilities

• Perform end-to-end reconciliation of bookings and settlements.
• Build and run SQL queries for large transactional data.
• Prepare reconciliation dashboards and reports.

Skills

SQL proficiency

Analytical skills

Detail-oriented

Excel expertise

Problem-solving

Tools

Financial reporting tools

SAP

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, deep understanding of travel booking and settlement processes, and strong hands‑on skills in SQL for handling large transactional data sets.

Key Responsibilities

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

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.