Material Planner

About the position

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.

Requirements

• 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.

Nice-to-haves

• Aerospace or defense experience, especially in satellite or space hardware production
• Experience in a startup or rapid-growth manufacturing environment
• Experience implementing MRP best practices and driving inventory accuracy metrics
• Strong Excel skills; data analysis and dashboard reporting