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
2-4 years of hands-on experience in financial analysis, data reconciliation, or payment operations
In-depth knowledge of payment processors, merchant accounts, or fintech industry practices (preferred)
Experience with financial reporting, accounting principles, and variance analysis
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
Analytical skills with a keen eye for detail
Excellent communication skills to explain findings clearly to cross-functional teams
Self-motivated and organized, able to manage multiple reconciliation projects with tight deadlines
Benefits
Generous monthly budget dedicated to expanding your skills and knowledge
Opportunities for career advancement
Work-life balance and flexibility in work hours and location
Supportive and inspiring team environment
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.