Public Finance Waterfall Modeling Team Lead - Global Capital Markets Quantitative Risk Analyst

M&T Bank•Wilmington, DE

2d•$136,000 - $226,600•Onsite

About The Position

The Public Finance Waterfall Modeling Team Lead will establish and lead a centralized modeling function responsible for translating complex transaction-specific waterfall provisions into standardized, controlled, and operationally-ready templates. This role will serve as the subject matter expert for document interpretation, financial modeling, quality control standards, and workflow governance across Public Finance transactions. The individual will build the team's methodology, establish model standards, oversee quality assurance processes, and ensure all approved models are accurate, traceable, and compliant with operational and risk requirements. The role will work closely with Relationship Managers, Transaction Administration teams, Product, Legal, and Risk partners. This position combines deep Public Finance expertise, advanced financial modeling capabilities, operational leadership, and control discipline.

Requirements

Bachelor’s degree, OR in lieu of degree, A combined minimum of 11 years higher education and/or work experience to include a minimum of 7 years relevant experience.
Master’s degree in Mathematics, Statistics, Quantitative Analysis or another technical discipline, with minimum of 5 years relevant experience or in lieu of degree, a combined minimum of 11 years higher education and/or work experience to include a minimum of 5 years relevant experience.
Minimum of 7 years relevant experience
Banking or Financial Services experience
Experience with SAS, SAS Enterprise Miner and other Statistical Software Packages.
Advanced Knowledge of SQL and Microsoft Office.
Ability to utilize analytics in a collaborative manner across business functions and product lines to derive optimum solutions.
Demonstrated ability to communicate complex concepts.
Demonstrated ability to manipulate and analyze data across large databases.

Nice To Haves

Public Finance Expertise
Deep understanding of municipal/public finance transactions
Ability to interpret trust indentures, bond resolutions, loan agreements, and related governing documents
Knowledge of payment priorities, fund flows, reserve requirements, debt service structures, and waterfall provisions
Strong understanding of transaction administration and operational controls
Financial Modeling & Analytics
Advanced Excel modeling skills
Ability to design, build, validate, and maintain complex financial waterfall models
Experience with formula-driven calculations, conditional logic, triggers, shortfalls, allocations, and scenario testing
Strong attention to mathematical accuracy and model integrity
Risk & Controls
Experience establishing quality assurance and quality control frameworks
Strong understanding of model governance, version control, auditability, and operational risk
Ability to create standardized processes and controls
Experience performing independent reviews and validation testing
Leadership & Process Design
Ability to build and lead a new capability from inception
Develop methodologies, standards, procedures, playbooks, and training materials
Establish intake, workflow, prioritization, governance, and escalation frameworks
Drive continuous improvement and operational efficiency
Stakeholder Management
Partner with Relationship Managers, Transaction Administration teams, Product, Operations, Risk, and Legal stakeholders
Navigate ambiguity and resolve complex document interpretation issues
Strong communication skills with ability to explain complex modeling concepts to non-technical audiences

Responsibilities

Analyze transaction governing documents including trust indentures, resolutions, loan agreements, and related legal documentation.
Interpret waterfall provisions, payment priorities, formulas, triggers, conditional transfers, residual distributions, and replenishment mechanics.
Design, build, and approve standardized waterfall templates and models.
Ensure all calculations and model outputs are fully traceable to governing source documents.
Establish standards, processes, methodologies, and governance frameworks for the centralized Waterfall Modeling function.
Build and manage a library of standardized template components and modeling tools.
Provide coaching, training, and oversight to model analysts.
Develop operating procedures and performance metrics.
Implement rigorous quality assurance and independent review processes.
Establish model validation, scenario testing, and release controls.
Ensure compliance with internal risk management, End User Computing, and records management standards.
Escalate document ambiguities and interpretation issues through appropriate Product and Legal channels.
Manage intake, prioritization, workflow, and service delivery processes.
Develop complexity tiering and approval frameworks.
Monitor quality, turnaround times, utilization, and operational effectiveness.
Drive continuous improvement initiatives and standardization efforts.
Partner with Relationship Managers, Operations, Product, Legal, and Risk stakeholders.
Conduct model handoff sessions and user education.
Provide subject matter expertise for new transaction structures and complex deals.