Analyst/Associate

About the Role

The Structured Finance Analytics team, part of the Global Banking & Markets division, is seeking a motivated professional to support the Credit & Asset Finance business. The team possesses product expertise across residential assets, consumer loans, real estate, and warehouse financing.

Key Responsibilities

• Act as a client advisor and perform analytics on all principal and 3rd party securitization transactions, including but not limited to: NPL, RPL, PJ, Agency, Non-QM, SFR, MSR, Investor Occupied, Second Lien, Fix and Flip, iBuyer, and Mortgage Insurance Linked Notes.
• Collaborate with clients and perform data tape creation from various resources, including:
• Settlement Data
• Latest Month End Servicer Data
• TPR due diligence Data
• Originator Data
• Perform data validations and create portfolio-level stratification and replines.
• Perform portfolio collateral analysis.
• Provide pool-level CPR speeds, loss severity, and credit enhancement from RA (Fitch, KBRA, Moodys, Milan) models.
• Assist in populating credit memos and PPM materials with outside accountants and lawyers.
• Perform asset pool selection based on contribution requirements on ABS/CMBS securitization.
• Work with rating agencies and create historical performance matrices (CPR, CDR, Charge off, Recoveries, Loss) to project future performance.
• Evaluate daily mark to market on all MSR warehouse lines.
• Provide recommendations on OAS spreads given the recent dynamic change in rate environments.
• Manage cross-functional relationships with the desk, IBD, transaction management, diligence, operations, controller, and technology teams to ensure monthly portfolio activities are accurately represented.

Requirements & Tech Stack

• Advanced Excel skills with knowledge in advanced functions such as vlookup, sumproducts, index/matches, indirects, etc.
• Technical skills including CAS, Excel VBA, SQL are preferred.
• Knowledge in Python is a huge plus.
• Ability to perform in a fast-paced environment with tight time constraints.

Qualifications

• Bachelor’s degree (U.S. or foreign equivalent)
• 0 to 3 years of Resi loans / Fixed income experience or internship in related fields for Analyst.
• 3+ years of experience for Associate.
• Undergraduate in Finance, Economics, Mathematics, or other STEM-related degree is preferred.
• Big four accounting firm experience in collateral analytics and RA runs on RMBS/CMBS deals is strongly preferred.