Sr. Capital Program Budget and Data Analyst

Description

• Airport in North America and Indiana Chamber's Best Places to Work!
• Paid Childcare Reimbursements up to $10k/year, per child.
• Paid Tuition Assistance up to $5,250/year
• Generous Medical, Dental, Vision and RX
• Free Healthcare through Marathon Health
• Pet Insurance
• Up to 5% Match Retirement Plan
• Generous Paid Time Off Programs & MORE

GENERAL SUMMARY

The Senior Budget and Data Analyst will report to, and work directly with, the Manager, 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 Manager, Capital Program to support the development the IAA's Capital Program, including the ACIP
• Assist the Manager, 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

• Bachelor's degree from an accredited university in engineering, accounting, business, or related field
• Preference for five (5) years of progressive financial experience, preferably with public account experience
• Demonstrated ability to manage multiple projects
• Demonstrable expertise in the use of spreadsheets and similar application is required
• Proven ability to act independently and lead complex projects
• Strong written and oral communication skills
• Ability to work in team environments

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.

• Physical demands: While performing the duties of this position, the employee is required to walk, sit, use of hands to finger, handle, or feel objects, reach with hands and arms, balance, stop, talk or hear. The employee must occasionally lift and/or move up to 25+ pounds or more. Specific vision abilities required by the position include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to focus. Operate a motor vehicle with a valid driver's license. Use of a computer and other personal assistance devices (tablets or mobile phone) are a must for this position.

• Work environment: This position is performed within an office environment at least 80% of the time. The other 20% the employee will be exposed to weather conditions prevalent at the time. With multiple worksites, the noise level varies from the office environment and the outside environment. The incumbent in this position is expected to work independently and as part of the team.