← All roles

Senior Data Analyst - Reconciliation

Mercury· Finance
Apply on company site
Hybrid (Remote within Canada or United States; San Francisco, CA; New York, NY; Portland, OR)Full-timePosted 1mo ago

About the role

Senior Financial Data Reconciliation Analyst responsible for designing, implementing, and scaling end-to-end reconciliations across Mercury’s banking partners and internal systems. Leads cross-functional initiatives, mentors analysts, and partners with Product, Engineering, Finance, and Banking to ensure accurate transaction matching, exception handling, and reconciliation health.

Responsibilities

  • Own the design and implementation of end-to-end reconciliations for new and existing products and funds flows, setting standards that other analysts can build against
  • Develop and maintain data transformations, enrichment logic, and matching rules that support accurate and scalable reconciliation across internal and external systems
  • Monitor and investigate reconciliation exceptions, leading root-cause analysis and coordinating with Product, Engineering, Finance, and banking partners to resolve complex breaks and implement durable fixes
  • Build monitoring, alerting, and reporting that surface reconciliation risks, trends, and improvement opportunities across the team’s portfolio
  • Define reconciliation requirements and technical specifications for new products and funds flows, partnering with Product, Engineering, Data, and Finance early in the design process
  • Partner with Accounting to support month-end close and audit readiness by preparing timely reconciliation analyses, summaries, and supporting documentation
  • Shape and execute the reconciliation control roadmap, leading cross-functional initiatives and representing the Reconciliation team’s perspective as product coverage and operational complexity grow
  • Mentor other analysts through hands-on coaching, helping them strengthen their technical and investigative skills

Qualifications

  • 6+ years of experience working with complex transactional and financial data in fintech or financial services, including reconciliation, settlement, payment operations, and accounting
  • Working knowledge of banking payment rails and card networks (e.g., ACH, wire transfers, RTP, FedNow, Visa, Mastercard) with understanding of transaction flows, clearing, settlement, returns, and exception handling
  • Advanced SQL skills and experience developing and maintaining data transformation pipelines (e.g., dbt or similar)
  • Strong analytical skills with background in investigating and resolving complex financial data discrepancies
  • Familiarity with enterprise reconciliation or matching tools (e.g., Blackline) or similar platforms
  • Experience building monitoring or BI dashboards to communicate operational and financial metrics (e.g., Omni, Looker, Tableau)
  • Track record of leading cross-functional initiatives and driving alignment across technical and non-technical partners
  • Experience mentoring or developing other analysts and a genuine interest in helping others grow
  • Experience supporting audits, regulatory reporting, or financial-control testing

Skills

Required:SQLData transformation pipelinesTransaction data reconciliation

Benefits

  • Base salary, equity (stock options/RSUs), and benefits
  • Total rewards package reflecting compensation and benefits
  • Competitive salary ranges aligned with geographic location and experience
Last updated Oct 7, 2026. Interested? Apply on the company site.
Mercury logo

About Mercury

Online Business Banking For Startups & Small Businesses | Financial Workflows

Powerful banking. Simplified finances. Apply in 10 minutes for business banking that transforms how you operate.

bankingfinancial workflowsbusiness bankingmobile bankingcorporate cardscredit cardsdeposit insurancetreasury
Company profileWebsite

More open roles at Mercury