Senior FP&A Analyst, Manufacturing & Materials (Hybrid)

Mercury Systems; Andover (MA); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Mercury Systems in Andover, MA seeks a Senior Financial Analyst for Manufacturing & Materials FP&A to bridge shop-floor dynamics with enterprise financial planning. Partner with Operations, Supply Chain, Procurement and leadership to turn large data into strategic models and actionable decisions.

The role uses Excel, Power BI, and Oracle ERP to uncover cost drivers, improve working capital, and drive continuous process improvements across a high-growth aerospace/defense manufacturing footprint.

Qualifications

• Bachelor's degree in Finance, Accounting, Economics, Supply Chain Management, Data Analytics or related quantitative field.
• Typically 4+ years of FP&A, Operations Finance, Plant/Manufacturing Cost Accounting or Supply Chain Finance experience.
• Expert modeling capabilities: Power Query, dynamic arrays, complex multi-variable lookup matrices, scenario modeling, sensitivity tables.
• Experience with ERP systems and manufacturing P&L mechanics; DoD program finance is a plus when relevant.
• Occasional in-office attendance outside hybrid schedule may be required.

Responsibilities

• Aggregate data and build financial models from manufacturing data.
• Consolidate datasets across BOMs, costing systems, and supply chain logs.
• Audit transactional, inventory, and cost data using Oracle ERP.
• Architect and deploy Power BI dashboards with real-time manufacturing metrics.
• Develop advanced Excel models with Power Query and dynamic arrays.
• Lead the Annual Operating Plan, quarterly updates, and monthly rolling forecasts for plants.
• Perform deep-dive variance analyses on PPV, MUV, labor efficiency, and absorption.
• Collaborate with Procurement on commodity prices, contracts, and currency trends.
• Model Excess & Obsolete reserves and optimize cash flow.
• Prepare Monthly Business Reviews with Plant Managers and executive leadership.

Skills

Power Query

Dynamic arrays

Complex lookups

Scenario modeling

Sensitivity tables

Education

Bachelor's Degree in Finance or related

Tools

Oracle ERP

Power BI

Excel

Job description

Mercury Systems in Andover, MA seeks a Senior Financial Analyst for Manufacturing & Materials FP&A to bridge shop-floor dynamics with enterprise financial planning. Partner with Operations, Supply Chain, Procurement and leadership to turn large data into strategic models and actionable decisions.

The role uses Excel, Power BI, and Oracle ERP to uncover cost drivers, improve working capital, and drive continuous process improvements across a high-growth aerospace/defense manufacturing footprint.