Assistant Director, Treasury Planning (Hybrid) - Financial Services - Treasury P

* 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.* 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.* 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.* Typically sitting at a desk or table.* Repetitive wrist, hand or finger movements.* Ability to move to on and off campus locations.* 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.* 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%.* 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.Washington University in St. Louis' collective success is significantly attributed to the passion and outstanding efforts of our community. Our staff, faculty and trainees are committed to excellence and dedicated to carrying out our missions of research, teaching and patient care.WashU prides itself on being a place where people matter, and serious work is done. Our people work together in an inclusive community that celebrates diverse perspectives, collaboration and innovation. We are a community of individuals inspired to work together to develop big ideas and tackle challenging problems.We value the well-being of our people. WashU strives to create a positive employee experience where staff, faculty and trainees thrive, both personally and professionally. Our employees find meaning, connection and vitality in their work and life with a healthy work-life balance and support to learn, grow and make an impact at WashU, the community and the world.**Useful Links****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.**Regulatory Postings**Know Your Rights: Workplace Discrimination is Illegal Poster(; ) #J-18808-Ljbffr