Middle Office Project Analyst - Collateralized Loan Obligation

U.S. Bank; Boston (MA); Hybrid; USD 71,000 - 84,000; Full time

Benefits offered by this job

Healthcare (medical, dental, vision)

401(k) and employer-funded retirement

Paid vacation

Up to 11 paid holiday opportunities

Adoption assistance

Sick and Safe Leave

Job summary

U.S. Bank Global Corporate Trust Services seeks a capable analyst to design, develop, and maintain internal tools for CLO Middle Office reporting. The role focuses on automating data processing, building SQL queries, and improving reporting accuracy.

Collaborate with asset managers, investors, and auditors, while delivering scalable, well-documented solutions. Requires strong VBA/SQL/Python skills and a business-focused mindset.

Qualifications

• Bachelor's degree or equivalent work experience.
• 2–3 years of relevant work experience.
• Strong analytical and problem-solving skills.
• Ability to work independently in a fast-paced environment.
• Strong communication skills to explain technical concepts.

Responsibilities

• Design, develop, and maintain business-line tools used by CLO Middle Office reporting analysts.
• Build automation and data processing solutions using VBA, Python, and SQL.
• Partner with Middle Office analysts to understand reporting workflows and translate them into technical solutions.
• Debug, enhance, and refactor existing VBA, SQL, and Python code 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 by the team.
• Assist with testing, validation, and quality control of newly developed tools.
• Support process improvement initiatives across CLO Middle Office operations.
• Serve as a technical contact for troubleshooting internally developed tools.

Skills

Analytical thinking

Communication skills

Independent work

Education

Bachelor's degree in business, finance, economics, accounting or related field

Tools

VBA

SQL

Python

Job description

Job Description

U.S. Bank Global Corporate Trust Services is one of the largest providers of corporate trust services in the world. Our clients look to us for trustee, agency, escrow, document custody and money market issuing services via our 48 domestic offices and three international offices. The Collateralized Loan Obligation (CLO) and Global Structured Finance (GSF) groups are divisions within U.S. Bank Global Corporate Trust Services and provide services on structured finance vehicles that issue both debt and equity liabilities, the proceeds of which are used to buy a portfolio of collateral such as syndicated bank loans, corporate bonds, ABS, MBS, CMBS and Mezzanine debt. These services include Trust Reporting, which requires review of the deal documents, set up of cashflow priorities, collection of periodic asset activity data, reporting to bondholders, and when required, trust tax reporting.

Essential functions include:

• Read and interpret trust indentures with regard to reporting requirements.
• Create technical report specifications from indenture language.
• Set up payment calculations in a variety of in-house systems.
• Receive, map and reconcile periodic collateral data.
• As required, make tax elections, file for EINs, and track residual holder transfers.
• As required, perform portfolio compliance tests on a selection of structured fixed income deals (trade testing).
• Compile monthly, quarterly and annual payment and/or tax reports.
• Coordinates with operations teams to ensure correct payments are received and made.
• Perform quality control review of reports, meeting timeliness and accuracy standards.
• Frequent interaction with asset managers, investors, auditors and rating agencies.

Basic Qualifications

Bachelor’s degree in business, finance, economics, accounting or related field, or equivalent work experience. Two to three years of relevant work experience.

Key Responsibilities

• Design, develop, and maintain business-line tools used by 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 improve efficiency, reduce manual effort, and minimize operational risk
• Partner with Middle Office analysts to understand reporting workflows, data sources, and pain points, and translate 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

Required Qualifications

• 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

Preferred Qualifications

• 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

What Success Looks Like in This Role

• Middle Office analysts rely on your tools to perform reporting and reconciliations more efficiently and with fewer errors
• Manual processes are automated or simplified through well-designed technical solutions
• Existing tools are more stable, easier to maintain, and better documented
• Technical issues are identified, debugged, and resolved quickly with minimal disruption to daily reporting

This position is not eligible for visa sponsorship.

This role requires working from a U.S. Bank location three (3) or more days per week. If there’s anything we can do to accommodate a disability during any portion of the application or hiring process, please refer to our disability accommodations for applicants.

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
• Review our full benefits available by employment status here.

U.S. Bank is an equal opportunity employer. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, and other factors protected under applicable law.

E-Verify U.S. Bank participates in the U.S. Department of Homeland Security E-Verify program in all facilities located in the United States and certain U.S. territories.

The salary range reflects figures based on the primary location, which is listed first. The actual range for the role may differ based on the location of the role. In addition to salary, U.S. Bank offers a comprehensive benefits package, including incentive and recognition programs, equity stock purchase 401(k) contribution and pension (all benefits are subject to eligibility requirements). Pay Range: $71,400.00 - $84,000.00

U.S. Bank will consider qualified applicants with arrest or conviction records for employment. U.S. Bank conducts background checks consistent with applicable local laws, including the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act as well as the San Francisco Fair Chance Ordinance. U.S. Bank is subject to, and conducts background checks consistent with the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA). In addition, certain positions may also be subject to the requirements of FINRA, NMLS registration, Reg Z, Reg G, OFAC, the NFA, the FCPA, the Bank Secrecy Act, the SAFE Act, and/or federal guidelines applicable to an agreement, such as those related to ethics, safety, or operational procedures. Applicants must be able to comply with U.S. Bank policies and procedures including the Code of Ethics and Business Conduct and related workplace conduct and safety policies.

Posting may be closed earlier due to high volume of applicants.

At U.S. Bank, we’re on a journey to do our best. Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed. We believe it takes all of us to bring our shared ambition to life, and each person is unique in their potential. A career with U.S. Bank gives you a wide, ever-growing range of opportunities to discover what makes you thrive at every stage of your career. Try new things, learn new skills and discover what you excel at—all from Day One.