Manager, Long-term Financial Modelling & Planning (Term - 18 Months)

Job Category

Job Profile

Job Title

Department

Compensation Range

The Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the range is approximately halfway between the minimum and the maximum and represents an employee that possesses full job knowledge, qualifications and experience for the position. In the normal course, employees will be hired, transferred or promoted between the minimum and midpoint of the salary range for a job.

Posting End Date

Note: Applications will be accepted until 11:59 PM on the Posting End Date.

Job End Date

At UBC, we believe that attracting and sustaining a diverse workforce is key to the successful pursuit of excellence in research, innovation, and learning for all faculty, staff and students. Our commitment to employment equity helps achieve inclusion and fairness, brings rich diversity to UBC as a workplace, and creates the necessary conditions for a rewarding career.

Job Summary

UBC Treasury is responsible for the safeguarding and leveraging of the University's financial assets, including working capital, external and internal debt, and endowments. Treasury administers key fiscal programs, oversees cash management and forecasting, and is responsible for strategic financial planning and analysis. In addition, they facilitate financing for UBC capital projects and act as the internal bank of the university. The VP Finance & Operations portfolio oversees UBC's physical and financial assets.

The Manager, Long-Term Financial Modelling and Planning supports the long-term financial sustainability and strategic decision making of the University by developing and maintaining a long-term corporate model projecting UBC's financial results for at least the next 5 years. Further, the Manager will maintain financial reports, key performance metrics and analysis to present to the Finance Leadership Team and Executive Leadership team to support decision making purposes within the University's budget. This position will support the analysis of UBC's strategic financial initiatives through complex and comprehensive models that analyze and forecast the financial impact of strategic decisions, management of strategic funds and capital planning and investments.

Organizational Status

Reporting to the Director, Long-Term Financial Modelling and Planning, the Manager, Long-Term Financial Modelling and Planning is a key member in Treasury team. The position will work closely with all members in the Treasury team and partner with other finance departments, other finance leads within the University and regularly interact with external parties and University related entities such as UBC Properties Trust & UBC Investment Management.

Work Performed

1. Manages and provides oversight, under the supervision of the Director, on the development and management of the University's long-term financial forecast model projecting UBC's long-term financial status on a consolidated and operating basis, together with key financial metrics. This model will be updated regularly based on new data and insights to ensure relevance and accuracy in long-term decision making.
2. Develops complex financial models and evaluates a broad range of strategic initiatives that provide economic benefit to the University, including the financial impact on financial statements and UBC's budget. The financial models will be prepared to assess the financial impacts on new and existing strategic projects.
3. Develops and evaluates options and alternatives on strategic decisions that impact the university's long-term financial results. Assists the University executives on understanding the financial implications and potential risks of the overall strategic plan including the long-term financial operating results, balance sheet and liquidity position through financial models and analysis.
4. Plan, implement and oversees strategic assumptions and inputs into the long-term financial forecast model. Ensures that source data utilized for the model and key performance indicators is correct and/or reasonable, and the data gathering process is transparent and efficient.
5. Develops presentations and reports for senior leaders and executives on financial modelling results, potential financial impacts on both the university's operating results and liquidity, along with risks and insights. Responsible for presenting the information detailed on the presentation and reports.
6. Provides long-term financial forecast performance metrics, scenario and variance analyses to the UBC executives on a regular basis based on the long-term financial forecast model.
7. Researches, analyzes and validates complex financial data, information, and assumptions for input into the financial forecast model and for use in key performance indicators.
8. Works closely with Financial Reporting, Budgeting, and Faculty/Business Unit financial teams to gather financial information and validate financial modelling output.
9. Maintains regular communication with key stakeholders across the university to ensure that financial assumptions are valid and reflect long-term University strategy and plans.
10. Develops and maintains relationship with internal and external stakeholders for the purpose of building and updating financial models.
11. Provides daily operational leadership and supervision to the Long-Term Financial Modelling and Planning team, including talent development, coaching, performance management and mentorship.
12. Develops individual development plans for direct reports, ensuring continued professional growth and alignment with Treasury's and the VPFO's strategic goals.
13. Represents Treasury on various committees, as required.
14. Performs other duties as required.

Consequence of Error or Judgment

Any errors in assessment could materially impact the planning, decision making and financial viability of central operations, faculties, and departments. Inaccurate financial modelling, projections and forecasts may lead to mismanagement of resources, which could result in significant financial losses and negatively impact UBC's ability to perform and uphold its reputation as a world class institution.

Failure to provide adequate short and long term strategic financial planning advice would undermine the ability of the VP, Finance and Operations to set and implement priorities for allocation of resources, making it difficult to achieve the educational and research mandate for the University. Failure to provide sound strategic advice and effective leadership on financial policy and systems together with timely and accurate financial advisement would damage the reputation of the Treasury department and its ability to effectively manage its relationships with the departments.

Supervision Received

Works independently and with full professional latitude towards broad mandates. Reports to the Director, Long-Term Financial Modelling & Planning in respect of the achievement of strategic goals. Liaises with all levels within the University Community (including VPs, Deans & AVPs) and external parties on a regular basis. Performance subject to periodic review for soundness of judgement, leadership, overall effectiveness and attainment of objectives.

Supervision Given

Provides guidance to other Treasury professionals as required. Provides direction to external investment managers and consulting professionals.

Minimum Qualifications

Undergraduate degree in a relevant discipline. Completion of the CPA accounting program (CA, CGA or CMA). Minimum of nine years of related experience, or the equivalent combination of education and experience.

- Willingness to respect diverse perspectives, including perspectives in conflict with one's own

- Demonstrates a commitment to enhancing one's own awareness, knowledge, and skills related to equity, diversity, and inclusion

Preferred Qualifications

• Experience in finance, post-secondary education or health care sectors preferred.

• Experience in developing and managing complex long-term organizational financial forecast models. Experience working collaboratively with Senior Leadership and Management and other professionals. Demonstrated knowledge and expertise in highly complex and technical financial concepts and instruments. High proficiency with MS Excel, Power Point and Word including complex spreadsheet, data warehousing and business intelligence tools.

• Be able to work well under pressure, prioritize tasks to meet deadlines and demonstrate a high degree of accuracy.

• Excellent written, verbal and presentation skills. Ability to communicate complex financial concepts in an understandable manner to non-financial savvy personnel.

• Demonstrate strong interpersonal, problem-solving, planning and organizational skills.

• Strategic mindset and ability to evaluate and apply complex financial concepts to develop and maintain financial strategies.

• Strong understanding of Generally Accepted Accounting Principles (GAAP) principles and ability to apply knowledge to UBC and its related entities.

• Work both independently and in a team environment.

• Strong understanding of the high-level financial structure of the University