Middle Office Project Analyst - Collateralized Loan Obligation
About The Position
U.S. Bank Global Corporate Trust Services is a leading provider of corporate trust services worldwide, offering trustee, agency, escrow, document custody, and money market issuing services through a network of domestic and international offices. The Collateralized Loan Obligation (CLO) and Global Structured Finance (GSF) groups within this division specialize in structured finance vehicles that issue debt and equity liabilities to acquire diverse portfolios of collateral. These services encompass Trust Reporting, which involves reviewing deal documents, establishing cashflow priorities, collecting asset activity data, reporting to bondholders, and handling trust tax reporting as needed.
Requirements
- Bachelor’s degree in business, finance, economics, accounting or related field, or equivalent work experience
- Two to three years of relevant work experience
- Strong hands-on experience with VBA, SQL, and at least one modern scripting language such as Python
- Demonstrated ability to build tools from scratch, not just maintain existing solutions
- Proven experience debugging and resolving complex technical issues across VBA, SQL, and Python
- Strong analytical and problem-solving skills with attention to detail
- Ability to work independently, manage multiple priorities, and deliver solutions in a fast-paced environment
- Strong communication skills, with the ability to explain technical concepts to non-technical users
Nice To Haves
- Experience in financial services, asset management, or capital markets
- Familiarity with CLOs, structured finance, or loan products
- Experience supporting reporting, reconciliations, or middle-office operations
- Exposure to databases and reporting platforms commonly used in financial environments
- Experience improving or replacing Excel-based EUCs with more scalable solutions
Responsibilities
- Design, develop, and maintain business-line tools for CLO Middle Office reporting analysts to support daily, monthly, and investor reporting processes.
- Build automation and data processing solutions using VBA, Python, and SQL to enhance efficiency, reduce manual effort, and minimize operational risk.
- Collaborate with Middle Office analysts to understand reporting workflows, data sources, and challenges, translating them into technical solutions.
- Debug, enhance, and refactor existing VBA, SQL, and Python code used in production reporting tools.
- Develop SQL queries and data extracts to support reconciliations, compliance reporting, and analytics.
- Create well-documented, user-friendly tools that can be maintained and supported by the broader team.
- Assist with testing, validation, and quality control of newly developed or enhanced tools.
- Support ongoing process improvement initiatives across CLO Middle Office operations.
- Serve as a technical point of contact for troubleshooting issues related to internally developed tools.
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
