Senior Financial Data Reconciliation Analyst
Core
Lead end-to-end financial data reconciliation across banking partners and internal systems to ensure accurate tracking of transactions and protect customer funds.
Role type
Senior Financial Data Reconciliation Analyst (hands-on IC with leadership)
Builds
Data pipelines, matching rules, monitoring/alerting systems, and reconciliation reports for Mercury's banking products
Domain
Fintech, Banking Operations, Financial Data Reconciliation
Required skills
Complex transactional data analysis, Banking payment rails (ACH, wire, RTP, FedNow, Visa, Mastercard), Advanced SQL, Data transformation pipelines (dbt), Financial discrepancy investigation, Cross-functional leadership, Audit/regulatory reporting support, Mentorship
Preferred skills
Enterprise reconciliation tools (Blackline), BI dashboarding (Omni, Looker, Tableau), Month-end close support
Technologies
SQL, dbt, Blackline, Omni, Looker, Tableau
Responsibilities
Design and implement end-to-end reconciliations for new and existing products; Develop and maintain data transformations and matching rules; Monitor and investigate reconciliation exceptions leading root-cause analysis; Build monitoring, alerting, and reporting to surface risks; Define reconciliation requirements and technical specifications; Partner with Accounting for month-end close and audit readiness; Mentor other analysts
Seniority
Senior, hands-on IC with mentorship responsibilities
