Description

SENIOR FINANCIAL ANALYST, FINANCIAL INFORMATION OFFICE

 

Regular Full-Time, Market Range 12

The Haslam College of Business at the University of Tennessee, Knoxville, invites applications for a full-time, exempt Senior Financial Analyst in the Financial Information Office (FIO).  The Senior Financial Analyst provides analytical and accounting support for financial, budgeting, planning and reporting activities for the College.  The primary responsibilities of this position include budget development and implementation, continuous monitoring of actuals versus budget, variance analysis, running financial scenarios and gauging their impacts on college operations, standard periodic (monthly) managerial reporting, and ad hoc analysis and reporting.  This position will report to the Assistant Director and supports the managerial financial decision-making of the college. This position will work primarily with the new campus budget model (BAM) which will determine the future of the college resource management. This is an important role that has major implications on future funding, forecasting and resource management. This position supports the managerial decision-making of the Dean and the Dean's Cabinet.

The Senior Financial Analyst will be the subject matter expert regarding use of the Adaptive Insights budgeting and forecasting tool for the college, and will be responsible for developing and managing the reporting capabilities of the tool.  The financial analyst will also be the primary point of contact for data gathering requests and analysis of the gathered data, including being able to identify and pull data from various sources such as IRIS, BW, OIRA, HR, Enrollment Management, and others.

Responsibilities:

• Budget monitoring, reporting, and variance analysisProduce and maintain financial and operating reports from Adaptive Insights, Excel, Access, Argos, PowerBI, Tableau and other software platforms
Analyze and produce actuals vs budget variance reports on revenue sources, personnel expenditures, operating expenses, allocated expenses from support units, support from endowment and gift accounts, and reserve fund balancesProvide expert advice and guidance to college management regarding the impacts and implications of the variance analysesIdentify and research trends and make adjustments to modelsMake adjustments to forecasts, long-range plans, and scenario models to account for the impacts of the variancesPresent budget issues and develop innovative solutions to solve complex budgeting issues while adhering to university and campus policies and proceduresPresent adhoc analysis based on own evaluation and analysis of policies and procedures and how they affect the budget and financial goals of the College using own methods of professional discretion 

Developing financial forecasts and scenario modelingDevelop financial forecasts for projected year-end revenue totals, direct expenditures, key expenditures such as financial aid and waivers; update forecasts monthly to keep college management up-to-date on year-end projections for operating margins, surpluses or deficits, and reserve balances

Develop and maintain long-range (five year) plans in Adaptive Insights; make periodic adjustments as required by changing operating expectations, shifting university strategic priorities, or external economic conditionsDevelop and maintain various planning scenarios as requested by college management and by selecting own evaluation techniques, such as enrollment figures significantly above or below target expectations, implementation of new academic programs, or possible impacts of increasing online courses and enrollments or other figures and targets as so determined based on own evaluation and analysisDevelop and produce ad hoc analytical reports as such as departmental year-to-date comparisons of student credit hours, faculty FTEs, majors, general education courses taught, endowment income spending, etc.Develop innovative solutions to BAM model scenario issues and problematic financial forecasts while adhering to university and campus policies and procedures

Budget development and implementationServe as the subject matter expert (SME) for the college on the use of the Adaptive Insights budgeting and planning tool

In collaboration with the Budget Director, develop and enter the annual budget for the college, including the uploading and downloading of budget information to and from the ERP system (IRIS)Attend and participate in annual budget meetings to gather data to use in developing budget inputs, scenarios, and plansGather data from various sources to use in developing budget inputs, scenarios, and plansProduce and maintain standard financial reports from Adaptive Insights, Excel, Access, and other software platformsProduce adhoc financial reports using own method by determining areas of budgetary inconsistencies

Qualifications
Qualifications:

 

Required Qualifications and Experience:

• Bachelor's Degree with 5 to 8 years of professional finance or accounting experience to include 5 years experience with financial analysis, budgeting, and modeling; experience with Microsoft Excel, databases, report writing software and ERP systems.
• -OR-
• Master's Degree with 3 to 5 years of professional finance or accounting experience to include 3 years experience with financial analysis, budgeting, and modeling; experience with Microsoft Excel, databases, report writing or similar software; and ERP Systems.

Desired Qualifications and Experience:

• Master's Degree
• Higher education experience
• Experience with SAP
• Experience with fund accounting and non-profit or governmental reporting

 

Knowledge, Skills and Abilities:

 

Required:

Possess exceptional computer and analytical skills with the ability to translate raw data into information and knowledge through the use of reports and graphical displays.  Knowledge of data warehouse methodologies, data modeling, and analytics.  Must be proficient in Microsoft Excel and be familiar with software such as PowerBI, PowerQuery, Argos, Crystal Reports or Tableau.  Must possess organizational skills; strong oral and written communication skills with the ability to communicate effectively with internal and external management and college faculty and staff; the ability to manage projects and facilitate successful and timely completion; must be self-motivated and able to self-direct the work.

Preferred:

A working knowledge of SAP or other (ERP) software and the related data warehouse reporting component is preferred.Ability to supervise and direct the work of others.

Application Process:

The Knoxville campus of the University of Tennessee is seeking candidates who have the ability to contribute in meaningful ways to the diversity and intercultural goals of the University. Screening of applicants will begin immediately and will continue until the position has been filled.

 

Interested individuals should provide a cover letter addressing professional experience relevant to each required minimum qualification, a resume, and complete contact information for 3 professional references.

All qualified applicants will receive equal consideration for employment and admissions without regard to race, color, national origin, religion, sex, pregnancy, marital status, sexual orientation, gender identity, age, physical or mental disability, or covered veteran status.

Eligibility and other terms and conditions of employment benefits at The University of Tennessee are governed by laws and regulations of the State of Tennessee, and this non-discrimination statement is intended to be consistent with those laws and regulations.

In accordance with the requirements of Title VI of the Civil Rights Act of 1964, Title IX of the Education Amendments of 1972, Section 504 of the Rehabilitation Act of 1973, and the Americans with Disabilities Act of 1990, The University of Tennessee affirmatively states that it does not discriminate on the basis of race, sex, or disability in its education programs and activities, and this policy extends to employment by the University.

Inquiries and charges of violation of Title VI (race, color, national origin), Title IX (sex), Section 504 (disability), ADA (disability), Age Discrimination in Employment Act (age), sexual orientation, or veteran status should be directed to the Office of Equity and Diversity (OED), 1840 Melrose Avenue, Knoxville, TN 37996-3560, telephone (865)974-2498 (V/TTY available) or 974-2440. Requests for accommodation of a disability should be directed to the ADA Coordinator at the Office of Equity and Diversity.

 

 

 

Job: Other Professional
Primary Location: US-Tennessee-knoxville
Organization: Administration-Hcb Admin
Schedule: Full-time
Job Posting: Jun 3, 2021, 10:24:16 AM