Trust Reporting Analyst

About the Role

The Collateralized Loan Obligation (CLO) Trust Reporting Analyst supports structured finance vehicles by performing trust reporting, collateral data reconciliation, compliance testing, and investor reporting. This role requires strong analytical skills, attention to detail, and the ability to manage multiple complex transactions simultaneously in a fast-paced environment. The role offers significant exposure to CLO and CDO products.

Key Responsibilities

• Read, interpret, and apply trust indentures and related legal documents to determine reporting and compliance requirements.
• Translate indenture language into technical report specifications and cash flow logic.
• Set up and maintain payment calculations and reporting structures within proprietary systems.
• Receive, map, reconcile, and validate periodic collateral and asset activity data.
• Perform portfolio compliance and trade testing on structured fixed income deals.
• Compile and deliver monthly, quarterly, and annual investor, payment, and/or tax reports.
• Make tax elections, apply for EINs, and track residual holder transfers.
• Coordinate closely with internal operations teams to ensure accurate and timely receipt and distribution of cash flows.
• Perform quality control reviews to ensure reports meet established accuracy and timeliness standards.
• Interact regularly with asset managers, clients, investors, auditors, rating agencies, and internal middle-office and cash administration teams.
• Liaise with third-party administrators and internal U.S. Bank administration teams managing cash accounts.
• Provide timely data and reporting deliverables to clients and external auditors.
• Run daily, monthly, and quarterly reports.
• Reconcile data across multiple sources and resolve exceptions.
• Send reporting outputs and data packages to clients.
• Manage approximately 10 active deals simultaneously.
• Communicate via phone, email, and in-person with internal teams, clients, and external auditors.

Requirements & Tech Stack

• Proficiency with Microsoft Office applications, including Outlook, Teams, and Excel.
• Intermediate Excel skills, including pivot tables and XLOOKUP for reconciliation and analysis.

Qualifications

• Bachelor’s degree in business, finance, economics, accounting or related field, or equivalent work experience.
• Basic understanding of syndicated bank loans, fixed income securities, securitization structures, trading, or mutual funds.
• Strong analytical skills with the ability to interpret data and identify discrepancies or exceptions.
• Effective interpersonal, verbal, and written communication skills.
• Ability to work independently while managing multiple priorities and deadlines in a dynamic environment.
• Strong organizational and time-management skills.
• Familiarity with CDO or structured finance systems is helpful but not required.

Location

• Chicago, IL (Hybrid/Flexible schedule: 3+ days in office per week)

Pay Range

• $68,850.00 - $81,000.00