Predictive Covenant Modeling: Build scenario analysis tools to forecast our Covenant Matrix. Stress-test concentration limits and proactively predict performance triggers to ensure compliance under various macroeconomic conditions.
Due Diligence Analytics: Serve as the primary quantitative engine for the Capital Markets team during deal structuring. Execute complex data pulls, stratifications, and analytical deep-dives for field exams, financial audits, and investor diligence sessions.
Advanced Tape Generation: Write and maintain complex SQL queries to extract raw loan data, build flawless data tapes, and execute strict eligibility logic for our various SPVs.
Analytics Automation: Lead the charge in transitioning manual, legacy Excel-heavy workflows into streamlined, automated data pipelines with the use of AI tools.
Business Intelligence & Visualization: Design, build, and maintain reporting to visualize portfolio performance, vintage curves, and collateral efficiency for the executive team.
Business Case Development: Build rigorous, data-driven financial models and business cases to evaluate new operational changes. Model the bottom-line impact of proposed strategic initiatives before they go live.
Sales & Operations Analytics: Partner directly with the Sales and Operations teams to track origination funnels, build performance dashboards, and optimize unit economics across the entire loan lifecycle.
Cross-Functional Strategy: Act as the analytical translator between Capital Markets and the broader business. Ensure that our front-end sales and origination strategies align with our back-end funding capacity, eligibility criteria, and yield targets.
Experience:
3+ years of relevant experience in Data Analytics, Strategic Finance, or Capital Markets at a Fintech, Lending Platform, or Asset Manager.
Advanced Excel and strong SQL skills are mandatory. You must be completely comfortable writing complex queries to extract and manipulate massive datasets. (Bonus points for proficiency in Python/R or AI tools.)
You don't just pull data; you know how to interpret it to drive business decisions.