Senior Capacity Planning Analyst

Key Responsibilities

• Own and continuously improve capacity planning processes, models, and reporting infrastructure across assigned product lines and manufacturing partners.
• Translate demand forecasts and SIOP outputs into resource-constrained production plans, incorporating supplier lead times, yield, equipment, and labor constraints.
• Design and execute multi-scenario capacity models (e.g., demand volatility, NPI ramps, supplier allocation shifts) and provide data-driven recommendations with clear trade-offs.
• Develop and maintain an 18-month rolling capacity forecast in partnership with Supply Planning and Business Units, accounting for product ramps and shifting customer demand.
• Identify, quantify, and prioritize systemic bottlenecks and capacity risks; lead cross-functional initiatives to resolve constraints.
• Data Engineering, Reporting & Automation
• Build and manage data pipelines (ETL) that extract, transform, and load data from internal and external sources (Databricks, Oracle, APIs, Excel) into reporting environments.
• Set up and maintain API connections to automate ingestion of operational, supply chain, and manufacturing data.
• Design and develop Power BI dashboards, visualizations, and heatmap reporting to highlight shortages, supply gaps, capacity constraints, and recovery plans.
• Generate Oracle database reports and ensure data accuracy, governance, and reporting consistency across planning systems.
• Develop and automate recurring reports to support planning, forecasting, inventory/WIP visibility, and operational decision-making.

Cross-Functional Partnership & Communication

• Partner with Supply Chain, Operations, Engineering, IT, Finance, and Business Units to identify reporting needs, align capacity plans, and implement automation solutions.
• Serve as the capacity planning point of contact for assigned programs or product families, providing weekly status updates covering availability, recovery plans, and schedule risk.
• Manage reporting and automation projects end-to-end, from requirements gathering through deployment, documentation, and user adoption.
• Communicate planning risks, capacity trade-offs, and data-driven recommendations to stakeholders and leadership in a clear and actionable manner.
• Support NPI and product ramp activities by translating engineering builds and qualification timelines into capacity and throughput models.