Structured Trust and Analytics, Associate 2

Key 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.

Requirements & Tech Stack

• Ability to manage and manipulate large amounts of data in Excel.
• Ability to create Excel-based models to measure various tests and parameters outlined in legal documents, preferable related to CLOs/Bank Loans.
• Ability to comprehend and interpret legal documentation such as Indentures and Offering Memorandums.
• Ability to work with credit instruments (senior secured loans and high yield bonds).
• Strong communication skills / ability to work with clients.
• Systems: Wall Street Office, MS Excel, MS Outlook, SOLVAS, LoanOps Portal, My State Street, Bloomberg, LS Fax, Collaborate.

Qualifications

• Some understanding of Structured Finance Transactions.
• Strong client focus.
• Ability to perform well under pressure.
• Ability to successfully manage multiple assignments simultaneously.
• Strong work ethic and a positive attitude.
• Excellent time management skills and ability to prioritize deadline-driven workflow.
• Ability to work well within a small group and operate independently on short- and long-term goals.
• Detail-oriented and a natural problem solver; ability to independently research problems and offer solutions.
• Excellent intrapersonal & communication skills – via phone and email.
• Passion for improving systems and processes.