Senior Financial Analyst – Financial Modeling
Heven AeroTech · Sterling, VA · 4 days ago
On-siteFinanceFull-time
About the role
The Senior Financial Analyst – Financial Modeling is the primary financial modeling resource for the CFO. This role ensures the CFO and executive team's reliance on accurate, current, and robust financial models for fundraising, investor reporting, and strategic decision-making.
Responsibilities
- Own and maintain the enterprise investor model — a multi-entity, multi-year consolidated three-statement model integrating operating assumptions across all entities into a single investor-grade view
- Build and maintain capital structure models supporting debt facility analysis, government-guaranteed financing structures, equity round sizing, and repayment waterfalls
- Develop scenario and sensitivity analyses across revenue timing, cost assumptions, headcount ramp, and capital structure to support executive and investor decision-making
- Maintain models with a standard of transparency and auditability such that assumptions are clearly documented, formulas are traceable, and outputs can be independently verified
- Maintain version control across all models with prior versions preserved and retrievable; update the enterprise model promptly upon any material assumption change
- Serve as the enterprise data coordinator for financial models — own the end-to-end process of identifying, requesting, validating, and integrating data inputs from across the organization
- Actively manage data relationships across Finance, Accounting, Contracts & Procurement, Manufacturing, Engineering, and Growth/BD to establish reliable, repeatable data flows into financial models
- Drive accountability for data delivery across departments — define what data is needed, from whom, in what format, and by when; follow through to ensure commitments are met
- Build and maintain data mapping and transformation logic to normalize inputs across entities and systems with inconsistent structures
- Proactively identify gaps, inconsistencies, and latency issues in data flows before they surface in model outputs; escalate and resolve with a sense of urgency
- Persistently partner with Accounting and FP&A to build durable, low-maintenance data pipelines that reduce manual effort and improve model refresh cycle time
- Integrate entity-level financial inputs and operating assumptions into the consolidated enterprise model in support of investor and executive reporting
- Maintain intercompany eliminations and cross-entity adjustments within the model layer to produce a clean consolidated view
- Aim to align with FP&A leadership to ensure entity-level planning assumptions are accurately reflected in enterprise model inputs
- Build and maintain financial models and supporting schedules for active fundraising processes including equity rounds and government loan facilities
- Prepare investor-facing financial output schedules, returns analyses, and sources and uses presentations derived from enterprise models
- Respond to investor and lender model requests and due diligence questions with speed and accuracy; support data room population
- Build and maintain demand and pipeline models to support investor and lender narratives around revenue growth and market opportunity
Qualifications & Experience
- Bachelor’s degree in Finance, Accounting, Economics, or a related quantitative field
- 5–8 years of experience in a role where financial modeling was the primary work product — investment banking, private equity, or a dedicated corporate finance modeling function at a complex, multi-entity organization
- Expert-level Excel financial modeling: three-statement models, DCF, scenario and sensitivity analysis, and complex multi-sheet model architectures built from scratch
- Demonstrated ability to own models independently from data acquisition through output delivery
- Proven experience driving cross-functional data collection processes — managing relationships and timelines across multiple departments to ensure model inputs are accurate and timely
- Familiarity with government-guaranteed or asset-backed financing structures
- Experience supporting active fundraising or capital markets transactions where model output was used directly with investors or lenders
- Exposure to multi-entity or international financial consolidation
- CFA candidate or CFA charterholder