San Jos\u00e9, Costa Rica
Hybrid
Not Available
We are seeking a data-driven and analytical thinker to serve as our Collections & Delinquency Data Analyst. In this role, you will analyze portfolio performance data to identify trends in customer delinquencies, optimize collection strategies, and mitigate financial risk.
Because solar financing involves complex long-term assets (Leases, PPAs, and Loans), you will play a critical role in connecting customer payment behaviors with operational variables, such as system performance, billing cycles, and regional utility changes. The ideal candidate will turn complex data sets into actionable workflows that help us improve the efficacy of our billing and collections efforts while maintaining an excellent customer experience.
Monitor and analyze daily, weekly, and monthly delinquency trends (30/60/90+ days past due).
Segment the aging portfolio by financing product type (PPA, Lease, Loan), geographic region, utility territory, and customer credit tier (FICO score at underwriting) to identify pockets of risk.
Develop predictive models to identify "high-risk" accounts early in the delinquency cycle (early-stage roll rates).
Develop predictive analyses that provide cure confidence based on customer, system health, and maintenance inputs as well as the cure value based on lease and incentive value.
Leverage Automated and AI agents and tools to drive insightful analyses and novel ways to highlight actionable data.
Design, test, and optimize collections strategies (e.g., timing of automated SMS/emails vs. manual phone calls).
Create and manage daily/weekly operational queues and calling lists for the collections team to maximize recovery rates.
Analyze the cost-benefit of various recovery methods, including payment plans, automated clearing house (ACH) setups, and UCC-1 fixture filing legal actions.
Asset Performance Linking: Partner with the Operations & Maintenance (O&M) data team to cross-reference delinquent accounts with underproducing or offline solar systems. (Identify customers withholding payment due to system performance issues).
PTO (Permission to Operate) Analysis: Track delinquency spikes tied to the transition period between solar installation and utility activation.
Build, maintain, and automate interactive dashboards (via Power BI or Tableau) tracking key performance metrics like Bad Debt Expense, Roll Rates, and Days Sales Outstanding (DSO).
Present findings and performance forecasting to Executive Finance and Risk leadership.
Maintain clean data pipelines between the CRM (e.g., Salesforce), loan servicing platforms, and data warehouses.
Root-Cause Mentality: You have an obsession with digging past the surface level to understand why a customer isn't paying.
Communication: You possess the ability to translate complex data tables into clear, actionable stories for non-technical collections staff and executives.
Empathy & Ethics: You understand the compliance boundaries of collections (FDCPA regulations) while keeping customer preservation in mind.
Data Experience: 2–4+ years as a Data Analyst, specifically within consumer collections, credit risk, or loan servicing.
Education: Bachelor’s degree in Data Analytics, Finance, Economics, Statistics, or a related quantitative field.
SQL: Advanced proficiency -- must be able to confidently write complex queries, joins, and aggregations to extract data from data warehouses (Snowflake, Redshift, etc.).
BI Tools: Strong experience building production-level dashboards in Sigma or other tools, leveraging AI
Excel: Advanced modeling skills (VLOOKUP/XLOOKUP, Pivot Tables, Power Query, macro awareness).
AI Agents: Experience utilizing Claude, Gemini, Copilot and other AI analysis tools to model and automate insights.
Python/R: Experience utilizing Python (Pandas, NumPy) for predictive data modeling and automation is a major plus.
Solar/Renewable Energy Experience: Understanding of solar-specific billing models (fixed monthly vs. per-kWh production billing) is highly advantageous.
Want to know if this job is worth applying to?