Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Reconciliation & Reporting Analyst

MindSource, Inc.

Job Description

Job Description

DOUBLE CHECK: NOTES SAY THIS IS A PART TIME ROLE.
Requisition Status: Pending
Status Reason: Pending Sourcing
Reason: OOO FTE Coverage
Reason Detail:
Manager:
Department: Engineering - Fintech Platform : 10414
Square
Job Category: Finance & Accounting
Job Code:
Job Title: Reconciliation & Reporting Analyst
Keywords:
Number of Positions: 1
Remaining Positions: 1

Duties:
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, 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.

Skills:

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.

Vacancy posted 22 days ago
Similar jobs that could be interesting for youBased on the Reconciliation & Reporting Analyst in Oakland, CA vacancy
  •  ...partners. We analyze data, create records and reports, and make key strategic decisions to...  ...the Role:The SEC Reporting Senior Analyst will support the end-to-end external financial...  ...of journal entries, balance sheet reconciliations, footnote disclosures and internal... 
    Suggested
    Full time

    Grocery Outlet

    Emeryville, CA
    4 days ago
  • $95.72k - $145.5k

     ...support clinical documentation for CMS, Medicare, Medicaid, and PACE reporting. This senior individual-contributor role combines encounter oversight, coding validation, error resolution, reconciliation, concurrent and retrospective coding review, and clinical... 
    Suggested
    Live in

    Center for Elders'​ Independence

    Oakland, CA
    11 days ago
  •  ...within the Bancorp. Streamline external reporting schedules through development of a...  ...including process mapping, edit testing, and reconciliations Work collaboratively with Internal and...  ...regulators desired. Finance Reporting Analyst At Fifth Third, we understand the importance... 
    Suggested
    Work experience placement
    Work at office
    Flexible hours

    Fifth Third

    San Francisco, CA
    5 days ago
  • $175k - $205k

     ...CA Candidate Location: Hybrid Travel Required: 10% Reports To: Executive Director, Clinical Data Management...  ...Lead cross‑functional resolution of significant data‑quality, reconciliation, and operational issues with sites, vendors, and internal stakeholders... 
    Suggested
    Full time
    Contract work

    CytomX Therapeutics

    Emeryville, CA
    3 days ago
  •  ...s) for assigned clinical studies. • Performs data cleaning/reconciliation activities as specified in company procedural documents and studyspecific...  ...on assigned clinical studies. • Generates and delivers reports to study team members. • Supports external data... 
    Suggested
    Work at office

    BeOne Medicines

    Emeryville, CA
    1 day ago
  • About the job Finance and Reporting Analyst - Remote Summary The Financial Analyst position is responsible for complete preparation of...  ...financial statements, management reporting packages, balance sheet reconciliations and working closely and liaising with other departments in... 
    Remote job

    Recruit Monitor

    San Francisco, CA
    1 day ago
  • $100k - $125k

     ...culturally relevant. As Revenue Accounting Analyst, you will be responsible for assisting with timely and accurately reporting revenue according to GAAP and ASC 606. You...  ..., creating journal entries and preparing reconciliations for related accountsFacilitate the preparation... 
    Full time
    Contract work
    Temporary work
    Work experience placement
    Work at office

    Samba TV

    San Francisco, CA
    16 hours ago
  • $315k - $375k

     ..., and archival Oversee development and maintenance of data-management plans, electronic case report forms, edit-check specifications, data-transfer agreements, reconciliation plans, coding conventions, and database lock plans Establish and govern clinical data standards... 
    Full time
    Contract work
    Work at office
    3 days per week

    Ray Therapeutics, Inc.

    Berkeley, CA
    1 day ago
  • $160k - $226.5k

     ...Data Transfer Plan (DTP), including the Data Quality Review reconciliation section for the external vendor data transfer(s), obtain final...  ...applicable.Develop and document external data edit checks and reports in the edit check template, obtain approvals and perform QC/... 
    Full time
    Work at office
    Local area
    Flexible hours

    EXELIXIS

    Alameda, CA
    16 hours ago
  • $192.3k - $235.1k

     ...customer experience. The Financial Data Reconciliation team enables the Mercury system by...  ...matching and investigating exceptions, to reporting on reconciliation health across the business...  ...a Senior Financial Data Reconciliation Analyst who will help operationalize,... 

    Mercury

    San Francisco, CA
    1 day ago
  • $123.2k - $156.7k

     ...:CGI is seeking a detail oriented Data Analyst to support Customer Identity and Access...  ...Developers, and business stakeholders to define reporting requirements, develop Tableau...  .... Strong SQL skills for data analysis, reconciliation, reporting, and investigations Desired... 
    Local area

    CGI

    Lafayette, CA
    4 days ago
  • $71.7k - $211.6k

     ...looking for a hands-on Healthcare Data Analyst who can take interoperability from data...  ...early discovery and design phases. You will report to the Engagement Lead and own the data...  ..., and interoperability test and reconciliation deliverables.This is a Full-Time, On-Site... 
    Full time
    Work at office
    Local area

    CGI

    Lafayette, CA
    8 hours ago
  •  ...office. We are looking for a Senior Data Analyst — Hardware & Supply Chain to join our...  ...metrics that show up in board and S-1 reporting.As Oura matures into a scalable consumer...  ...operational and financial data extraction, reconciliation, and modeling.Expertise in dimensional... 
    Contract work
    Work at office
    Local area
    Remote work
    Flexible hours

    Oura

    San Francisco, CA
    3 days ago
  • $130k - $200k

     ...Cardless is looking for a Senior Data Analyst to join our team and help shape the insights...  ...insights Build dashboards, reporting frameworks, and monitoring tools that improve...  ...Familiarity with financial systems, reconciliation workflows, or data integrity challenges... 
    Full time
    Work at office
    Local area
    Flexible hours
    3 days per week

    cardless

    San Francisco, CA
    5 days ago
  •  ...management tasks according to strict quality standards including SAE reconciliation, third party vendor data reconciliation, medical coding...  ...functional plans. Serves as primary reviewer or author of case report forms (CRFs) and CRF completion guidelines. Oversees and... 
    2 days per week
    3 days per week

    Redbock - an NES Fircroft company

    San Francisco, CA
    1 day ago
  •  ...build and user acceptance testing (UAT), study data cleaning and reconciliation, query issue and resolution, and database locks They will...  ...and maintain all data management documentation, including case report forms, data management plans, edit check specifications, data... 

    Katalyst CRO

    San Francisco, CA
    4 days ago
  • $146k - $161k

     ...while maintaining quality, timelines, and budget. This position reports to the Senior Director, Data Management. Key Responsibilities...  ...all study‑related data cleaning activities, including reconciliation of external data sources such as laboratory, ECG, imaging, eCOA... 
    Interim role
    Work at office
    Remote work
    3 days per week

    Remote Services Inc.

    San Francisco, CA
    1 day ago
  • $212k - $265k

     ...: insurance. The admin work - credentialing, claims, payment reconciliation - is a nightmare. We've automated that. But we're going further...  .... Drive insights and decisions through strategic analysis, reporting, experimentation and predictive modeling. Obsess over... 

    Headway

    San Francisco, CA
    1 day ago
  •  ...timelines Generate and/or review/approve study documents (e.g. Data Management Plans, Case Report Forms, data transfer specifications, SAE and/or external data reconciliation plans, coding conventions, study protocols) Execute and/or distribute data management... 

    Fladger Associates

    San Francisco, CA
    1 day ago
  • Pivot Point Solutions is seeking a mid-level Financial Reporting Business Analyst in Oakland, CA. The role combines financial planning, variance analysis, and operational reporting with hands-on development of Power BI dashboards and automation using Power Platform and... 
    3 days per week

    Pivot Point Solutions

    Oakland, CA
    6 hours ago
  • $122k - $240.5k

     ...experienced Data Engineer who is comfortable on both sides - reads mainframe file layouts, DB2 schemas and builds Python/SQL loads and reconciliations on the modern side.A successful candidate would possess these skills:Ability to work independently and collaborate as part of a... 
    Local area
    Flexible hours

    Deloitte

    San Francisco, CA
    1 day ago
  •  ...from Zip into Oracle Fusion. The Lead Consultant for Oracle Reporting will be responsible for managing and executing Oracle...  ...target mappingOracle Fusion Procurement, Purchasing and AP data knowledgeData validation, reconciliation, cutover and technical leadership

    eTeam Inc.

    San Francisco, CA
    22 days ago
  • $24 - $42 per hour

     ...operations running smoothly on some of California's most critical infrastructure projects. Job Overview Title: Financial Reporting Business Analyst Sector: Information Technology / Business Operations Seniority: Mid-Level Location: Oakland, CA Job Type: Hybrid - 0-3 Days... 
    Contract work
    For contractors
    3 days per week

    Pivot Point Solutions

    Oakland, CA
    6 hours ago
  • $148k - $203.5k

     ...AnalystOkta seeks a skilled Staff Order-to-Cash Analyst to optimize and support our end-to-end...  ..., and GL posting. This role will report to the OTC Manager in SFO, California....  ...data accuracy across all financial reconciliations(Order to Cash). Support NetSuite financial... 
    Contract work
    Local area
    Worldwide
    Flexible hours

    Okta

    San Francisco, CA
    4 days ago
  • $86.8k - $217.1k

     ...setup to database lock.Serve as the main client contact for all data management deliverables.Oversee SAE, PK, and external data reconciliation and database deployment.Manage timelines, budgets, and resource allocation to meet customer expectations.Mentor junior data... 
    Full time
    Part time
    Immediate start
    Remote work
    Work from home
    Worldwide

    IQVIA

    San Francisco, CA
    1 day ago
  • $236k - $324.5k

     ...in finance contexts. You will be central to how Faire plans, reports, and operates the business — and to ensuring we are fully prepared...  ...the Finance Data Function, ensuring data integrity and reconciliation across operational and financial metrics.Manage Cross-Functional... 
    Contract work
    Work experience placement
    Work at office
    Local area
    Remote work
    Monday to Friday
    Flexible hours
    3 days per week

    Faire

    San Francisco, CA
    3 days ago
  • $100.8k - $245.5k

     ...resolution.• Proficiency in SQL for complex data extraction, reconciliation, transformation, and automation tasks.• Expertise in data profiling...  ....• Team‑lead expertise, including stream planning, status reporting, governance management, managing team progress against the... 
    Contract work
    Work at office
    Local area
    2 days per week

    CGI

    Lafayette, CA
    4 days ago
  • $186k - $233k

     ...configurations, and programming work performed by external partners. Reporting to the Senior Director, Clinical Data Systems & Ops Ex, the...  ...to resolve issues with data transfers, integrations, and reconciliation, including laboratory, imaging, eCOA, and IRT data. Work... 
    Full time
    Local area
    Worldwide

    Revolution Medicines, Inc.

    San Francisco, CA
    1 day ago
  • $90k - $180k

     ...history of healthcare innovation.  We're looking for a Data Analyst to serve as a critical analytical partner across customer service...  ...ecommerce trends to help drive better business outcomes. Reporting to the Director, DTC, Operations, Customer Service & PMO, this... 
    Worldwide

    Abbott

    Alameda, CA
    2 days ago
  •  ...accountability. Technical skills we value: Data management and analysis using spreadsheets, SQL, Python, dashboards, and automated reconciliation and validation tools. Program planning, dependency tracking, capacity planning, risk management, and quantitative process... 

    Axiom Bio

    San Francisco, CA
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Reconciliation & Reporting Analyst. Be the first to apply!