Senior FP&A: Manufacturing & Materials Cost & Ops Insights

Mercury Systems

Chantilly (VA)

Hybrid

USD 120,000 - 165,000

Full time

2 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Mercury Systems in Chantilly, VA is seeking a high-impact Senior Financial Analyst - Manufacturing & Materials FP&A to bridge shop-floor dynamics and enterprise financial planning. You will transform large datasets into strategic models, partnering with Operations, Supply Chain, Procurement, and Leadership to drive actionable business decisions.

The role emphasizes data-driven cost analysis, working capital improvements, and continuous process enhancements across a high-tech

Qualifications

Bachelor's degree in Finance, Accounting, Economics, Data Analytics, or related quantitative field.
Typically requires 4+ years of progressive experience in FP&A, Operations Finance, Plant/Manufacturing Cost Accounting, or Supply Chain Financial Analysis.
Expert modeling capabilities (Power Query, dynamic arrays, complex multi-variable lookup matrices, scenario modeling, sensitivity tables).
Demonstrated success building semantic models (DAX, Star Schema) and developing published executive dashboards.
Hands-on experience with ERP Systems.
Deep knowledge of standard costing, routings, absorption accounting, scrap allocation, and manufacturing P&L mechanics.
An inquisitive problem-solver who independently investigates variances, engages cross-functional teams, and drives process fixes.
Occasional in-office attendance outside the standard hybrid schedule to support meetings, execution and/or team events.

Responsibilities

Data Aggregation, Business Intelligence & Financial Modeling.
Consolidate, synthesize, and automate complex datasets spanning multiple manufacturing facilities, BOMs, standard costing systems, and supply chain logs.
Extract, manipulate, and audit transactional, inventory, and cost ledger data utilizing Oracle ERP (Cloud ERP, Datalake and PowerBI).
Architect and deploy executive-ready, interactive Power BI dashboards for real-time manufacturing metrics (PPV, scrap rates, plant throughput, labor absorption).
Design and maintain scalable Excel financial models leveraging Power Query, dynamic arrays, scenario managers, and advanced formula architecture.
Direct the Annual Operating Plan (AOP), quarterly updates, and monthly rolling forecasts for manufacturing plants, direct material spend, freight, and conversion costs.
Perform deep-dive variance analysis comparing standard vs. actual performance (PPV, MUV, labor efficiency, volume variance, absorption).
Collaborate with Procurement to track commodity price indices, supplier contract renegotiations, currency fluctuations, and macro inflation/deflation trends.
Monitor inventory turns, analyze safety stock thresholds, and model Excess & Obsolete reserves to optimize cash flow.
Distill complex manufacturing metrics into concise executive summaries, visual bridge charts, and strategic narratives.
Prepare and support Monthly Business Reviews with Plant Managers, VPs, and CFO, providing visibility into financial trajectory, risks, and opportunities.
Move beyond reporting to identify cost leakages, bottlenecks, and scrap anomalies; establish root-cause corrective actions with plant engineering.
Establish standardized reporting cadence, cost-tracking methodologies, and inventory governance across all plant operations.