Associate, Structuring & Analytics — Cash Flow Modeling

SMBC Group; New York (NY); Hybrid; USD 119,000 - 175,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

SMBC Group is seeking a finance professional to develop and maintain cash flow models for ABS assets, using Excel, VBA, and Python. You will convert complex documentation into robust model logic, apply rating agency methods, and prepare materials for reviews.

You will support transactions from pre‑mandate to closing while driving automation to improve efficiency. You will collaborate with multiple teams to align analytics with deal execution and stay informed on market trends and ratings

Qualifications

• Master’s degree in finance, mathematics, mathematics of finance, or a related field plus 2 years of experience.
• Experience must include cash flow modeling in Excel; data processing and automation using Python and VBA; interpretation and application of rating agency methodologies; analysis and translation of deal documentation; and collateral analytics and pool selection.

Responsibilities

• Develop and maintain cash flow models for assets and liabilities across multiple ABS asset classes using Excel and VBA.
• Convert transaction documentation into robust model logic, incorporating waterfalls, triggers, eligibility criteria, and structural protections.
• Apply rating agency methodologies and required stresses and prepare analytical materials for rating agency review.
• Produce analytical deliverables including pool selection memoranda, model outputs, stress results, and execution exhibits for internal committees and external stakeholders.
• Support transactions from pre‑mandate through closing, including scenario analysis, syndicate analytics, and cross‑functional coordination.
• Enhance team efficiency through automation and process standardization using Excel, VBA, and Python.

Skills

Cash flow modeling

Python automation

VBA automation

Rating agency methodologies

Collateral analytics

Education

Master’s degree in finance or related field

Tools

Excel

Intex

Python

VBA

Job description

SMBC Group is seeking a finance professional to develop and maintain cash flow models for ABS assets, using Excel, VBA, and Python. You will convert complex documentation into robust model logic, apply rating agency methods, and prepare materials for reviews.

You will support transactions from pre‑mandate to closing while driving automation to improve efficiency. You will collaborate with multiple teams to align analytics with deal execution and stay informed on market trends and ratings