Assistant Director, Treasury Planning (Hybrid) - Financial Services - Treasury Planning & Operations

Scheduled Hours

37.5

Position Summary

Treasury Services (“Treasury” or the “Group”) is comprised of three main functional areas: Treasury Planning & Operations, Insurance & Risk Management, and Student & Parent Loan Programs. Treasury manages the University’s banking, financial, and merchant services, which includes commercial/investment banking/financial vendor products, relationships, and accounts. Treasury manages the University’s in operating assets known as the Treasurer’s Investment Pool (“TIP”), as well as the strategy, operation, and performance of the University’s external long-term debt portfolio and the Internal Bank. The management of TIP includes assessing liquidity levels and working capital through forecasting, recommending appropriate asset allocations, and evaluation of investment options. The Group monitors and projects the University’s cash flow, as well as manages all operating lines of credit and a taxable commercial paper program. Debt management includes market analysis, modeling, issuance, compliance, credit strategy, and management of the Internal Bank. Treasury maintains a collaborative and productive relationship with the WashU Investment Management Company (“WashU IMC”) and ensures that the University’s strategic and tactical liquidity and funding needs are met. Treasury collaborates with finance and campus stakeholders on capital planning and provides oversight of the financial aspects and reporting of the University’s consolidated capital plan. Treasury provides regular updates throughout the year to the WashU IMC Board and other standing committees of the Board of Trustees.

The Assistant Director, Treasury Planning (“Assistant Director”), reports directly to the Director, Treasury Planning & Operations (the “Director”), and is responsible for producing and managing analytics and reporting to support financial decision-making and strategy for Treasury matters. The Assistant Director serves as an integral member of the Director’s team and works with colleagues throughout Treasury Services, as well as various finance and accounting colleagues and campus stakeholders to provide the Treasurer, the CFO, and members of executive leadership with timely and accurate analytics and reporting. The Assistant Director will develop and maintain an in-depth understanding of WashU’s Internal Bank, the Treasurer’s Investment Pool (TIP) and their components, credit and balance sheet strategies, and capital and resource planning. Therefore, the Assistant Director will need to develop a comprehensive understanding of WashU’s institutional goals and support how they relate to the administration and operation of areas within Treasury and vice versa. In addition, the Assistant Director will partner and collaborate with the Senior Financial Projects Analyst to provide day-to-day financial management and reporting of the University’s consolidated capital plan, as well as reporting and tracking of central reserves and resources. The Assistant Director will have expert-level proficiency in developing and utilizing proprietary models and tools. The Assistant Director will be adept at utilizing the University’s enterprise financial system (Workday) and other sources of data. The position supervises one Financial Analyst.

Job Description

Modeling, Analytics, and Reporting

• Create and maintain complex proprietary Treasury financial models and reports.

• Develop, maintain, and enhance models for short-term and long-term cash flow forecasts to support liquidity and Treasury planning. In collaboration with the Associate Director of Treasury Operations, investigate variances to facilitate strategic decision making. Recommend practice improvements that will lead to greater efficiency of funds utilization.

• Collaborate with internal stakeholders to source, analyze, and improve complex data sets, including creating new Workday reports and enhancing existing ones.

• Perform analysis to determine the liquidity needs for University operations and the excess liquidity that can potentially be invested in longer-term investments.

• Supervise one Financial Analyst, including providing technical and knowledge training and guidance, managing projects and timelines, and reviewing models, reports, and other work products in alignment with priorities from the Director and the Treasurer.

• Prepare materials and analyses for use by senior management and for presentation to various standing committees of the Board of Trustees. Translate data and analysis into clearly articulated actionable insight.

• Prepare materials and analyses that will be used by financial management to communicate with senior leadership, debt rating agencies and financial institutions.

• Develop an in-depth understanding of the University’s internal bank and its overall portfolio and portfolio characteristics.

• Manage and improve the University’s credit model, debt repayment model, and other proprietary financial models for historical analysis, forecasting, scenario/sensitivity analysis, and data management. Prepare analyses of the University’s current external and internal debt capacity and create projections of future debt capacity and credit rating based on rating score methodologies utilized by rating agencies.

• Perform other responsibilities and duties, as requested.

Capital Planning & Analytics, Central Resources

In partnership and collaboration with the Senior Financial Projects Analyst:

 

• Develop and maintain comprehensive consolidated capital plan model and tools to steward the University’s long range capital plan.

• Assist with establishing and managing capital plan process, governance, and coordination of capital-related information with Facilities, School of Medicine, Real Estate, Information Technology, and other stakeholders.

• Conduct complex strategic analysis of the capital budget, within the context of overall institutional objectives and financial constraints.

• Analyze impacts of funding and financing of different capital initiatives and provide recommendations to leadership.

• Create and support comprehensive Treasury reporting, including preparation of materials for Board and management presentations.

• Manage the data stack and analysis for capital expenditures based on the University's projected capital plan and capital project initiatives.

• Create and maintain executive level dashboards, KPIs, and reporting for the Chancellor, including data and metrics on various reserves/resources.

• Prepare ad hoc reports for the Board and management as requested.

• Perform other responsibilities and duties, as requested.

Additional responsibilities and other projects:

• Prepare other analyses and presentation materials as needed for the Treasurer, Chief Financial Officer and other senior leaders.

