Vice President, Financial Modeler/Engineer

BNY Mellon; Pittsburgh (Allegheny County); On-site; USD 150,000 - 230,000; Full time

Job summary

BNY Mellon in Pittsburgh, PA seeks a Vice President, Financial Modeler/Engineer to drive advanced modeling within Corporate Trust Analytics Solutions. You will design structured finance models, integrate data via SQL and VBA, and produce investor reports.

You will lead modeling projects, mentor junior staff, and collaborate across teams to implement new processes and technologies, including AI tools to increase accuracy and efficiency.

Qualifications

• Bachelor's degree or equivalent required.
• 5+ years of relevant experience preferred.
• Strong analytical and project leadership skills.
• Proficiency in Excel formulas, VBA and SQL scripting.
• Knowledge of structured finance and AI tools (e.g., ChatGPT, Copilot) is preferred.

Responsibilities

• Develop structured finance models to evaluate asset performance and cash flows.
• Use SQL, VBA, and related tools to extract data and populate models.
• Lead modeling projects and mentor junior analysts.
• Communicate insights clearly to management and senior leaders.

Skills

SQL scripting

Excel formulas

VBA

Analytics leadership

Power BI

Education

Bachelor's degree or equivalent

Tools

Power BI

Microsoft Access

VB.NET

PowerShell

Python

ChatGPT

Copilot

SSRS

Job description

We're seeking a future team member for the role of Vice President, Financial Modeler/Engineer to join our Corporate Trust Analytics Solutions team. This role is located in Pittsburgh, PA.

In this role, you'll make an impact in the following ways:

1. Model Development & Technology

• Develop structured finance models to evaluate asset performance, client and securities data, cash flows, waterfalls, portfolio criteria, and asset eligibility, and produce investor reports.
• Use SQL, queries, macros, and related tools to extract data and populate models, including light programming or system configuration as needed.
• Partner with management to evaluate and select technologies for modeling and analysis.
• Apply AI tools to improve the efficiency and accuracy of deliverables.

1. Analysis & Communication

• Interpret analytical findings, prepare standard and ad hoc reports, present results to management and senior leaders, and recommend appropriate actions.
• Explain complex technical concepts and analyses clearly to nontechnical audiences.
• Review reports and calculations prepared by less experienced colleagues for accuracy.

1. Project & Team Leadership

• Lead modeling projects and mentor less experienced colleagues.
• Lead complex cross-functional or enterprise-wide projects that support new or evolving processes, products, and initiatives.
• Oversee junior modelers and contribute to performance assessments without direct supervisory responsibility.

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

• A bachelor's degree or an equivalent combination of education and experience.
• Five or more years of relevant experience is preferred.
• Strong analytical and project leadership skills.
• Proficiency in Microsoft Excel formulas, VBA and SQL scripting is required.
• Knowledge of structured finance, AI tools such as ChatGPT and Copilot, Power Apps, Microsoft Access, VB.NET, PowerShell, Power BI, SSRS, and Python is preferred.

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.