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 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.