Data Analyst - Operations & Capacity Planning
The Data Analyst - Operations & Capacity Planning at Confidential Client is responsible for producing accurate KPI dashboards, operational reports, and capacity forecasts for warehouse and transportation functions. This role ensures data quality, analyzes trends and variances, and supports supply chain decision-making by delivering reliable operational visibility and forward-looking analysis. The position requires strong analytical skills and expertise in Excel and Power BI to improve reporting consistency and forecasting tools within a supply chain environment.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Semiconductor Manufacturing.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
What You’ll Do
Confidential Client is seeking a Data Analyst (Operations & Capacity Planning) to produce reliable KPI dashboards, recurring operational reports, and forward-looking warehouse and transportation capacity forecasts. You will support Program Management, Freight, and 3PL/Warehouse Operations with actionable insights and scalable reporting.
- Develop, maintain and validate recurring performance dashboards and operational reports using agreed KPI definitions (Power BI, Excel or comparable tools).
- Analyze trends, variances and exceptions; communicate significant deviations and data gaps to operating owners.
- Produce forecasts of warehouse space utilization, storage requirements and receiving/shipping throughput using workload, inventory and operating data.
- Forecast planned shipment volumes, lane demand and trucking capacity requirements; surface emerging transportation capacity gaps to Freight and Program Managers.
- Maintain forecast-versus-actual comparisons, document assumptions, and update models using approved methodologies.
- Validate source data, investigate discrepancies with data owners, and document limitations that affect reported metrics and forecasts.
- Improve and standardize existing Excel and Power BI reporting/forecasting tools; support Technology with business requirements and testing for reporting changes.
- Sequence routine reporting and forecasting assignments per VP-established priorities and escalate conflicting priorities when needed.
- Note: This role provides analysis and recommendations only — it does not award freight, commit capacity purchases, or make site-level provider decisions.
Who We're Looking For
Required
- Relevant degree or equivalent practical experience in data analysis, supply-chain analytics, logistics or operations reporting.
- ~2+ years of analytical experience in KPI reporting, dashboard development, or capacity planning.
- Strong Excel skills and experience with Power BI or similar BI/dashboard tools.
- Ability to validate data, explain variances, and present clear operational insights.
- Working understanding of warehouse throughput, capacity/utilization, freight volumes or transportation demand.
Preferred
- Experience with multi-site 3PL, electronics supply chains, contract manufacturing or outsourced logistics.
- Exposure to WMS/TMS/ERP reporting, Power Query, basic SQL, data transformations or forecasting models.
Key Competencies
- Analytical reasoning and structured problem solving
- Data accuracy and validation discipline
- Forecasting and scenario modeling
- Dashboard development and version control
- Operational communication and escalation judgment
- Process improvement and documentation
Compensation & Benefits
- Base salary: $90,000 – $110,000 per year (listed range reflects current posting).
- Benefits include: 401(k), health insurance, dental, vision, health savings account (HSA), flexible spending account (FSA), life insurance, long-term disability, paid holidays and paid time off.
(Compensation is provided to satisfy pay-transparency requirements for listings in California.)
Location & Work Type
- Location: Newark, CA (on-site).
- Position level: Specialist / Individual Contributor.
- Travel: None expected (limited if required).
Confidential Client is committed to complying with all applicable federal, state and local employment laws where this role is posted.
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range