VP, CLO Modeling & Analytics — Data-Driven Finance Leader

BNY; Pittsburgh (Allegheny County); On-site; USD 180,000 - 260,000; Full time

Job summary

BNY Mellon in Pittsburgh and Houston hosts a Vice President, Loans Modeling and Analytics role in the Corporate Trust Analytics team. You will leverage debt-market expertise and quantitative modeling to drive accuracy and insights for CLO and loan reporting and modeling.

Located in Houston, TX or Pittsburgh, PA, you will collaborate with cross-functional teams to deliver robust investor reports, stress tests, and data-driven automation while mentoring junior staff.

Qualifications

• Bachelor’s or Master’s degree in Finance, Economics, Mathematics, Financial Engineering, Data Science, CS; advanced degree preferred.
• 5–10 years in structured finance, corporate trust, CLOs, leveraged loans with quantitative modeling focus.
• Proficiency in VBA, Python, R, and/or SQL for modeling and automation.
• Experience with Excel macros, data manipulation, Power BI, Alteryx, or similar tools.

Responsibilities

• Develop, maintain, QC, and enhance CLO compliance and waterfall models.
• Analyze CLO indentures, offering memoranda, and related documents.
• Build investor reports and dashboards on tests and distributions.
• Apply quantitative modeling to CLO portfolio performance and risk.
• Integrate data from internal and external sources to ensure data integrity.
• Mentor junior team members and lead automation initiatives.

Skills

VBA

Python

R

SQL

Excel

Power BI

Alteryx

SharePoint

Data analysis

Education

Bachelor’s or Master’s degree in Finance/Economics/Mathematics/Financial Engineering/Data Science/Computer Science

Tools

MS Excel

SharePoint

Alteryx

Power BI

Job description

BNY Mellon in Pittsburgh and Houston hosts a Vice President, Loans Modeling and Analytics role in the Corporate Trust Analytics team. You will leverage debt-market expertise and quantitative modeling to drive accuracy and insights for CLO and loan reporting and modeling.

Located in Houston, TX or Pittsburgh, PA, you will collaborate with cross-functional teams to deliver robust investor reports, stress tests, and data-driven automation while mentoring junior staff.