Aws Data Warehouse Finance Jobs

1 job found

Today

Senior Financial Analyst – Manufacturing & Materials FP&A

Mercury Systems Phoenix, AZ

Phoenix, AZ

Today

$75k - $177k/yr Full time Senior 3d Design Tools Accounting

Apply Now

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.

View full job page →

Get Aws Data Warehouse Finance Jobs alerts

New Aws Data Warehouse Finance Jobs, daily.