Mercury
Senior Data Analyst - Reconciliation
$173K–$235K
San Francisco, CA, New York, NY, Portland, OR, or Remote within Canada or United States +1 · Remote · Senior · Full-time · Posted Sep 9, 2026
- Location
- San Francisco, CA, New York, NY, Portland, OR, or Remote within Canada or United States
Any Office or Remote - Experience
- 6+ years.
About the job
Leads the design and operation of financial reconciliations across Mercury’s banking partners and internal systems, investigating transaction discrepancies and improving controls, reporting, and team practices.
What you'll do
- Design and maintain end-to-end reconciliations, data transformations, enrichment logic, and matching rules.
- Investigate exceptions, lead root-cause analysis, and coordinate durable fixes with internal teams and banking partners.
- Build reconciliation monitoring and reporting, support month-end close and audits, lead cross-functional initiatives, and mentor analysts.
What they ask for
- 6+ years working with complex transactional and financial data in fintech or financial services, including reconciliation, settlement, payment operations, or accounting.
- Working knowledge of banking payment rails and card networks, including transaction flows, clearing, settlement, returns, and exception handling.
- Advanced SQL skills and hands-on experience developing and maintaining data transformation pipelines.
- Strong analytical skills investigating financial data discrepancies; track record leading cross-functional initiatives and mentoring analysts.
Nice to have
- Familiarity with enterprise reconciliation or matching tools such as Blackline, or similar platforms.
- Experience building operational and financial metrics dashboards; experience supporting audits, regulatory reporting, or financial-control testing.
Pay
$192,300 — $235,100 USD (base salary); $173,100 — $211,600 USD (base salary); $181,700 — $222,200 CAD (base salary)
Tools
SQL, dbt, ACH, RTP, FedNow, Visa, Mastercard, Blackline
Model-written summary · the original posting is authoritative