Supply Chain Capacity Analyst

Arconic Corporation

Lafayette (IN)

On-site

USD 70,000 - 95,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Arconic Corporation is seeking a Supply Chain Capacity Analyst to develop capacity models across labor, equipment, tooling, and materials. The role uses Excel and ERP data to drive capacity decisions and SOP alignment across manufacturing teams.

You will analyze demand versus capacity, identify bottlenecks, and automate reports to improve throughput, efficiency, and service levels. Strong data acumen and collaboration are essential.

Qualifications

Bachelor’s degree or higher in a relevant field.
Strong proficiency with Excel and data modeling in manufacturing environments.
Experience analyzing capacity across labor, equipment, and materials.
Ability to translate data into actionable insights for SOP and production planning.
Experience managing multiple priorities in a fast-paced setting.
Authorized to work in the United States; visa sponsorship not available.

Responsibilities

Develop and maintain capacity models across constrained resources such as labor, equipment, tooling, and materials.
Analyze demand vs capacity to identify bottlenecks and risks to schedules.
Support finite/infinite capacity planning, scenario modeling, and constraint analysis.
Collaborate with production, engineering, and planning to align capacity with capabilities.
Balance workloads to optimize throughput across lines, shifts, and facilities.
Support SOP and production planning with data-driven insights.
Design, build, and automate capacity reporting tools and dashboards.
Consolidate data from ERP, MES, and other systems into streamlined reports.
Monitor OEE, cycle times, capacity utilization, and throughput to drive improvements.
Validate data and ensure consistency across reports and systems.
Respond to ad hoc requests from operations and supply chain leadership.

Skills

Excel proficiency

Capacity planning

Data analysis

Prioritization

Attention to detail

Communication

Work authorization (US)

Education

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

Tools

ERP systems (SAP/Oracle/MES)

Power BI

Tableau

Advanced Excel (Power Query/Power Pivot/VBA)

Job description

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 (SOP) 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