Supply Chain Management Analyst

Job Summary
We are seeking a skilled and detail-oriented Supply Chain Analyst to join our team. The Supply Chain Analyst will be responsible for supporting the planning, procurement, and inventory management of materials used in our operations. This role will leverage SQL and Business Intelligence (BI) tools to analyze data, forecast material requirements, and ensure optimal inventory levels. Additionally, the role will involve managing Estimated at Completion (EAC) calculations for supply chain operations, providing insights into labor cost projections throughout the Supply Chain process. The ideal candidate will have experience with scheduling, data analysis, and strong technical skills in SQL, BI reporting, and supply chain EAC.

Responsibilities

• Extract and organize data from multiple databases to drive actions related to material usage, inventory levels, material demand, labor forecasting and supply chain related analytics
• Develop and maintain BI reports and dashboards to track key performance indicators (KPIs), such as inventory turnover, order lead times, material shortages, and cost variances, and supply chain EAC.
• Analyze historical data and trends to help forecast future material requirements and optimize inventory levels.
• Calculate and track Estimated at Completion (EAC) for supply chain operations to forecast the total cost of labor through the supply chain cycle.
• Collaborate with internal customer support, contract administration, purchasing, engineering, quality assurance, program management, Inventory and warehousing.
• Analyze and understand how planned and unplanned demand impact overall Makes and Buy actions
• Review Bills of Material (BOM) and the related demand for production planning.
• Review unplanned demand and the impact to Material planning messages.

Minimum Qualifications

• Bachelor's degree and 4 years of experience in Supply Chain, Planning, Master Scheduling.
• Strong Understanding of Material Requirement Planning (MRP)
• Strong proficiency in SQL for data analysis, reporting, and database management.
• Experience with BI tools such as Power BI, Tableau, or similar for reporting and dashboard creation.
• Strong proficiency in Microsoft Excel and data modeling
• Strong analytical skills
• Understanding of master scheduling concepts and experience in material planning or inventory management.
• Experience in calculating and managing Estimated at Completion (EAC) for supply chain or project cost forecasting.
• Knowledge of supply chain processes, procurement, inventory management, and cost control.
• Excellent analytical skills, attention to detail, and ability to solve complex problems.
• Strong communication skills, with the ability to collaborate across departments.
• Good working knowledge of how a PLM/MES/MRP and related systems drive demand
• Built and optimized Alteryx workflows to automate supply chain data integration, enabling real-time visibility into inventory, lead times, and procurement trends across ERP and external data sources.
• Designed and maintained Cognos reports and dashboards to deliver actionable insights on supplier performance, inventory levels, and material availability, supporting data-driven supply chain decisions.

Preferred Qualifications

• Bachelor's degree in supply chain management, Business, Engineering, or a related field.
• Previous experience with shipping, receiving and inventory. Specifically within A&D

Summary Pay-Range
Please note that the salary information shown below is a general guideline only of what is reasonably expected to be paid for the position. Salaries are based upon candidate experience and qualifications, as well as market and business considerations.

• Level 4: $98,600 - $145,000