Job Summary or Scope: What is the fundamental purpose(s) of this position?
This position provides oversight and responsibility for a wide variety of financial duties for Flight Training Department, Prescott Campus. The position is responsible for budgeting (including expenditures and revenues), track capital planning and purchases, performing campus accounting coordination, preparation and review of financial reports, monitoring fiscal transactions, as well as preparing periodic and on-demand financial reporting/analysis for current and future flight department activities.
Plan, organize, and coordinate a direct overall budget operation associated with the flight training department, managing overall revenue and expense budgets of up to $10-$12 Million.
Prepare, consolidate, and administer revenue and operating budgets down to the transaction level.
Monitor and reconcile all budgets in detail on a monthly basis or as required by Chair, Flight Department.
Provide contract expenditure tracking for specialized programs such as USAF Summer Flight Program and STEM outreach events for the Flight Training department and associated with providing flight training in a collegiate environment.
Maintain data histories and develop cost analysis to provide support and recommendation or new investment and/or expenses.
Monitor and report on various business metrics, e.g. flight revenue hours, aircraft utilization.
Process budget transfers and budget re-forecasts.
Prepare revenue and expense forecast for annual budgets and monthly budget status reports showing variances as well as quarterly, annual and other periodic financial reports requested by management.
Provide leadership for Administrative Assistant to Chief Flight Instructor in relations to those duties for reporting IP pay, expenses and expenditures by that area of the flight department.
Assist Maintenance Department in the tracking and execution of budgeted funds, including, but not limited to, purchase order preparation, engine fund accounting, and seasonal expenses.
Act as liaison to COA, Campus Budget Director, and Chief Business Officer for financial matters.
Organize and attend budget review meetings within the department, COA, and Prescott Campus.
Analyze financial data and develop financial forecast, plans, processes, reports, statement, and recommendations so that area managers and other management have timely financial information to aid decision making.
Provide support and pertinent input to flight department chairman on general issues and concerns related to flight operations.
Develop and implement timelines, schedules, and procedures for financial processes within the Flight Department; fully coordinate these efforts with affected offices on campus and UA as appropriate.
Perform data extraction and manipulation of data from ETA, RMS, Oracle and other resources into various reports and models.
Required skills, knowledge, abilities:
Knowledge of accounting and budgeting equivalent to an Bachelor’s Degree (or higher), in accounting or related field
Hands on experience with processing transactions in an accounting or budgeting software
Proficiency with entire MS Office Suite
Knowledge of aircraft, airline or flight training
Experience with Oracle — Required
Advanced Excel skills including data extraction, advanced & complex formulas, Pivot tables, financial & operational model building in Excel, advanced charting and graphing
Highly Desired skills, knowledge, abilities:
Higher education experience
Knowledge of PowerPivot and Oracle BI