Sr. Capital Program Budget and Data Analyst

GENERAL SUMMARY

The Senior Budget and Data Analyst will report to, and work directly with, the Director, Capital Program. In this role, the Senior Analyst will assist in managing the IAA’s Capital Program, which includes the IAA’s multi-year $1+ billion capital budget and the FAA-AIP funded Airport Capital Improvement Program (ACIP). This role will be responsible for monitoring Planning and Development’s department operating budget, ensuring budget compliance of the entire capital program, including budget preparation, budget reporting, short-term and long-term cashflow requirements, invoice and purchase order processing, and disbursements.

This position will prepare capital budget reports and meaningful dashboards to aid Planning and Development leadership in monitoring the program. Provide deep analysis of data related to the capital program and determine the best way to represent the information visually to Managers, Directors, and stakeholders. The Senior Budget and Data Analyst will ensure the quality in the data and help define key performance metrics for the program. They will assist in the annual preparation of the 5-Year Capital Improvement Program and the monthly distribution of the Capital Cash Flows. They will assist in developing advanced analysis for operating expenditures and capital programs, useful lives of assets, funding sources of the program, and enhanced cash-flow forecasting on a short-term and long-term basis. This position will manage the Capital PO system to ensure that contracts are within the approved budget, ensure all required approvals have been obtained and all required information is entered into the system in a timely and accurate manner. This position will help research and analyze project-specific information related to funding, timing / phasing, and other information related to the use or development of IAA’s property. When capital projects are substantially complete, they will coordinate with the Finance department and provide guidance on the fixed assets to be set up in the financial system as well as how long the asset should remain on the books amortizing. They will provide support during the year-end annual external audit and prepare the CIP accrual.

The Senior Analyst will work closely with closely with Project Managers, Grants Administrator, and Senior Contracts Administrator within Planning and Development along with Finance, IT, and Properties throughout the life of each capital project. This position needs to have a good understanding of database management since multiple databases are used by IAA to facilitate requirements and management objectives.

ESSENTIAL FUNCTIONS

• Work directly with the Director, Capital Program to support the development the IAA’s Capital Program, including the ACIP
• Assist the Director, Capital Program with manage the 5-year capital budget, ACIP, and operating budget for Planning and Development
• Assist other IAA stakeholders to facilitate the development of capital projects and to ensure they are in-line with the needs of the airport strategic plans and available funds
• Manage the capital PO system to ensure contracts are within approved budgets, ensure all required approvals have been obtained, and ensure all required information is accurately inputted into the system
• Track and report on capital project funding sources
• Responsible for the annual year-end work paper and footnotes for the Capital Improvement Program and Fixed Assets
• Helps collaborate and coordinate with other departments, state agencies, FAA and other interested parties regarding the IAA’s strategic plans and development projects
• Responsible for timely and accurate dashboard analysis of key performance metrics on a monthly, quarterly and annual basis along with ad hoc report as requested
• Provide project and budget reporting to other IAA departments for the capital program
• Researches and analyzes project specific information related to funding, timing / phasing, and other information related to the use or development of IAA’s property
• Prepare detailed analysis for the capital program and operating expenditures, useful lives of assets, funding sources of the program and enhanced cash-flow forecasting on a short-term and long-term basis
• Prepares written, graphic, and oral reports, memoranda, presentations, and briefs concerning the IAA’s budgets, funding sources, and projects
• Perform any other function as assigned
• Perform all of the essential functions of the job outlined above without creating a direct threat to the safety of oneself, subordinates, or another person(s) in and around the airport

MINIMUM REQUIREMENTS

PHYSICAL DEMANDS AND WORK ENVIRONMENT

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.