Financial Analyst, Financial Information Office

Haslam College of Business

Regular Full-Time, Market Range 12

(Multiple Positions)

The Haslam College of Business at the University of Tennessee, Knoxville, invites applications for a full-time, exempt Financial Analyst in the Financial Information Office (FIO). Reporting to the Senior Financial Analyst, the Financial Analyst is primarily responsible for financial and budget reporting and analysis activities for the College. Primary responsibilities include comprehensive budget reporting, continuous monitoring of actuals versus budget, variance analysis, running financial scenarios and gauging their impacts on college operations, and ad hoc analysis and reporting. This position will work primarily with the new campus budget model (BAM) which will determine the future of the college resource management. Work in this role has major implications on future funding, forecasting and resource management.

Qualifications:

Responsibilities:

• Budget monitoring, reporting, and variance analysis
  • Produce and maintain financial and operating reports from Adaptive Insights, Excel, Access, Argos, PowerBI, Tableau and other software platforms
  • Provide detailed analysis of program budget reports to inform BAM model decision-making, forecasting, and scenario modeling
  • Summarize and consolidate periodic and annual reports for Department Heads and College leadership
  • Monitor, report, and analyze Profit & Loss statements
  • Analyze budget variances to determine cause, and work with departments to resolve issues
  • Identify and research trends and make adjustments to models
  • Present 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 modeling
  • Develop financial forecasts for projected year-end revenue totals, direct expenditures, key expenditures, etc.; 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
  • Develop and maintain various planning scenarios as requested by college management and by selecting own evaluation techniques
  • Develop and produce ad hoc analytical reports
  • Develop innovative solutions to BAM model scenario issues and problematic financial forecasts while adhering to university and campus policies and procedures
• Budget development and implementation
  • In collaboration with Senior Financial analyst, 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 plans
  • Gather data from various sources to use in developing budget inputs, scenarios, and plans
  • Routine budget reconciliation and maintenance as needed

Who We're Looking For:

• The Financial Information Office is looking for a detail-oriented financial professional who loves working with data and is an expert user of Excel and other database applications. The successful Financial Analyst is a creative thinker with the ability to create innovative reports and use data to find answers to complex questions.

Qualifications:

• Required Qualifications and Experience:
  • Bachelor's Degree with 2 years of professional finance or accounting experience
  • Experience with Microsoft Excel, databases, report writing 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.