Senior Data Analyst

Who you are

• 6+ years of experience working with complex transactional and financial data in fintech or financial services, including areas such as reconciliation, settlement, payment operations, and accounting
• Working knowledge of banking payment rails and card networks, such as ACH, wire transfers, RTP, FedNow, Visa, and Mastercard, with an understanding of transaction flows, clearing, settlement, returns, and exception handling
• Advanced SQL skills and hands-on experience developing and maintaining data transformation pipelines (e.g., dbt or similar)
• Strong analytical skills, with a background 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 using tools such as Omni, Looker, or Tableau
• A 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

What the job involves

• We’re looking for a Senior Financial Data Reconciliation Analyst who will help operationalize, standardize, and scale reconciliation across Mercury’s banking partners and internal systems
• As a senior member of the team, you’ll lead cross-functional initiatives from design through delivery and help other analysts grow. You’ll collaborate with internal and external partners to account for, reconcile, and investigate edge cases in the underlying money movements that power Mercury’s financial products
• 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

Benefits

• Health, dental, & vision
• 12+ weeks of paid parental leave
• $600 USD custom WFH equipment setup
• Unlimited vacation policy (with a mandatory minimum)
• Annual $1K learning & development budget
• Paid 6-week sabbatical after the 5-year mark
• Weekly $100 food budget
• Monthly $100 wellness budget
• Monthly $50 cellphone reimbursement
• Pet-friendly offices with free tea and beverages, plus lunch and snacks
• Unlimited vacation policy (with a mandatory minimum)
• Retirement matching up to 4% of base salary (401K/RRSP)
• Inclusive fertility, hormonal health, and family-forming benefits through Carrot Fertility