Interim Senior FP&A Consultant

AeroVironment•Huntsville, AL

About The Position

The Company is seeking an experienced Senior FP&A Consultant to provide interim coverage during a parental leave period. The consultant will support the Finance organization through a period of significant organizational and systems transition following the Company's recent acquisition. The successful candidate will be highly hands-on and capable of independently managing complex FP&A activities, including monthly and quarterly P&L reporting, forecasting, financial analysis, management reporting, system troubleshooting, cost pool allocations, and data integration across multiple financial systems. Given the complexity of the current environment, the ideal candidate will have deep FP&A experience combined with strong technical accounting, financial systems, and financial modeling expertise and should be able to quickly understand existing processes and independently troubleshoot issues across the financial systems landscape.

Requirements

10+ years of progressive FP&A/Finance experience, preferably including Director-level responsibilities.
Significant experience owning or supporting monthly and quarterly P&L processes.
Deep understanding of P&L drivers, variance analysis, forecasting, budgeting, and Adjusted EBITDA.
Advanced/expert Excel modeling skills.
Hands-on experience with Unanet, including cost pool allocations and reporting.
Hands-on experience with OneStream, including reporting, data flows, and troubleshooting.
Experience with Oracle GL and Trial Balance reporting.
Experience with Hyperion Planning.
Strong understanding of financial systems integration and data flows between ERP, accounting, consolidation, and planning systems.
Strong accounting and financial reporting knowledge.
Experience working in a complex or changing systems environment, preferably following an acquisition, merger, or systems integration.
Excellent analytical and problem-solving skills.
Ability to independently investigate discrepancies and determine root causes.
Strong communication and executive presentation skills.
Experience with long-range planning and financial forecasting.
Familiarity with SEC reporting and 10-K filings.
Government contracting or similarly complex cost accounting environments.
Cost pool allocation methodologies.
Post-acquisition financial systems integration.
Unanet → OneStream → Oracle data flows.
OneStream administration/troubleshooting.
Hyperion Planning.
SEC reporting and 10-K preparation.
Adjusted EBITDA reporting.
Supporting PE-backed or acquisition-driven organizations.
Building financial reporting processes from incomplete or evolving systems/data structures.
The candidate should be comfortable going from a detailed GL or Trial Balance report, through Unanet and OneStream, to an executive-level P&L and Adjusted EBITDA explanation.
They should be able to identify when a number does not look right, trace the issue through the underlying systems and allocations, determine the root cause, and explain the resulting financial impact to senior leadership.
Because the Company is integrating systems following an acquisition, the candidate must be comfortable working in an environment where processes and systems may not always be fully documented and should have the technical and analytical ability to figure things out independently rather than relying heavily on others for direction.
Independently support and/or own the monthly and quarterly P&L process.
Produce accurate and timely financial reporting and analysis.
Quickly understand the Company's financial systems and data flows.
Troubleshoot discrepancies between Unanet, OneStream, Oracle, and other reporting systems.
Accurately explain P&L and Adjusted EBITDA movements.
Maintain and enhance complex FP&A models.
Support forecasting, budgeting, and long-range planning.
Provide high-quality executive reporting and presentations.
Minimize disruption to the Finance organization during the parental leave period.
Operate effectively with minimal supervision in a complex post-acquisition environment.
This position requires access to information that is subject to compliance with the International Traffic Arms Regulations (“ITAR”) and/or the Export Administration Regulations (“EAR”). In order to comply with the requirements of the ITAR and/or the EAR, applicants must qualify as a U.S. person under the ITAR and the EAR, or a person to be approved for an export license by the governing agency whose technology comes under its jurisdiction.
Some positions will require current U.S. Citizenship due to contract requirements.

Responsibilities

Own and support the monthly and quarterly P&L compilation and close process.
Analyze P&L results, including detailed understanding of revenue, gross margin, operating expenses, and EBITDA drivers.
Identify and explain monthly/quarterly P&L puts and takes, variances, trends, and underlying business drivers.
Calculate and analyze Adjusted EBITDA, including identifying adjustments and reconciling EBITDA movements.
Develop detailed financial analysis and management reporting for senior leadership.
Support forecasting, budgeting, and long-range planning activities.
Develop and maintain sophisticated Excel-based financial models.
Perform ad hoc financial analysis and scenario modeling as required.
Translate complex financial and operational data into clear, actionable insights for senior leadership.
The consultant must be highly comfortable working across multiple financial systems and understanding how data flows between them, including: Unanet, OneStream, Oracle, Hyperion.
Deep expertise with Unanet. Understand Unanet reporting and financial data structures. Pull and analyze financial reports from Unanet. Understand and troubleshoot cost pool allocations. Understand the flow of financial data from Unanet into downstream systems. Support the preparation and import of Unanet Trial Balance data into Oracle.
Strong hands-on experience with OneStream. Pull financial reports and reporting packages from OneStream. Understand data flows from Unanet into OneStream. Troubleshoot OneStream administrative/system issues and work with appropriate technical resources to resolve issues. Understand OneStream data structures, consolidations, reporting, and financial processes. Investigate and resolve discrepancies between source systems and OneStream.
Strong understanding of Oracle accounting and financial reporting. Ability to work with General Ledger and Trial Balance reports. Support the import of Unanet Trial Balance information into Oracle. Understand the relationship between Oracle accounting data and FP&A reporting.
Experience using Hyperion Planning modules. Support forecasting, budgeting, and long-range planning processes. Understand how planning data flows into broader FP&A reporting.
Strong understanding of the General Ledger and Trial Balance.
Ability to reconcile financial information across systems.
Understand accounting entries and their impact on the P&L.
Partner with Accounting to investigate and resolve discrepancies.
Understand the relationship between operational data, accounting data, and management reporting.
Familiarity with 10-K financial reporting and SEC reporting concepts.
Ability to connect external financial reporting requirements with internal FP&A reporting and analysis.
Build and maintain complex Excel models with a high degree of accuracy.
Create management reporting packages, charts, and executive-level presentations.
Develop clear visualizations of financial performance and trends.
Present financial results and analysis to senior leadership.
Clearly communicate the financial impact of business decisions and changes in assumptions.
Be able to move seamlessly between detailed transactional analysis and high-level executive-level financial storytelling.