Residual Data Analyst (Payments)

Residual Data AnalystLocation: Los Angeles, Miami, or US remoteFull-time Payabli’s mission is to enable any software company to become a payments company through its payment infrastructure and monetization platform. With Payabli, software companies can make payments a core part of their business model to drive revenue, enhance customer lifetime value, and boost enterprise value. Our Founders are Serial Entrepreneurs who have built and scaled successful technology companies like RevoPay (Acquired), Seamless.com (IPO), and ServiceTitan. We are backed by top venture capital investors QED Investors, TTV Capital,  Fika Ventures, and Bling Capital. Residual Data Analyst will be responsible for analyzing, calculating, and validating residual partner payments, referral fees, and other revenue-sharing obligations across our ecosystem of ISVs and referral partners. This role requires deep expertise in the payments industry, strong data science and analytical skills, and the ability to navigate complex partner agreements and transaction datasets. The ideal candidate will ensure accurate, timely, and transparent reporting and payment processes that strengthen our partner relationships and support the integrity of our financial operations. You can expect to collaborate with teammates across Operations, Billing, and Finance.  In this Residual Data Analyst role, you will have the following key responsibilities●        Residuals Management: Analyze and calculate monthly residual payments, referral commissions, and partner fees based on transaction data, fee structures, and partner agreements●        Data Analysis: Extract, transform, and analyze large datasets from payment processors and internal databases to ensure the integrity of financial calculations●        Heavy Excel Calculations: Build advanced Excel workbooks, including complex formulas, macros, and dynamic dashboards to automate residual calculations and reporting processes●        Data Visualization and Reporting: Develop and maintain partner-facing and internal dashboards using Tableau, Power BI, or similar tools to provide clear insights into residual payments, partner performance, and financial trends●        Partner Reporting: Generate detailed partner statements; troubleshoot and resolve inquiries related to residual payments, referral fees, and program performance●        Agreement Interpretation: Interpret and operationalize partner agreements, applying complex fee splits, bonuses, thresholds, and adjustments accurately within reporting models●        Process Improvement: Continuously improve automation and scalability of residual processes, reducing manual intervention while maintaining data accuracy and auditability●        Cross-Functional Collaboration: Partner with Finance, Business Development, Legal, and Operations teams to ensure residual processes align with broader financial and contractual frameworks
We’d love to hear from you if you haveRequired:●        Bachelor’s degree in Statistics, Mathematics, Business / Economics, or a related field ●        3+ years of experience in the payments industry, preferably with a processor, ISO, ISV, or FinTech●        Expert-level Excel skills, including advanced formulas, pivot tables, macros, and data validation tools●        Proficient in database querying and transaction-level data analysis●        Deep understanding of payment processing structures, passthrough billing, absorbed billing, interchange-plus pricing, BIN sponsorship models, and residual payment streams●        Strong analytical, organizational, and problem-solving skills with excellent attention to detail●        Ability to translate complex contract terms into accurate, scalable financial models and reports●        Strong communication skills with the ability to explain technical and financial details clearly●        Self-motivated, highly organized, and capable of managing multiple priorities in a fast-paced environmentPreferred Qualifications:●        Prior experience building or managing a residuals management platform or automated reporting module●        Strong experience with data visualization platforms (e.g., Tableau, Power BI) for building reports and dashboards●        Familiarity with API-based data extraction and integration methods●        Background in working with acquirers, payment gateways, merchant reporting systems, or embedded finance ecosystems●        Experience supporting partner operations or revenue accounting functions in a growing company environment●        Fluency in Spanish is preferredWe think you'll