Financial Analyst Intermediate

University of Kansas•Lawrence, KS

About The Position

The University of Kansas is hiring a Financial Analyst Intermediate to support budget planning, analysis, reporting, and financial systems work across the university. The role works with Budget Officers in schools and units to balance allocations to control totals, reviews allocations of new funds for compliance with Provost Office guidelines, and advises departmental budget representatives on budget preparation and maintenance. It also consults with university staff on budgeting, accounting, payroll fringes, and management issues, and organizes financial data for budget requests and appeals to the Board of Regents. The position extracts and manipulates data from university budget, accounting, and human resources files using multiple data tools. It develops and reconciles information for working budget preparation and other data collection, prepares ad hoc Oracle Analytics Cloud analyses and dashboards, and looks for ways to improve system functionality and business processes. Additional responsibilities include preparing state budget submissions and consolidated bond-related revenue reports, coordinating Administrative Overhead assessments, processing and validating budget transfers, and conducting training labs. The position performs other duties as requested by the Director of Budget Office. The work schedule is Monday through Friday, 8 a.m. to 5 p.m. KU describes the role as offering competitive salary and benefits, including paid vacation and sick leave, paid holidays, retirement, medical and dental insurance, life and disability insurance, other benefit plan options, vendor discounts, and educational opportunities for employees.

Requirements

Bachelor’s degree in business, accounting, information technology, economics, math, or a related field and three years of professional experience in data and/or financial analysis; alternatively, a high school diploma or GED and seven years of professional experience in data and/or financial analysis.
Five years of experience with KU financial systems or similar systems.
Two years of experience demonstrating proficiency in MS Office Suite products, including Excel skills such as VLOOKUPs and pivot tables.
Excellent analysis and problem-solving skills.
Experience writing SAS or SQL in SAS queries and coding programs for financial analysis.
Knowledge of Oracle budget solutions and PeopleSoft human resources software specific to the public sector.
Excellent written communication skills.
Demonstrated critical thinking skills.
Familiarity with the structure, policies, and procedures of the University of Kansas Lawrence campus.

Nice To Haves

Master’s degree in business administration or a related field.

Responsibilities

Work with Budget Officers in university schools and units to balance allocations to control totals.
Review budgets to verify that new fund allocations, including merit funds, follow Provost Office guidelines.
Guide departmental budget representatives in resolving budget preparation and maintenance issues.
Consult with university staff on budgeting, accounting, payroll fringes, and management problems; recommend and implement procedures using discretion and judgment.
Organize financial data for budget requests and appeals to the Board of Regents.
Use client-server and web-based fiscal management systems.
Extract and manipulate data from university budget, accounting, and human resources files using multiple data tools.
Develop and reconcile information for working budget preparation and other data collection purposes.
Prepare ad hoc Oracle Analytics Cloud analyses and dashboards.
Examine system functionality and improve business processes.
Assist with preparing the University’s Annual Budget Request to the state and prepare consolidated revenue reports for bond-related purposes.
Coordinate the University’s Administrative Overhead assessments.
Validate and process university budget transfers, ensure adherence to university policy, and correct issues.
Conduct training labs.
Perform other duties as requested by the Director of Budget Office.