Reconciliation Specialist
Paytm
Noida, Uttar Pradesh, IndiaPosted 1 month ago
Skill Required
FinanceEngineeringanalyticalfintechPythonPandasdesignNumPyAPIsSQL
Key highlights
- 3–6 years of relevant experience required
- Bachelor’s degree in a quantitative field required
- Advanced SQL proficiency required
- Python scripting and automation expertise required
- Advanced Excel skills required
- Deep knowledge of payment ecosystem (MDR, chargebacks, settlements) required
Role overview
We are seeking a highly analytical and data-driven Payment Reconciliation Specialist / Analyst to oversee our end-to-end financial reconciliation processes. In this role, you will manage high-volume transaction datasets, track payment lifecycles, and ensure absolute financial accuracy across internal systems, payment gateways, and banking partners, while bridging finance and technology with strong accounting fundamentals and advanced SQL and Python skills.
Responsibilities
- Core Payment & Financial Reconciliation – Validate transaction records across internal systems, payment gateways, banking partners, settlement files, and merchant reports.
- Core Payment & Financial Reconciliation – Analyze massive transaction datasets to promptly identify mismatches, pending settlements, duplicate transactions, and financial exceptions.
- Core Payment & Financial Reconciliation – Monitor disputed transactions, track the complete chargeback lifecycle, validate reversal entries, and ensure accurate accounting adjustments/recovery.
- Core Payment & Financial Reconciliation – Validate transaction postings, track pending receivables, manage refund accounting, handle merchant payout reconciliation, and assist with balance sheet reconciliation.
- Cost Optimization & Reporting – Monitor and analyze Payment Gateway costs (MDR charges, transaction processing fees, bank charges, gateway settlement fees) to identify cost‑optimization opportunities.
- Cost Optimization & Reporting – Prepare daily, weekly, and monthly MIS reports and design reconciliation dashboards for leadership, finance, and operations teams to support audit readiness.
- Data Engineering & Process Automation – Write complex SQL queries for reconciliation checks, exception reporting, and data validation across large transactional databases.
- Data Engineering & Process Automation – Utilize Python for data processing, large‑scale data analysis, report generation, and data cleansing to significantly reduce manual operational effort.
- Data Engineering & Process Automation – Lead automation initiatives to improve reconciliation turnaround times, strengthen internal financial controls, and minimize operational risk.
- Stakeholder & Compliance Management – Partner with banks, payment gateways, and internal cross‑functional teams to resolve operational issues and improve overall payment efficiency.
- Stakeholder & Compliance Management – Ensure strict adherence to internal financial controls, accounting standards, audit requirements, and operational risk management policies.
Requirements
- Bachelor’s degree in Finance, Accounting, Commerce, Data Analytics, Computer Science, or a related quantitative field.
- 3–6 years of experience in payment reconciliation, fintech operations, payment gateway systems, or financial data analysis.
- Advanced SQL: Proven ability to query, join, and analyze complex relational databases.
- Python: Proficiency in writing scripts for data cleansing, manipulation (e.g., Pandas, NumPy), and process automation.
- Excel: Advanced knowledge of pivot tables, VLOOKUPs/XLOOKUPs, and complex formulas.
- Domain Knowledge: Deep understanding of the payment ecosystem (MDR, settlement cycles, chargebacks, merchant payouts, and banking APIs).
- Analytical Mindset: Exceptional problem‑solving skills with an eagle‑eye attention to detail.