CLO Reporting Analyst (multiple levels)

U.S. Bank is a leading provider of corporate trust services, and they are seeking a CLO Reporting Analyst to support structured finance vehicles. The role involves performing trust reporting, collateral data reconciliation, compliance testing, and investor reporting, requiring strong analytical skills and attention to detail.

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, as required
• Compile and deliver monthly, quarterly, and annual investor, payment, and/or tax reports
• Make tax elections, apply for EINs, and track residual holder transfers when required
• 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

Skills

• Bachelor's degree in business, finance, economics, accounting or related field, or equivalent work experience
• Less than two years of relevant work experience
• Strong analytical skills, attention to detail, and the ability to manage multiple complex transactions simultaneously in a fast-paced environment
• 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, as required
• Compile and deliver monthly, quarterly, and annual investor, payment, and/or tax reports
• Make tax elections, apply for EINs, and track residual holder transfers when required
• 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
• 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
• Proficiency with Microsoft Office applications, including Outlook, Teams, and Excel
• Intermediate Excel skills, including pivot tables and XLOOKUP for reconciliation and analysis
• Familiarity with CDO or structured finance systems is helpful but not required

Benefits

• Healthcare (medical, dental, vision)
• Basic term and optional term life insurance
• Short-term and long-term disability
• Pregnancy disability and parental leave
• 401(k) and employer-funded retirement plan
• Paid vacation (from two to five weeks depending on salary grade and tenure)
• Up to 11 paid holiday opportunities
• Adoption assistance
• Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law

Company Overview