Modeling & Analytics Lead

. Reverse engineer and maintain deal level payrules used to calculate multi-class securitization factors and payments .

Posted 4/21/2026full-timeRemote • 🇺🇸 United StatesSenior💰 $156,500 - $181,000 per yearWebsite

Tools & technologies

SQLVBA

Key responsibilities & impact

Reverse engineer and maintain deal level payrules used to calculate multi-class securitization factors and payments
Onboard securities/deals to facilitate bond administration and IRS tax calculations and reporting
Collaborate with product owners and key stakeholders to identify and implement system and process improvement opportunities
Support internal/external audit exams
Develop queries, analyses, or reports from applications for operations or management staff of assigned business unit(s)
Lead/participate in testing and acceptance of newly developed platform functionality
Train and mentor more junior analysts

What you’ll need

Bachelors in Business Administration, Finance, technical discipline, or industry related experience
Applicants must be authorized to work in the US without requiring employer sponsorship currently or in the future
Knowledge of MBS and the housing finance industry
Strong analytical and technical skillset (e.g. SQL, VBA, C++) including Excel formulas and functions
Experience with Intex or related software a plus

Comp & perks

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLVBAC++Excel formulasdata analysisreportingquery developmentsystem improvementprocess improvementtesting

Soft Skills

analytical skillscollaborationmentoringcommunicationleadership