CLO Reporting Analyst (multiple levels)

U.S. Bank is a leading provider of corporate trust services worldwide, 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 - Ability to manage multiple complex transactions simultaneously in a fast-paced environment - Ability to read, interpret, and apply trust indentures and related legal documents - Ability to translate indenture language into technical report specifications and cash flow logic - Ability to set up and maintain payment calculations and reporting structures within proprietary systems - Ability to receive, map, reconcile, and validate periodic collateral and asset activity data - Ability to perform portfolio compliance and trade testing on structured fixed income deals - Ability to compile and deliver monthly, quarterly, and annual investor, payment, and/or tax reports - Ability to make tax elections, apply for EINs, and track residual holder transfers - Ability to coordinate closely with internal operations teams - Ability to perform quality control reviews - Ability to interact regularly with asset managers, clients, investors, auditors, rating agencies, and internal teams - Ability to provide timely data and reporting deliverables to clients and external auditors - Ability to run daily, monthly, and quarterly reports - Ability to reconcile data across multiple sources and resolve exceptions - Ability to manage approximately 10 active deals simultaneously - Effective interpersonal, verbal, and written communication skills - Basic understanding of syndicated bank loans, fixed income securities, securitization structures, trading, or mutual funds - 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 - At U.S. It was founded in 1968, and is headquartered in Minneapolis, Minnesota, USA, with a workforce of 10001+ employees. Its website is http://www.usbank.com.