Reconciliation & Reporting Analyst

RPMGlobal; United States; Remote; USD 110,000 - 125,000; Full time

Job summary

RPMGlobal is seeking a Reconciliation & Reporting Analyst for a remote 12-month contract in the United States. The role focuses on reconciling post-transaction data and building automated SQL-based reporting solutions to ensure accuracy and regulatory compliance.

You will investigate discrepancies, support month-end close, and collaborate with Engineering, Accounting, Treasury, and Compliance to drive improvements in data integrity and operational efficiency.

Qualifications

• 5+ years of related experience in reconciliation, settlement, payment operations, accounting, or finance analytics.
• Bachelor's degree in Finance, Accounting, Economics, a quantitative discipline, or a related field; a Master's degree; or equivalent work experience.

Responsibilities

• Execute time-sensitive daily, weekly, and monthly reconciliations between card networks, banking partners, processors, and internal transaction and ledger data to ensure data integrity across all sources.
• Investigate unreconciled items and discrepancies; perform root-cause analysis across network, bank, and internal data, drive corrective actions, and elevate irregularities promptly.
• Design, develop, and maintain automated SQL-based reconciliation and reporting solutions (e.g., break dashboards, settlement summaries, exception queues) using team best practices, with guidance and review from senior analysts.
• Contribute to the design of the team's success metrics (e.g., match rates, break aging, time-to-resolution, reporting SLAs) and communicate KPI results to business partners and leadership.
• Support month-end close by preparing reconciliation reporting, standardized summaries, and supporting documentation that feed downstream accounting, audit, and regulatory processes.
• Monitor daily settlement, funding, and banking activity to detect irregularities and identify upstream data or pipeline issues that impact reconciliation and reporting data sources.

Skills

SQL

Excel

Data analysis

Reconciliation

Financial reporting

Attention to detail

Communication

Education

Bachelor's in Finance/Accounting/Economics/Quantitative

Master's degree

Tools

Looker

Tableau

Job description

Our client, a global financial services and digital payments company, is seeking a Reconciliation & Reporting Analyst.

This position is a remote 12-month contract. You must be in the US, no H1B Visa status. Hourly rate $55.00 + paid holidays through Talent Table. No C2C.

About the role:

• You will join the Recon and Reporting team, which owns our post-transaction systems: the platform responsible for reconciling money, tracing the end-to-end flow of funds, and meeting our tax and regulatory reporting obligations to merchants, customers, and authorities worldwide. Reconciliation and financial reporting are essential to running a payments business, and given our transaction volume, this role has direct, measurable impact on financial accuracy and trust.
• As an Analyst on the team, you will be the person who ensures the numbers tie out. You will reconcile card-network settlement and report files (Visa, Mastercard, and equivalents), along with data from acquirers, processors, and banks, against our internal payment and ledger data. You will investigate and resolve discrepancies down to the last penny, build automated reports and reporting solutions that finance, accounting, and business stakeholders rely on, and turn what you learn from breaks and exceptions into better metrics, controls, and tooling. Our mantra: all funds in the right place, at the right time, for the right purpose.

What you'll do:

• Execute time-sensitive daily, weekly, and monthly reconciliations between card networks, banking partners, processors, and internal transaction and ledger data to ensure data integrity across all sources.
• Investigate unreconciled items and discrepancies; perform root-cause analysis across network, bank, and internal data, drive corrective actions, and elevate irregularities promptly.
• Design, develop, and maintain automated SQL-based reconciliation and reporting solutions (e.g., break dashboards, settlement summaries, exception queues) using team best practices, with guidance and review from senior analysts.
• Contribute to the design of the team's success metrics (e.g., match rates, break aging, time-to-resolution, reporting SLAs) and communicate KPI results to business partners and leadership.
• Support month-end close by preparing reconciliation reporting, standardized summaries, and supporting documentation that feed downstream accounting, audit, and regulatory processes.
• Monitor daily settlement, funding, and banking activity to detect irregularities and identify upstream data or pipeline issues that impact reconciliation and reporting data sources.
• Partner day-to-day with Engineering, Product, Accounting, Treasury, and Compliance teams; file and follow production support tickets, define business requirements for fixes and enhancements, and validate changes before deployment.
• Maintain clear process documentation and runbooks, identify control gaps and manual toil, and propose automation and process improvements.
• Handle reconciliation and reporting requests from internal stakeholders and external partners, communicating clearly with both technical and non-technical audiences.
• Use AI tools to explore ideas, improve speed of delivery, and deepen insights in your analytical work.
• 5+ years of related experience in reconciliation, settlement, payment operations, accounting, or finance analytics, with a Bachelor's degree in Finance, Accounting, Economics, a quantitative discipline, or a related field; a Master's degree; or equivalent work experience.
• Independent proficiency in SQL, including building and maintaining automated SQL-based reporting.
• Strong Excel skills (complex formulas, pivot tables) and comfort working with large, messy transactional datasets.
• Detail-oriented and possessing a \"detective\" mindset; demonstrated ability to research discrepancies, question the correctness and completeness of data, and follow issues through to resolution.
• Working knowledge of general accounting principles and the mechanics of money movement.
• Strong written and verbal communication skills, with the ability to present findings to both analytics peers and non-technical business stakeholders.
• Self-motivated and proactive; able to deliver accurate work on tight, recurring deadlines and proactively communicate progress, learnings, and delays.

Preferred Qualifications:

• Prior experience with card-network reconciliation and settlement (Visa, Mastercard, Amex, Discover), including network settlement, clearing, and report files.
• Familiarity with funds-transfer processes and rails (ACH, wire, SWIFT, RTP/FedNow) and with the payments ecosystem, including merchants, acquirers, issuers, processors, and program banks.
• Experience with reconciliation tools, banking portals, and BI/reporting platforms (e.g., Looker, Tableau).
• Exposure to month-end close, interchange and fee/cost reconciliation, revenue-leakage detection, or regulatory and tax reporting.
• Experience supporting audits, internal controls, or SOX-adjacent processes.
• Curiosity about payments products and a track record of improving or automating operational processes.
• Bachelor's degree (Finance, Accounting, Economics, a quantitative field, or similar); or a Master's degree; or equivalent work experience.