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
Collaborate 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
Proficient in Excel/Google Sheets (pivot tables, VLOOKUP, complex formulas) and familiarity with business intelligence tools like Looker (strongly preferred)
Optional: SQL querying skills for data extraction from databases
Understanding of payment processing systems and merchant statement formats
Analytical skills to identify root causes behind data discrepancies
Excellent communication skills for cross-functional team collaboration
Self-motivated, organized, and able to manage multiple projects with tight deadlines
Bachelor's degree in Finance, Accounting, Business, or related field (preferred).
Tech Stack
SQL
Benefits
Generous monthly budget for skill and knowledge expansion
Work-life balance with flexible work options
Transparent path for career progression and achievement recognition