# Lead FP&A

**Company:** [Shield AI](https://hotfix.jobs/companies/shield-ai)
**Location:** Washington, DC
**Role:** Revenue Operations
**Salary:** $110k – $160k/yr
**Experience:** 3+ years
**Skills:** SQL, Databricks, Power BI, ETL, Anaplan, Excel, Financial Modeling, AI Tools, Snowflake, Redshift, Salesforce
**Posted:** 2026-07-09

> Lead FP&A business partner for GTM teams (Sales, BD, Marketing, Customer Success). Own headcount/spend forecasting, build data pipelines and dashboards with SQL/Databricks, establish data governance and SOPs, and partner cross-functionally to drive financial visibility and operational decisions in a defense tech environment.

## Job Description

## What you'll do

### Headcount & Spend Management
- Build and maintain GTM headcount, spend forecasting, tracking, and capacity models
- Provide full visibility into GTM OpEx, identifying cost drivers and resource optimization opportunities
- Monitor actuals vs. plan and forecast; drive accountability with cost center owners
- Partner with Data Engineering and system owners to automate headcount reconciliations across HR, Finance, and GTM systems — including unit economics

### Data Engineering & Analytics Infrastructure
- Partner with Data Engineering and BI to define data architecture, KPIs, and source-of-truth models
- Build automated reporting workflows and capacity models in partnership with Data Engineering or Anaplan teams
- Write and maintain SQL for ETL workflows across the data lake / Databricks environment
- Build and manage scalable, reliable data pipelines powering GTM finance reporting
- Create semantic data models and curated reporting tables for consistent cross-team metrics
- Build dashboards in Databricks, Power BI, or similar tools for real-time GTM visibility

### Data Quality, Governance & SOPs
- Establish and enforce data quality monitoring, validation rules, and anomaly detection
- Write SOPs for key GTM finance processes: close, headcount reconciliation, budget loading, variance reporting
- Drive consistent KPI and metric definitions across GTM, Finance, and Data
- Implement data governance practices to protect reporting integrity
- Identify data or process gaps and propose scalable solutions

### Cross-Functional Collaboration & Process Improvement
- Partner with Revenue Ops, HR, Recruiting, Accounting, and Data to ensure financial plans match operational reality
- Collaborate with Revenue Operations on quotas, pipeline forecasting, and GTM capacity
- Continuously streamline tools, reporting, and processes with an automation-first mindset
- Lead special projects and strategic analyses for finance leadership

## Required qualifications
- Bachelor’s degree in finance, Accounting, Economics, Business, CS, or related field
- 3–6 years of experience in FP&A, GTM Finance, Sales Finance, RevOps, or equivalent analytical roles
- Strong SQL skills, including the ability to write, optimize, and troubleshoot queries on large datasets
- Proficiency with AI tools to improve analysis speed, accuracy, and productivity
- Experience with cloud data platforms (Databricks, Snowflake, Redshift, etc.) and ETL/pipeline concepts
- Demonstrated ability to build headcount models and GTM or corporate OpEx budgets
- Advanced financial modeling skills in Excel; strong driver-based forecasting experience
- Excellent communication skills with both technical and non-technical stakeholders
- Exceptional attention to detail and commitment to data accuracy
- Ability to operate independently in a fast-paced, mission-driven environment
- Must be authorized to work in the United States

## Preferred qualifications
- Experience in defense tech, aerospace, or dual-use hardware/software
- Exposure to U.S. government contracting or milestone-based revenue models
- Proficiency with AI tools to improve analysis speed, accuracy, and productivity
- Experience with Anaplan or similar planning tools; ERP/CRM experience (Oracle, NetSuite, Salesforce)

## Similar roles

- [Senior Deal Desk Analyst](https://hotfix.jobs/jobs/7a57c2ce-a3c3-4493-bbda-4d292dd56575) - Eve - San Mateo, CA - $110k – $160k/yr
- [Senior Sales Operations & Compensation Manager](https://hotfix.jobs/jobs/2329a64b-29cf-4c6a-8fe4-30e24340c19a) - Wrapbook - Remote - $110k – $192k/yr
- [Senior Revenue Operations Analyst](https://hotfix.jobs/jobs/e5d9306a-d1c8-47a3-a296-6f77ac412c91) - Permitflow - New York, NY - $110k – $140k/yr
- [Senior Marketing Strategy & Planning Manager](https://hotfix.jobs/jobs/423381d2-de75-43fb-9d18-178f22ef62bb) - Rippling - San Francisco, CA - $110k – $215k/yr
- [Senior Manager, Sales Strategy & Operations (Hybrid based in San Francisco)](https://hotfix.jobs/jobs/9581fbdd-6303-4854-b28c-73a840dbc5aa) - Rippling - San Francisco, CA - $110k – $215k/yr

**Apply:** https://hotfix.jobs/jobs/71fbbf0f-0e76-4159-9289-bd7dd3b7e860
**Canonical:** https://hotfix.jobs/jobs/71fbbf0f-0e76-4159-9289-bd7dd3b7e860