Public Finance Waterfall Modeling Team Lead - Global Capital Markets Quantitative Risk Analyst
Wilmington Trust N.A. • Wilmington, US
Overview:
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.
Primary Responsibilities:
Waterfall Modeling & Document Interpretation
- 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.
Team Leadership & Capability Development
- 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.
Quality Control & Risk Management
- 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.
Operational Excellence
- 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.
Cross-Functional Partnership
- 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.
Education and Experience Required:
- 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.
- -OR- 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.
Education and Experience Preferred:
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
#LI-RS1
M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $136,000.00 - $226,600.00 Annual (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.
Location:
Wilmington, Delaware, United States of America
Great companies have an enduring sense of purpose. At M&T, our purpose is a simple one: make a difference in people’s lives and uplift the communities we serve. M&T Bank Corporation is a financial holding company headquartered in Buffalo, New York. M&T’s affiliates offer advice, guidance, expertise and solutions across the entire financial spectrum, combining M&T Bank’s traditional banking services with the wealth management and institutional capabilities offered by Wilmington Trust. M&T Bank has a network of over 1,000 branches and 2,200 ATMs that span 12 states from Maine to Virginia and Washington, D.C. For more than 165 years, M&T has strived to take an active role in our communities and build long-lasting relationships with our customers. We are a bank for communities—combining the capabilities of a large bank with the care of a locally focused institution. As an employer of choice, we are proud to offer competitive benefits ranging from medical and retirement to forty hours of paid volunteer time, each year. Our core values – integrity, ownership, collaboration, curiosity, and candor – drive the work we do. We seek to further build upon our record of success by bringing in top talent and fresh skill sets while continuing to support the growth and development of all our team members. View M&T’s Human Capital Report to learn more. Ready to join our team? Submit your application today! If you are unable to apply through this site due to technical issues or need an accommodation to apply, please contact us at [email protected] for assistance. M&T Bank is unwavering when it comes to providing equal employment opportunities to all employees and applicants without regard to race, color, national origin, religion, ethnicity, sex, gender identity, age, disability, citizenship, pregnancy, veteran status, military status, marital status, sexual orientation, genetic information or any other characteristic protected under applicable federal, state or local laws. M&T Bank Corporation has policies and procedures in place to promote a drug free workplace. Career Site Privacy Notice
