Reconciliation & Reporting Analyst

Reconciliation & Reporting Analyst

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, Client, 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 the automated reporting 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 escalate 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: prepare 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 spot upstream data or pipeline issues that impact reconciliation and reporting data sources.
• Partner day-to-day with Engineering, Product, Accounting, Treasury, and Compliance: 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.

Minimum Requirements:

• 5+ years of related experience in reconciliation, settlement, payment operations, accounting, or finance analytics with a Bachelor's degree (Finance, Accounting, Economics, a quantitative field, or similar); or 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 "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; delivers accurate work on tight, recurring deadlines and proactively communicates progress, learnings, and delays.

Preferred Qualifications:

• Prior experience with card-network reconciliation and settlement (Visa, Client, Client, Client), including network settlement, clearing, and report files.
• Familiarity with funds-transfer processes and rails (ACH, wire, SWIFT, RTP/FedNow) and with the payments ecosystem: 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.

Education: Bachelor's degree (Finance, Accounting, Economics, a quantitative field, or similar); or a Master's degree; or equivalent work experience.

Schedule Notes: Work Location: Remote (US) Contract Duration: 12 months Travel: No Equipment: MacBook Spotlight Call: Yes - Magnit will be hosting supplier spotlight call for this req.