Program Analyst

INDRA AIR TRAFFIC INC•Overland Park, KS

7d•Onsite

About The Position

The Program Analyst provides program controls, financial analysis, schedule analysis, forecasting, and performance reporting for a high-visibility, complex ~$350M aviation program supporting the Federal Aviation Administration (FAA).

Requirements

Bachelor’s degree in finance, Accounting, Business Administration, Program Management, Engineering, or a related discipline.
Minimum 5 -7 years of aerospace experience in program controls, financial analysis, program finance, project controls, or a related role supporting complex programs.
Demonstrated experience developing and maintaining program budgets, forecasts, ETCs, and EACs.
Experience performing cost, schedule, revenue, margin, and variance analysis.
Strong understanding of program financial concepts including revenue, cost, gross margin, accruals, commitments, WIP, cash flow, and forecasting.
Advanced proficiency with Microsoft Excel and financial/data analysis.
Experience developing management dashboards, KPIs, and executive-level program reporting.
Strong analytical skills with the ability to translate large amounts of financial and program data into actionable management information.
Ability to work effectively across Finance, Engineering, Manufacturing, Supply Chain, Contracts, and Program Management organizations.
Strong written and verbal communication skills with the ability to clearly communicate complex financial and program information.

Nice To Haves

PMP, FP&A, EVM, or related professional certification
Experience supporting large-scale FAA, aerospace, defense, aviation, or U.S. Government programs.
Experience with programs valued at $100M+ or similarly complex multi-year programs.
Knowledge of Federal Acquisition Regulations (FAR) and government contracting environments.
Experience with Earned Value Management (EVM) or similar program performance management methodologies.
Experience with Integrated Master Schedules and schedule analysis.
Experience with ERP and program financial systems such as MS Business Central, SAP, Oracle, Costpoint.
Experience with Power BI or other business intelligence and visualization tools.

Responsibilities

Develop and maintain detailed program financial forecasts for revenue, cost, gross margin, cash flow, and expenditures.
Analyze actual program performance against budget, baseline, forecast, and contractual objectives.
Develop and maintain monthly ETC and EAC forecasts in coordination with the Program Manager and functional organizations.
Perform cost, revenue, margin, and forecast variance analysis and identify significant trends or deviations.
Identify potential cost overruns, margin erosion, funding concerns, and other emerging financial risks.
Develop financial scenarios and impact assessments to support Program Manager decision-making.
Support annual operating plan (AOP), budget, and long-range planning activities.
Maintain detailed cost forecasts by workstream, CLIN, purchase order, subcontract, labor category, and major cost element.
Reconcile actual costs, commitments, accruals, WIP, and forecasted expenditures.
Monitor labor, material, supplier, production, equipment, travel, tariff, and other program costs.
Analyze actual and projected expenditures against the approved program baseline.
Identify cost trends and unfavorable variances before they materially affect program financial performance.
Support development and tracking of financial recovery and corrective-action plans.
Support maintenance and analysis of the Integrated Master Schedule (IMS).
Analyze critical path, schedule variance, milestone performance, dependencies, and forecast completion dates.
Identify emerging schedule trends and potential impacts to contractual commitments.
Integrate schedule and financial information to evaluate the cost, revenue, cash flow, and margin impact of schedule changes.
Support schedule recovery planning and what-if analysis.
Coordinate closely with the Project Coordinator to ensure execution status is accurately reflected in program schedules and forecasts.
Develop and maintain integrated program dashboards and Key Performance Indicators (KPIs).
Provide objective reporting of: Revenue and revenue forecast, Actual and forecast costs, Gross margin, ETC and EAC, Cash flow, Budget versus actual performance, Schedule and milestone performance, Risk and opportunity exposure, Supplier performance, Installation and deployment readiness.
Develop trend analyses that clearly identify changes in program performance over time.
Ensure reported metrics are accurate, consistent, traceable, and supported by approved source data.
Highlight exceptions and emerging issues requiring Program Manager or executive leadership attention.
Lead preparation of financial and analytical content for monthly program reviews.
Reconcile program financial data with Finance prior to executive reporting.
Support monthly financial close activities, including accruals, WIP, revenue recognition inputs, cost reconciliation, and forecast updates.
Maintain historical program performance and forecast changes to provide month-over-month visibility.
Develop concise executive-level analyses explaining significant cost, schedule, revenue, and margin variances.
Support the Program Manager in preparation for executive and customer program reviews.
Support maintenance of the program Risk and Opportunity Register.
Quantify potential cost, schedule, revenue, and margin exposure associated with identified risks.
Track mitigation actions and evaluate their effectiveness.
Incorporate approved risks and opportunities into ETC/EAC and financial scenarios when appropriate.
Perform sensitivity and what-if analyses to evaluate potential program outcomes.
Monitor program funding, CLINs, contractual values, and financial performance against contractual requirements.
Work with the Program Administrator and Contracts organization to ensure contract modifications, funding changes, and billing milestones are reflected in program forecasts.
Analyze the financial impact of contract changes, customer requests, scope changes, and proposed modifications.
Support change requests, proposals, and Rough Order of Magnitude (ROM) estimates through cost and schedule analysis.
Support subcontract financial analysis and evaluation of supplier cost impacts.
Partner with Engineering, Manufacturing, Supply Chain, Quality, Field Services, Contracts, Finance, and other functions to obtain accurate program inputs.
Establish recurring processes and data requirements for program forecasting and reporting.
Challenge incomplete or inconsistent program data and drive resolution with functional owners.
Ensure assumptions used in forecasts are documented, supportable, and aligned with current execution plans.
Provide analytical support for program recovery plans, resource decisions, supplier issues, and other major program decisions.