Supply Chain Analyst

Ensign-Bickford Industries; Simsbury (CT); On-site; USD 90,000 - 130,000; Full time

Job summary

Ensign-Bickford Aerospace & Defense Company in Simsbury, CT is seeking a Supply Chain Business Analyst to design and deliver data analytics, dashboards, and reporting across procurement, planning, and inventory management as part of the Supply Chain Center of Excellence.

The role collaborates with IT, Engineering, Finance, and PMO to enable trusted data solutions, support the IFS Cloud transition, and drive continuous improvement in supply chain execution.

Qualifications

• Bachelor's degree in Computer Science, Data Analytics, Supply Chain Management, Industrial Engineering, Business, or a related field.
• Must be able to comply with U.S. export control regulations, ITAR.
• 5+ years of experience in advanced data analytics, business analytics, supply chain analytics, or a related discipline.
• Advanced experience developing data models, analytical solutions, dashboards, and automated reporting.

Responsibilities

• Design, develop, and maintain advanced data models, analytics, dashboards, and reporting solutions supporting supply chain processes and business decision-making.
• Translate complex supply chain requirements into scalable data and analytical solutions to support procurement, planning, inventory, supplier management, logistics, and strategic sourcing.
• Develop and automate Supply Chain KPI reporting, materials forecasts, inventory analysis, supplier performance analytics, cost analysis, and other operational reporting requirements.
• Analyze complex supply chain data to identify trends, risks, opportunities, and root causes and provide recommendations to support strategic and operational decisions.
• Develop cost, spend, component forecast, and supplier analytics to support strategic sourcing, procurement, planning, and supply chain strategy.
• Support the Supply Chain organization in defining and standardizing data requirements, KPI definitions, reporting methodologies, and analytical practices.
• Partner with IT and Supply Chain stakeholders on the implementation, enhancement, and optimization of IFS.
• Provide training and support to end users to ensure effective adoption and utilization of analytical tools, dashboards, updated standard work and data models.
• Continuously identify opportunities to improve supply chain processes, data visibility, automation, and analytical capabilities.

Skills

Advanced data analytics

Power BI

Excel

Data modeling

SQL

Process improvement

ERP/MRP systems

Education

Bachelor's degree

Tools

IFS Cloud

SQL

Job description

This opportunity is located within our Ensign-Bickford Aerospace & Defense Company business, a global leader of mission-critical hardware and systems solutions including precision energetics systems and innovative explosive solutions.

Job Description

The Supply Chain Business Analyst is a key contributor within the Supply Chain Center of Excellence, responsible for designing, developing, and implementing advanced data analytics, reporting solutions, and analytical tools that enable effective supply chain decision-making across the organization. This role partners closely with Supply Chain leadership, site Supply Chain Managers, IT, Engineering, Finance, and PMO to deliver trusted, compliant, and actionable data solutions supporting procurement, planning, inventory management, supplier management, strategic sourcing, and materials management. The Supply Chain Business Analyst applies advanced data modeling and analytics capabilities together with strong knowledge of supply chain processes to identify opportunities, improve operational visibility, automate reporting, and develop solutions that enable more effective and efficient supply chain execution. This is a unique opportunity to first play a key role in our upcoming transition to IFS Cloud, reporting to the Project Leader, before transitioning Q2 2027 into the supply chain organization. The near-term role includes learning IFS/MRP capabilities, developing supply chain lobbies, and delivering work instructions to ensure a seamless transition and drive impactful change within the business.

Key Responsibilities

• Design, develop, and maintain advanced data models, analytics, dashboards, and reporting solutions supporting supply chain processes and business decision-making.
• Translate complex supply chain requirements into scalable data and analytical solutions to support procurement, planning, inventory, supplier management, logistics, and strategic sourcing.
• Develop and automate Supply Chain KPI reporting, materials forecasts, inventory analysis, supplier performance analytics, cost analysis, and other operational reporting requirements.
• Analyze complex supply chain data to identify trends, risks, opportunities, and root causes and provide recommendations to support strategic and operational decisions.
• Develop cost, spend, component forecast, and supplier analytics to support strategic sourcing, procurement, planning, and supply chain strategy.
• Support the Supply Chain organization in defining and standardizing data requirements, KPI definitions, reporting methodologies, and analytical practices.
• Partner with IT and Supply Chain stakeholders on the implementation, enhancement, and optimization of IFS.
• Provide training and support to end users to ensure effective adoption and utilization of analytical tools, dashboards, updated standard work and data models.
• Continuously identify opportunities to improve supply chain processes, data visibility, automation, and analytical capabilities.

Qualifications

• Bachelor's degree in Computer Science, Data Analytics, Supply Chain Management, Industrial Engineering, Business, or a related field.
• Must be able to comply with U.S. export control regulations, including the International Traffic in Arms Regulations (ITAR).
• 5+ years of experience in advanced data analytics, business analytics, supply chain analytics, or a related discipline.
• Advanced experience developing data models, analytical solutions, dashboards, and automated reporting.
• Strong understanding of supply chain processes, including planning, procurement, inventory management, supplier management, materials flow, forecasting, and strategic sourcing.
• Strong proficiency with Excel and Power BI; experience with advanced data modeling, data transformation, and business intelligence tools.
• Strong analytical, problem-solving, and critical-thinking skills with the ability to work with complex and disparate data sources.
• Strong written and verbal communication skills, with the ability to communicate complex analytical findings to both technical and non-technical audiences.
• Demonstrated ability to work independently, manage multiple priorities, and lead analytical projects from requirements definition through implementation.

Required Experience

• Experience in the aerospace, defense, space, or highly regulated manufacturing industry.
• Experience with IFS, IFS Cloud, or other advanced ERP/MRP platforms.
• Experience integrating operational data from ERP system into analytical solutions.
• Experience with Power BI data modeling, SQL, or other data analytics/programming tools.
• Experience developing predictive analytics, forecasting models, or advanced analytics.
• Experience with cost, spend, pricing, or supplier analytics.
• Experience developing automated reporting and workflow solutions.

Core Competencies

• Working knowledge of PFEP, SIOP, MRP, materials planning, procurement, inventory optimization, supplier management, and manufacturing operations.
• Advanced Data Analytics & Modeling
• Business Intelligence & Visualization
• Problem Solving & Root Cause Analysis
• Process Improvement & Automation
• ERP/MRP Systems Knowledge

Ensign-Bickford Aerospace & Defense Company is an Equal Opportunity Employer (EOE). Qualified applicants are considered for employment without regard to race, religion, color, sex, age, disability, sexual orientation, genetic information, national origin, or veteran status.