Senior Specialist, Loans Modeling & Analytics (CLO / CFO)

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

Job summary

BNY is seeking a Senior Specialist in Loans Modeling & Analytics to drive CLO and loan analytics within the Corporate Trust Analytics Group. The role spans model development, platform modernization, and AI-enabled workflow enhancements across document review, data extraction, and reporting.

The candidate will analyze complex legal and deal documents, build investor reports, and partner with data providers to ensure data integrity.

Qualifications

• Bachelor’s degree in Finance, Economics, Mathematics, Statistics, Financial Engineering, Data Science, Computer Science, or related quantitative field.
• 3–5 years of experience in financial modeling, structured finance, leveraged loans, CLOs, corporate trust analytics, data science, or related quantitative/analytical roles.
• Proficiency in programming or analytical languages/tools such as Python, SQL, VBA, R, or similar for workflow automation, model logic, data analysis, and quality control.
• Advanced Excel skills and experience with analytics, workflow, or visualization platforms (Power BI, Alteryx, SharePoint).

Responsibilities

• Develop, maintain, quality check, and enhance CLO compliance and waterfall models.
• Analyze and interpret CLO indentures, offering memoranda, and related deal documents.
• Build, review, and enhance investor reports, dashboards, and analytics for compliance tests and distributions.
• Apply quantitative modeling and data analysis to stress test transactions and evaluate portfolio behavior.
• Partner with internal teams and data providers to source, integrate, and validate critical datasets.
• Perform detailed reviews, reconciliations, and trend analyses to improve analytics processes.
• Contribute to transforming the CLO/loans modeling platform and adopting AI-enabled capabilities.
• Collaborate across business, analytics, technology, and operations teams to drive improvements.
• Mentor junior team members and foster a culture of rigor and continuous learning.

Skills

Analytical mindset

Problem solving

Communication skills

Attention to detail

Team mentorship

Education

Bachelor's degree in Finance/Math/Stats/Quantitative field

Tools

Python

SQL

VBA

R

Power BI

Job description

Job Description

Senior Specialist, Loans Modeling & Analytics (CLO / CFO) We’re seeking a future team member for the role of Senior Specialist, Loans Modeling & Analytics to join our Corporate Trust Analytics Group. This is a unique opportunity for a high-performing professional with a background in loan markets, quantitative finance, financial engineering, modeling, data science, and/or analytics to work at the intersection of structured credit, loans, technology, and analytics platform transformation. In this role, you will help shape the future-state operating model for CLO and loans analytics, contributing not only to model and investor report development, but also to the modernization of our modeling platform and leverage agentic and AI-enabled capabilities across the workflow. This includes opportunities to support solutions for CLO document review, data extraction, model development, quality control, analytics generation, and process automation. This role is located out of our Houston, TX or Pittsburgh, PA office. In this role, you’ll make an impact in the following ways:

• Develop, maintain, quality check, and enhance CLO compliance and waterfall models, including programming and analysis of collateral quality tests, coverage tests, concentration limits, payment structures, and cash flow mechanics to ensure adherence to governing transaction documents.
• Analyze and interpret complex legal and transaction documents, including CLO indentures, offering memoranda, and related deal documentation, translating structural language into modeling logic, analytics requirements, and reporting outputs.
• Build, review, and enhance investor reports, dashboards, and analytics covering compliance tests, noteholder distributions, asset-level information, and other key transaction metrics to support accurate and timely stakeholder reporting.
• Apply quantitative modeling, data analysis, and scenario-based thinking to stress test transactions and evaluate portfolio behavior, structural performance, and model outcomes across CLO transactions.
• Partner with internal teams and data providers to source, integrate, and validate critical datasets, ensuring strong data integrity across model inputs, calculations, and outputs.
• Perform detailed reviews, reconciliations, and trend analyses to identify modeling issues, improve performance, strengthen controls, and support continuous enhancement of analytics processes and outputs in alignment with evolving market conditions and transaction structures.
• Contribute to the transformation of the CLO / loans modeling platform, helping to define and implement scalable, efficient, and controlled solutions that improve the end-to-end analytics lifecycle.
• Support the adoption of agentic and AI-enabled capabilities to enhance document ingestion, clause analysis, data extraction, model setup, model QC, exception identification, and other high-value analytical workflows.
• Collaborate across business, analytics, technology, and operations teams to align on transaction requirements, deliver process improvements, solve complex transaction challenges, and support strategic modernization initiatives and ad-hoc client requests.
• Mentor junior team members and help foster a culture of analytical rigor, innovation, accountability, and continuous learning.

