The Residual Data Analyst will analyze and validate partner payments, manage residuals, and automate reporting processes for financial integrity.
Residual Data Analyst
Location: Los Angeles, Miami, or US remote
Full-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 have
Required:
● 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 environment
Preferred 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 preferred
We think you'll love being part of our team because
At Payabli, you’ll have a front row seat to building a high-growth venture backed fintech company. You’ll work directly with the CFO and be considered an integral part of our team. You’ll stretch yourself every day, learn a ton, grow alongside the company, and have a lot of fun building Payabli with us.
We’re a values driven company that cares deeply about our team, partners, and customers. Our north star values are:
● Team First: We invest in our people to foster a vibrant culture where we all love coming to work everyday
● Customer Love: We go above and beyond to woo Customers so that they write us love letters
● Small GIant: We plan to build a massive business; however, we are also building a sustainable organization that has a strong sense of purpose and practices long-term thinking
● Run to the Fire: We embrace difficult situations and lean in when confronted with adversity. We don’t shy away from doing the right thing even if it's hard
● Bias for Action: We operate with urgency; we don’t leave for tomorrow what can be done today
● Little Things Count: We differentiate ourselves by focusing on the little things. We believe small but thoughtful considerations and gestures can have an outsized impact
● Punch Above our Weight: We don’t fear the competition, rather we see our nimbleness as a competitive advantage. We carry ourselves with confidence and conviction in our abilities
● Truth Seekers: We seek truth above pride and ego. We hold each other accountable with respect and in the open. We don’t talk behind each other’s backs. One team member’s problem is the whole team’s problem
What we can offer you
● Competitive base and strong upside potential
● Stock options with the potential to unlock more equity as we grow
● Flexible PTO and paid parental leave
● Medical, dental, & vision insurance
● 401K, HSA, pre-tax savings programs
● Option to be fully remote or hybrid
● Monthly education fund to spend on anything that enhances your skills or gets you one step closer to your passion goals
Payabli is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
Top Skills
Excel
Power BI
Tableau
Similar Jobs
Enterprise Web • HR Tech • Information Technology • Software • Cybersecurity
The Lead Business Analyst analyzes cyber resilience for customers, delivers insights, presentations and reports, and enhances customer success through strategic alignment and support.
Top Skills:
Google LookerGoogle SheetsGoogle SlidesExcelMicrosoft PowerpointSnowflakeSQL
Fintech • Machine Learning • Mobile • Security • Software
The Insights Analyst will provide data-driven insights to improve member experience, design and evaluate experiments, and present findings to influence business strategy.
Top Skills:
LookerPythonSQL
Consumer Web • eCommerce • Food • Healthtech • Natural Language Processing • Social Impact
The Anaplan Model Builder will develop and enhance Demand and Supply Planning models, ensuring effective data integration and translating business requirements into technical solutions.
Top Skills:
AnaplanSQL
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering