General Information

Position Title: Budget Systems Analyst
Control Number: 001411
Reports To: 001254
Position Title Department Name
Budget Director Budget Office
Department Name: Budget Office
Location: Budget Office
Date Prepared: Sept-06
Exempt: Yes

Primary Purpose

Provides oversight of Position Control, Salary Planner and Hyperion reporting to ensure that all budget related modules are working effectively and efficiently; staff, within and particularily outside of the Budget Office, are trained in the use of the systems; the data have integrity; proper security is in place to prevent unauthorized access and processing; testing of systems upgrades are performed; and financial reporting is occurring timely and accurately. Develops and writes reports to be used by the user community and ad-hoc reporting for all areas as requested. Works collaboratively with all facets of the budget process.

Responsibilities

Works cooperatively with others and accepts direction from supervisors.

*Must be able to work cooperatively with others and accept direction from supervisors.

*Responsible for oversight and maintenance of budget aspects of Position Control. Manages Position Control data, identifies anomalies and provides on-going analysis of data.

*Establish and maintain procedures for Position Control. Works jointly with Human Resources and Controller's Offices. Establish and monitor a regular process, using forms and reports, to share salary budget information and to detect and correct variances.

*Manages Salary Planner and year-end budget roll

*Coordinate with Budget Analyst in areas of specially-funded salary budgets.

*Serve as Budget Office Lead on LEADS committee and college-wide reporting team.

*Develop and write reports to manage Position Control, Salary Planner and the Budget module. Provides reports to both users within and outside the Budget Office.

Oversees upgrades to Banner and Hyperion; coordinates testing plan, troubleshoots issues, works with Financial Systems Manger and LIS staff to investigate, implement and test new features and resolve issues.

*Assist budget administrators in understanding the budget system and monitoring revenues and expenses incurred, anticipate overspending problems

*Provide rationale of budget procedures and policies, offering guidance in strategies for individual departments and making recommendations to solve special situations

*Perform ongoing analysis of budgetary status and budgetary impact of supplemental needs and requests, prepare periodic and ad hoc analyses of budget versus actual for revenue and expenses, prepare supporting analysis of variance

*Assist users with questions and requests relating to budget and actual issues, and provide data via reports and spreadsheets.

Work with departments in managing on-line budget input process, editing budget requests and assuring submission deadlines are met

*Prepare and provide documentation and training in areas of Banner and report-writing as needed.

*Manage student assistants.

*Identify and act on opportunities to automate, streamline and improve reporting and budgeting procedures

Maintain Budget Office website.

*Performs other duties as assigned to assist the department in obtaining and maintaining its mission.

Education & Training

Bachelor's degree or equivalent progressive experience with financial details required.

Experience

Three or more years of experience managing financial information. Demonstrated experience with Excel databases, pivot tables and with SQL Query tool preferred. Experience with Banner and/or Hyperion preferred.

Knowledge

Strong verbal and written communication skills. Ability to articulate strategies and implement policies. Ability to organize and prioritize multiple projects.

Other

*Must have logical, analytical and problem-solving skills.

*Ability to work independently with minimal supervision

*Must have good interpersonal skills.

*Must handle confidential information with appropriate discretion.

* Denotes essential job functions.