To be successful in this role, we’re seeking the following:

• Bachelor’s degree in Finance, Economics, Mathematics, Statistics, Financial Engineering, Data Science, Computer Science, or another highly quantitative discipline, or the equivalent combination of education and experience.
• 3–5 years of experience in financial modeling, structured finance, leveraged loans, CLOs, corporate trust analytics, data science, or related quantitative/analytical roles.
• Strong interest in or knowledge of CLOs, loans, structured debt products, transaction types, and related concepts.
• Experience building or supporting financial models, analytical tools, or data-driven workflows in a controlled business environment.
• Proficiency in one or more programming or analytical languages/tools such as Python, SQL, VBA, R, or similar technologies used for workflow automation, model logic, data analysis, and quality control.
• Advanced Excel skills and experience with analytics, workflow, or visualization platforms such as Power BI, Alteryx, SharePoint, or similar tools.
• Demonstrated ability to work with large and complex datasets, perform root-cause analysis, and translate data into business and analytical insight.
• Strong problem-solving, intellectual curiosity, and attention to detail, with the ability to evaluate complex transaction structures and produce accurate, high-quality outputs.
• Excellent written and verbal communication skills, including the ability to explain technical or structural concepts clearly to a range of stakeholders.
• A mindset oriented toward innovation, modernization, and continuous improvement, with enthusiasm for helping transform how structured credit analytics is delivered through technology and AI-enabled solutions.

About Us

At BNY, our culture allows us to run our company better and enables employees’ growth and success. As a leading global financial services company at the heart of the global financial system, we influence nearly 20% of the world’s investible assets. Every day, our teams harness cutting-edge AI and breakthrough technologies to collaborate with clients, driving transformative solutions that redefine industries and uplift communities worldwide. Recognized as a top destination for innovators, BNY is where bold ideas meet advanced technology and exceptional talent. Together, we power the future of finance – and this is what is all about. Join us and be part of something extraordinary.

About The Team

At BNY, our culture speaks for itself, check out the latest BNY news at BNY Newsroom & BNY LinkedIn

Here’s a Few Of Our Recent Awards

• America’s Most Innovative Companies, Fortune, 2025
• World’s Most Admired Companies, Fortune 2025
• “Most Just Companies”, Just Capital and CNBC, 2025

Our Benefits And Rewards

BNY offers highly competitive compensation, benefits, and wellbeing programs rooted in a strong culture of excellence and our pay-for-performance philosophy. We provide access to flexible global resources and tools for your life’s journey. Focus on your health, foster your personal resilience, and reach your financial goals as a valued member of our team, along with generous paid leaves, including paid volunteer time, that can support you and your family through moments that matter. BNY is an Equal Employment Opportunity/Affirmative Action Employer - Underrepresented racial and ethnic groups/Females/Individuals with Disabilities/Protected Veterans. BNY assesses market data to ensure a competitive compensation package for our employees. The expected base salary for this position when employment commences can be found in the Job Info section at the bottom of the posting. Base salary offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, and experience. Base salary is only part of the total rewards package, which may include eligibility for an annual discretionary incentive award. Subject to the terms and conditions of the applicable plans then in effect, eligible employees may enroll in a 401(k) plan as well as participate in Company-sponsored medical, dental, vision, and basic life insurance plans for the employee and the employee’s eligible dependents. Eligible employees also may receive other benefits (including various paid time off benefits, such as vacation and sick time), dependent on the position offered. Details of participation in these benefit plans will be provided if an employee receives an offer of employment. If hired, the employee will be in an “at will” position and the Company reserves the right to modify base salary (as well as any other discretionary payments or compensation programs) at any time, including for reasons related to individual performance, Company or individual department/team performance, and market factors.