Supply Chain Analyst, Aerospace

youngfranklintactair; Village of Liverpool (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

Young & Franklin Tool Works is seeking a Production Planning Specialist to own the production schedule for high‑complexity, high‑mix aerospace products and drive on‑time delivery. You will leverage Epicor/ERP data and dashboards to optimize the planning process and collaborate across teams.

The ideal candidate has a Six Sigma background, strong analytical skills, and experience with data tools like PowerBI and SQL.

Qualifications

• Bachelor’s degree in Industrial Engineering or related field.
• Experience with Epicor, SAP or MAPICS recommended.
• Strong analytical skills and Excel proficiency.
• Ability to develop queries and convert data into insights.

Responsibilities

• Develop production schedule to meet delivery targets.
• Collaborate with Operations, Manufacturing and Quality teams.
• Release and track manufacturing jobs to maintain daily schedule.
• Analyze supply chain data to identify trends and improvements.
• Design dashboards and KPIs to monitor performance.
• Apply Lean Six Sigma and AI to planning processes.

Skills

Six Sigma

Data analytics

Excel

PowerBI

SQL

ERP systems

Communication

Problem-solving

Education

Bachelor’s degree in Industrial Engineering, Engineering and Management, Supply Chain Management, Data Analytics, Logistics, or a related discipline

Tools

Epicor ERP

SAP

MAPICS

PowerQuery

Epicor BAQ

Job description

Pay Range: $90,000 - $130,000

About Us We 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 Summary Responsible 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 & 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.

Responsibilities

Planning Activities

• Develop 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 customer.
• Collaborate 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 Activities

• Utilize 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 improvement.
• Perform statistical analysis to optimize inventory levels.
• Use Lean Six Sigma / continuous improvement methodologies to identify waste and engineer process improvements.
• Leverage AI to automate portions the planning process.
• Experience with PowerBI, PowerQuery, and/or Epicor BAQ is desired.
• Experience with SQL is desired.
• Perform additional duties as assigned.

Education and Experience

• This 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 discipline.
• Exceptional 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 Demands The 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