Supply Chain Analyst, Aerospace

Pay Range: $90,000 - $130,000About UsWe were founded in 1918 as Young & Franklin Tool Works on Franklin Street in Syracuse, but we’ve come a long way since then! Our product lines are low volume, high mix, and very tight tolerances. We manufacture, assemble and test valves and actuators for the Aerospace and Power Generation markets. Our 120,000 square foot facility houses R&D, Design Engineering, Assembly & Test, and an 80,000 square foot Machine Shop. We regularly invest in new machines but outdid ourselves in the last 18 months with 5 new machines! We’re part of the TransDigm Group (NYSE: TDG), one of the world’s leading suppliers of highly engineered components for virtually all aerospace applications, helping us continually invest in new products and technology. We hire great people from a wide variety of backgrounds who share in our enthusiasm for innovation, design, and manufacturing excellence.Position SummaryResponsible for both production planning activities and process improvement initiatives to optimize the production planning process. Owns the production schedule for high-complexity, high-mix aerospace products, ensuring >95% on time delivery. Collaborates with colleagues to avoid bottlenecks in the manufacturing process and recommends recovery plans for missed milestones. Communicates and identifies achievable ship dates and/or delays in production to Sales and Marketing. Leverages data analytics and continuous improvement methodologies to optimize the production planning process. The ideal candidate will have exceptional problem-solving skills, hands-on experience using database query tools to extract, analyze and present information through dashboards, and strong communication skills. Additionally, a strong background in Six Sigma methodologies, statistical analysis, and APICS certifications (CSCP or CPIM) would be highly beneficial.ResponsibilitiesPlanning ActivitiesDevelop production schedule to meet external customer delivery requirements and internal customer revenue targets.Review customer orders, factory capacity and material availability to provide product ship dates for Sales & Marketing.Advise management of work in progress status, material availability, and potential production problems to ensure product is delivered on time to the customerCollaborate with Operations Managers, Machine Shop Manager, Manufacturing Engineers, Shop Floor Group Leaders, Quality, and Planners to prioritize and expedite parts, and to determine progress and completion dates.Manage the process of expedited orders by facilitating communication between responsible departments.Actively monitor and level workload with capacity constraints at the resource level.Release and track manufacturing jobs to ensure compliance to the daily schedule and identify/escalate issues that prevent its successful execution.Process Improvement ActivitiesUtilize Epicor ERP system to extract and analyze supply chain data, identify trends, and develop actionable insights to drive process improvements.Design and implement supply chain dashboards and KPIs (Key Performance Indicators) to monitor performance and identify areas for improvementPerform statistical analysis to optimize inventory levelsUse Lean Six Sigma / continuous improvement methodologies to identify waste and engineer process improvementsLeverage AI to automate portions the planning processExperience with PowerBI, PowerQuery, and/or Epicor BAQ is desiredExperience with SQL is desiredPerform additional duties as assigned.Education And ExperienceThis position requires either a US Person (as defined in applicable export regulations) or a non-US person who is eligible to obtain required export authorization.Bachelor’s degree in Industrial Engineering, Engineering and Management, Supply Chain Management, Data Analytics, Logistics, or a related disciplineExceptional skills in developing queries, performing analysis, and converting data into informative insights.Exposure to or experience with production planning using systems such as Epicor, SAP, MAPICS or the equivalent.Understanding business processes and using planning tools to optimize production.Strong analytic background and proficiency in Excel.Self-motivated and proactive with strong interpersonal and written and verbal communication skills.Ability to work with minimal supervision as an individual contributor and as a member of cross-functional team.Physical DemandsThe physical demands described are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made.Sit, stand, walk and interact throughout the day in a typical office environment Reach above the shoulder, below the waist, and lift up to 10 pounds to file documents or store materials Walk through manufacturing areas requiring personal protective equipment: safety glasses, hearing protection, etc. Employment Opportunity/Affirmative Action Employer, including disabled and veterans