SQM Financial Data Analyst - Zeus Aerospace and Defense

Arrow•Purchase, NY

15d•Onsite

About The Position

The SQM Financial Data Analyst role at Zeus Aerospace and Defense is responsible for managing the end-to-end RFQ (Request for Quotation) process, including activity reporting, part list preparation, drawing identification and standardization, supplier pricing requests, costing response review, data consolidation, and coordination of pricing strategy reviews. This role ensures financial accuracy by validating supplier cost inputs and margin structures. Additionally, the analyst processes awarded business, performs financial variance checks, and finalizes award documentation. They also support the full contract lifecycle by monitoring financial performance and compliance, and assist with global contract opportunities by providing analytical insights for quote strategy, margin targets, and competitiveness. The role involves compiling, analyzing, and interpreting financial datasets for decision-making, including SQM Design Win Capture Templates, SQM Executive Summaries, and Won/Lost financial analysis.

Requirements

College degree preferred
Minimum 1 - 3 years data/database administration experience
Experience in the electronics industry preferred
Proficient with MS Excel (Concatenations, If Statements, Macro, Pivot Tables, V-Lookups, X-Lookups)
Familiar with MS Access (Query and Table creation)
Comfortable working with part numbers and product associated with those part numbers
Ability to work collaboratively with internal and external resources to generate results
Ability to multi-task, work in a fast-paced environment and manage multiple priorities
Steady, thoughtful and professional performance and mature under pressure
Effective communicator both orally and in writing
Strong research and problem-solving skills
Strong interpersonal and organization skills
Must be able to make evaluative judgments based on data analysis
Typically requires a 4-year degree and 2–4 years of related experience; or an advanced degree without experience; or equivalent work experience.

Responsibilities

Manage RFQs end-to-end, including activity reporting, part list preparation, drawing identification, drawing naming convention standardization, supplier pricing requests through marketing, costing response review, data consolidation, and coordination of pricing strategy reviews with Sales.
Ensure financial accuracy and alignment by validating supplier cost inputs and margin structures prior to submission.
Process awarded business by updating reports, preparing part lists, requesting and validating supplier pricing, reviewing exceptions with Sales, and finalizing award documentation for National Account Managers.
Perform financial variance checks between quoted and awarded pricing to identify risks and margin impacts.
Finalize award packages, maintain documentation, and prepare part lists for transition to the Strategic Quote Management Contract Analyst for implementation.
Support financial consistency checks during contract setup to ensure pricing integrity.
Compile, analyze, and interpret financial datasets critical to Strategic Quote Management decision-making, including: SQM Design Win Capture Templates, SQM Executive Summaries for leadership, and Won/Lost financial analysis to identify pricing trends, competitive gaps, and strategic improvement areas.
Support the full contract lifecycle ("cradle to grave") by monitoring financial performance and compliance throughout the contract duration.
Assist with contract opportunities globally, providing analytical insights to guide quote strategy, margin targets, and competitiveness.