Senior Financial Analyst – Manufacturing & Materials FP&A
Senior
3d Design Tools
Accounting
Analytical Skills
Analytics
Automation Developer
Aws Data Warehouse
Budget Management
Business Analytics
Business Intelligence
Business Intelligence Tools
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data Analysis
Data Analytics
Data Analytics Tools
Data Engineer
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Financial Analysis
Financial Planning
Financial Reporting
FP&A
Hr Technology
Management
Manufacturing Financial Planning
Microsoft
Microsoft 365
Microsoft Excel
Microsoft Office
Microsoft Power Platform
Office 365
Office Tools
Oracle ERP
Power BI
Power Platform
Product Management
Production Analytics
Productivity Tools
Reporting and Analytics
Software Development
Spreadsheets
Tools
Job Description
Mercury Systems is seeking a Senior Financial Analyst for Manufacturing & Materials FP&A to connect shop-floor performance with enterprise planning. The position focuses on building and automating financial models and analytics that support budgeting, forecasting, variance analysis, and continuous improvement across multiple manufacturing sites.
Key Responsibilities
- Consolidate, synthesize, and automate complex datasets across multiple manufacturing facilities, including bills of materials (BOM), standard costing systems, and supply chain logistics logs.
- Extract, manipulate, and audit transactional, inventory, and cost ledger data using Oracle ERP (Cloud ERP, Amazon Datalake, and PowerBI).
- Design and deploy executive-ready, interactive Power BI dashboards to deliver real-time visibility into manufacturing metrics such as PPV, scrap rates, plant throughput, and labor absorption.
- Develop and maintain scalable Excel financial models using Power Query, dynamic arrays, scenario managers, and advanced formula architecture.
- Own planning activities including the Annual Operating Plan (AOP), quarterly updates, and monthly rolling forecasts for manufacturing plants, direct material spend, freight, and conversion costs.
- Conduct deep-dive variance analysis comparing standard versus actual performance across PPV, material usage variance (MUV), labor efficiency, volume variance, and under- or over-absorption.
- Partner with Procurement to monitor commodity price indices, supplier contract renegotiations, currency fluctuations, and macro inflation or deflation trends.
- Track inventory turns, analyze safety stock thresholds, and model Excess & Obsolete (E&O) reserves to support cash flow optimization.
- Translate complex manufacturing and multi-variable financial variances into executive summaries, visual bridge charts, and strategic narratives.
- Support Monthly Business Reviews (MBRs) with Plant Managers, the VPs of Lines-of-Business, and the CFO, highlighting financial trajectory, risks, and opportunities.
- Move beyond historical reporting to identify cost leakages, operational bottlenecks, and scrap anomalies, and collaborate with plant engineering on root-cause corrective actions.
- Establish standardized reporting cadence, cost-tracking methodologies, and inventory governance across plant operations.
Required Qualifications
- Bachelor’s Degree in Finance, Accounting, Economics, Supply Chain Management, Data Analytics, or a related quantitative field.
- Typically 4+ years of progressive experience in FP&A, Operations Finance, Plant/Manufacturing Cost Accounting, or Supply Chain Financial Analysis.
- Advanced modeling skills including Power Query, dynamic arrays, complex multi-variable lookup matrices, scenario modeling, and sensitivity tables.
- Proven experience building semantic models using DAX and Star Schema, plus 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.
- Strong independent investigation and variance problem-solving with cross-functional collaboration to drive process improvements.
- Occasional in-office attendance outside the standard hybrid schedule may be needed to support meetings, execution, and/or team events.
Technologies
- Microsoft Excel
- Power BI
- Oracle ERP
- Cloud ERP
- Amazon Datalake
- Power Query
- Dynamic arrays
- Scenario managers
- DAX
- Star Schema
Location and Work Style
Phoenix, AZ (hybrid)
Salary Information
- USD 75,000 - 177,000 per year
- Full-time equivalent job grade salary range details:
- $75,000.00 - $150,000.00 annual salary for in-office or hybrid employees in FL, GA, IN, AZ, AL, MD, or TX, and all remote employees
- $84,000.00 - $168,000.00 annual salary for in-office or hybrid employees in VA, CA, NH, or MA
- $88,500.00 - $177,000.00 annual salary for in-office or hybrid employees in NJ
Benefits
- Bonus opportunities (or special incentives for sales positions)
- Health, life, and disability insurance
- Company-paid holidays and time off
- 401(k) retirement plan
- Discounted employee stock purchase plan
- Tuition reimbursement
- Access to professional development and personal wellness platforms including LinkedIn Learning, Headspace, Aaptiv, and Virgin Pulse
- Annual stock-based awards for team members at the Director or Vice President level
- 9/80 alternative work schedule (available based on location)
Preferred Qualifications
- Direct hands-on experience with Oracle preferred.
- Commercial manufacturing and DoD program finance experience is a plus.
- Strong preference for hybrid work from Phoenix, AZ, where the team is based and the majority of manufacturing operations are located.
U.S. Export Compliance Notice
This position requires you to access information that is subject to U.S. export regulations. You may only access such information if you are a U.S. citizen, lawful permanent resident of the U.S., protected individual as defined by 8 U.S.C. 1324b(a)(3), or eligible to obtain the required authorizations from the U.S. government.