• Interface with Accounting, Real Estate, Office of General Counsel, Schools and Departments, and any other relevant internal and external contacts on real estate transactions. Review strategic real estate portfolio listing and initiatives.

• Meet with the Director generally weekly to report on and discuss issues, review analyses and reports. Also meet with the Director or the Treasurer periodically to discuss issues, review analyses and reports.

• Provide technical training to Treasury staff.

• Identify and implement process and modeling improvements through automation, reporting enhancements, and system optimization to enhance efficiency, accuracy, usability/readability, and risk controls.

• Work with other Treasury staff to develop, maintain, and improve various proprietary financial models.

• Provide back up for other Treasury functions, as needed.

• Provide analytical support as assigned by the Director or the Treasurer to initiatives that support the institution’s goals, such as educational loan programs and insurance and risk management programs, developing and managing complex financial models and collaborating cross-functionally.

• Lead or engage in special projects which may include initiatives that support the department or the broader University, as assigned by the Director and/or the Treasurer.

• As opportunities arise, coordinate with IT and Workday teams to obtain, analyze, and enhance data, reports and other tools.

• Perform other duties as assigned.

Working Conditions:
Job Location/Working Conditions

• Normal office environment.

• Hybrid work arrangement.

Physical Effort

• Typically sitting at a desk or table.

• Repetitive wrist, hand or finger movements.

• Ability to move to on and off campus locations.

Equipment

• Office equipment.

The above statements are intended to describe the general nature and level of work performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all job duties performed by the personnel so classified. Management reserves the right to revise or amend duties at any time.

Required Qualifications

Education:

Bachelor's degree

Certifications/Professional Licenses:

No specific certification/professional license is required for this position.

Work Experience:

Relevant Experience (5 Years)

Skills:

Not Applicable

Driver's License:

A driver's license is not required for this position.

More About This Job

Preferred Qualifications:

• Exceptional Excel skills: financial modeling and forecasting, complex formulas, scenario analysis, automation and data management using VBA and Python.
• Five to seven years of relevant experience.
• Experience in accounting/finance/banking/credit.
• Experience with SQL and Python (or other programming language).
• Supervisory or mentoring experience.
• Experience writing reusable and maintainable code with version control, ability to transform a project from POC to production.

Preferred Qualifications

Education:

M.B.A. - Master of Business Administration, Master's degree

Certifications/Professional Licenses:

No additional certification/professional licenses unless stated elsewhere in the job posting.

Work Experience:

Professional Accounting/Budget/Finance (5 Years)

Skills:

Accounting, Analytical Thinking, Confidential Data Handling, Cross-Team Collaboration, Deadline Management, Detail-Oriented, Ethical Practices, Financial Analysis Reporting, Financial Forecasting, High-Integrity, Interpersonal Effectiveness, Microsoft Excel VBA Programming, Personal Initiative, Prioritization, Process Improvements, Project Coordination, Python (Programming Language), Quantitative Aptitude, Report Writing, Service Oriented, Structured Query Language (SQL), Supervisory Management, Taking Ownership, Workday Software, Working in a Fast-Paced Environment

Grade

G15

Salary Range

$84,200.00 - $148,500.00 / Annually

The salary range reflects base salaries paid for positions in a given job grade across the University. Individual rates within the range will be determined by factors including one's qualifications and performance, equity with others in the department, market rates for positions within the same grade and department budget.

Questions

For frequently asked questions about the application process, please refer to our External Applicant FAQ.

Accommodation

If you are unable to use our online application system and would like an accommodation, please email CandidateQuestions@wustl.edu or call the dedicated accommodation inquiry number at 314-935-1149 and leave a voicemail with the nature of your request.

All qualified individuals must be able to perform the essential functions of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees with disabilities to perform the essential functions of their job, absent undue hardship.

Pre-Employment Screening

All external candidates receiving an offer for employment will be required to submit to pre-employment screening for this position. The screenings will include criminal background check and, as applicable for the position, other background checks, drug screen, an employment and education or licensure/certification verification, physical examination, certain vaccinations and/or governmental registry checks. All offers are contingent upon successful completion of required screening.

Benefits Statement

Personal

• Up to 22 days of vacation, 10 recognized holidays, and sick time.

• Competitive health insurance packages with priority appointments and lower copays/coinsurance.

• Take advantage of our free Metro transit U-Pass for eligible employees.

• WashU provides eligible employees with a defined contribution (403(b)) Retirement Savings Plan, which combines employee contributions and university contributions starting at 7%.

Wellness

• Wellness challenges, annual health screenings, mental health resources, mindfulness programs and courses, employee assistance program (EAP), financial resources, access to dietitians, and more!

Family

• We offer 4 weeks of caregiver leave to bond with your new child. Family care resources are also available for your continued childcare needs. Need adult care? We’ve got you covered.

• WashU covers the cost of tuition for you and your family, including dependent undergraduate-level college tuition up to 100% at WashU and 40% elsewhere after seven years with us.

For policies, detailed benefits, and eligibility, please visit: https://hr.wustl.edu/benefits/

EEO Statement

Washington University in St. Louis is committed to the principles and practices of equal employment opportunity. It is the University’s policy to provide equal opportunity and access to persons in all job titles without regard to race, ethnicity, color, national origin, citizenship (where prohibited by federal law), age, religion, sex, sexual orientation, gender identity or expression, disability, protected veteran status, or genetic information.