Conduct detailed transaction analysis by comparing Looker data with bank statements from merchants/PSPs
Detect and resolve discrepancies between sales systems, payment processor statements, and accounting records
Categorize and map transactions including sales, refunds, chargebacks, and fees
Investigate timing differences and settlement patterns to improve process accuracy
Develop and document standardized reconciliation procedures and mapping protocols for varying PSP statement formats
Work closely with the accounting team to align data categorization and improve data quality
Regularly generate variance analysis reports and document root causes of discrepancies with clear resolution methods.
Requirements
Have 2-4 years of hands-on experience in financial analysis, data reconciliation, or payment operations
Possess in-depth knowledge of payment processors, merchant accounts, or fintech industry practices (preferred)
Have experience with financial reporting, accounting principles, and variance analysis
Be highly proficient in Excel/Google Sheets (pivot tables, VLOOKUP, complex formulas) and familiar with business intelligence tools like Looker (strongly preferred)
Optional but beneficial: SQL querying skills for data extraction from databases
Understand payment processing systems and merchant statement formats
Be analytical with a keen eye for detail, able to identify root causes behind data discrepancies
Demonstrate excellent communication skills to explain findings clearly to cross-functional teams
Be self-motivated, organized, and able to manage multiple reconciliation projects with tight deadlines.
Preferred qualifications: Bachelor’s degree in Finance, Accounting, Business, or related field
Knowledge of industry regulations, chargeback processes, and familiarity with multiple PSP platforms and statement format.
Tech Stack
SQL
Benefits
Enjoy a generous monthly budget dedicated to expanding your skills and knowledge
Embrace flexibility with work-life balance, choosing when and where you work best
Career advancement opportunities with a transparent path for progress