Supply Chain Capacity Analyst

The Supply Chain Capacity Analyst is responsible for developing, maintaining, and analyzing capacity and production reports to support manufacturing operations and supply chain decision-making. This role focuses on evaluating capacity across multiple constrained resources—including labor, equipment, and materials—to ensure alignment with demand and production goals.

The position works extensively with Microsoft Excel and other analytical tools to organize, validate, and automate reporting processes, providing accurate and timely visibility into production capacity, constraints, and utilization.

The ideal candidate is highly detail-oriented, experienced in manufacturing environments, and skilled at translating complex operational data into actionable insights that improve throughput, efficiency, and service levels.
 

Manufacturing Capacity Planning

• Develop and maintain capacity models across multiple constrained resources, including labor, machinery, tooling, and material availability.

• Analyze demand versus available capacity to identify bottlenecks, constraints, and risks to production schedules.

• Support finite and infinite capacity planning processes, including scenario modeling and constraint-based analysis.

• Partner with production, engineering, and planning teams to align capacity plans with manufacturing capabilities and schedules.

• Assist in balancing workloads across production lines, shifts, and facilities to optimize throughput.

• Support Sales & Operations Planning (S&OP) and production planning processes with data-driven insights.

Capacity Reporting & Automation

• Design, build, and automate capacity reporting tools and dashboards to improve speed, accuracy, and usability.

• Create standardized reports to track utilization, efficiency, downtime, and throughput across manufacturing operations.

• Reduce manual reporting by implementing automated data flows, templates, and repeatable processes.

• Consolidate data from ERP, MES, and other systems into streamlined reporting solutions.

• Continuously improve reporting processes to enhance visibility into capacity constraints and opportunities.

Operations & Performance Analysis

• Track and analyze key manufacturing metrics such as capacity utilization, Overall Equipment Effectiveness (OEE), cycle times, and production output.

• Perform data validation and reconciliation to ensure consistency across systems and reports.

• Identify trends, inefficiencies, and root causes of capacity limitations or production delays.

• Provide insights and recommendations to support continuous improvement and operational efficiency initiatives.

• Respond to ad-hoc reporting and analysis requests from operations and supply chain leadership.

General Data & Collaboration Responsibilities

• Document data sources, assumptions, methodologies, and report logic.

• Collaborate cross-functionally with manufacturing, supply chain, procurement, and engineering teams to understand data and reporting requirements.

• Communicate findings clearly and effectively to both technical and non-technical stakeholders.

• Maintain data integrity and confidentiality of operational and business-sensitive information.

Qualifications

Required

• Bachelor’s degree in Supply Chain, Operations Management, Industrial Engineering, Manufacturing Engineering, Business Analytics, or related field.

• Strong proficiency in Microsoft Excel, including: 

  • VLookup/HLookup/XLookup

  • Nested formulas

  • Pivot tables and charts

• Experience working with large datasets and building structured reports in a manufacturing or operations environment.

• Strong understanding of capacity planning concepts and production processes.

• Demonstrated ability to manage multiple priorities and meet deadlines in a fast-paced manufacturing setting.

• Strong attention to detail with a focus on data accuracy and integrity.

• Employees must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire. Visa sponsorship is not available for this position.

• This position requires access to controlled technology, as defined in the Export Administration Regulations (15 C.F.R. §730, et seq.) and/or the International Traffic in Arms Regulations (ITAR). Authorization from the relevant government agency may be required to meet export control compliance requirements.

Preferred

• Experience in manufacturing environments with multiple resource constraints (labor, equipment, materials).

• Proven experience automating capacity or operational reporting processes.

• Familiarity with ERP and manufacturing systems (e.g., SAP, Oracle, MES systems).

• Experience with data visualization tools (Power BI, Tableau) and/or advanced Excel (Power Query, Power Pivot, VBA).

• Understanding of Lean manufacturing, Six Sigma, or continuous improvement methodologies.

• Knowledge of S&OP, production scheduling, and inventory planning processes.

• Strong communication skills with the ability to translate complex operational data into actionable insights.

Key Competencies

• Analytical Thinking & Constraint-Based Problem Solving

• Manufacturing & Capacity Planning Expertise

• Data Accuracy and Integrity

• Process Automation & Continuous Improvement

• Organization and Time Management

• Cross-functional Collaboration

• Clear and Effective Communication

#LI-JM1