Structured Trust & Analytics Associate II

State Street Corporation; Quincy (MA); On-site; USD 44,000 - 62,000; Full time

Benefits offered by this job

Health insurance

401K with company match

Paid time off

Flexible work programs

Volunteer days

Job summary

State Street Corporation is seeking a detail-oriented Associate 2 to support Structured Trust and Analytics. You will run models in Excel and SOLVAS, update CLO-related documents, and produce reports for CLO investors.

You will collaborate with collateral managers, auditors, and clients to ensure accurate data and timely distributions. The role emphasizes data manipulation in Excel, interpretation of indentures, and frequent client communication.

Qualifications

• Experience in structured finance data modeling and client-facing roles.
• Ability to manipulate large data sets in Excel and interpret legal documents such as Indentures/Offering Memorandums.
• Strong communication skills, time management, and problem-solving abilities.

Responsibilities

• Run hypothetical trades through Excel/SOLVAS-based models and communicate results to the client.
• Create and update Excel-based models based on CLO Warehouse/Indenture documents.
• Execute Excel/CDO Suite models daily to calculate CLO Concentration, Coverage, and Collateral Quality Tests.
• Liaise with Collateral Managers and Auditors to reconcile data and produce monthly trustee reports and quarterly payment distribution reports for CLO investors.
• Advance relationships with clients, investors and internal groups within State Street.
• Participate in special projects as assigned.

Skills

Excel modeling

Data analysis

Client communication

Time management

Tools

Wall Street Office

MS Excel

MS Outlook

SOLVAS

LoanOps Portal

My State Street

Bloomberg

LS Fax

Collaborate

Job description

State Street Corporation is seeking a detail-oriented Associate 2 to support Structured Trust and Analytics. You will run models in Excel and SOLVAS, update CLO-related documents, and produce reports for CLO investors.

You will collaborate with collateral managers, auditors, and clients to ensure accurate data and timely distributions. The role emphasizes data manipulation in Excel, interpretation of indentures, and frequent client communication.