Peet's Coffee→
Distribution Data Analyst Intern at Peet's Coffee in Emeryville, CA
InternshipOn-siteFull-timeEmeryville, CA$52k–$52k/yr
Skills
sqlpowerbisnowflakewarehouse management system (wms) datadata analysisdata modelingdashboardreport buildingapi integrationoperational efficiency analysisfinancial analysissupply chain analyticsoperations engineeringcuriosity
Job Description
Summary: Peet's Coffee is a company that started a revolution in the craft coffee movement in the U.S. The Distribution Data Analyst Intern will contribute to projects aimed at improving warehouse performance and operational efficiency by analyzing production data and supporting problem-solving initiatives.
Responsibilities:
- Identifying, analyzing, and prioritizing operational inefficiencies across safety, quality, productivity, service, cost, flow, and inventory accuracy
- Using SQL and WMS data to develop insights, dashboards, and performance visibility tools
- Performing root cause analysis and recommending corrective actions to eliminate losses
- Extracting data from the Warehouse Management System (WMS) to model operational trends
- Creating or improving data connections/tools, including building API integrations with Snowflake
- Designing simple, user-friendly tools for supervisors and managers (e.g., calculators, trackers, performance scorecards)
- Assisting in cost-benefit analyses, ROI calculations, and financial justification for operational changes or capital investments
- Supporting capital project execution by providing data, planning, and measurement support
- Evaluating top warehouse safety risks and defining potential solutions
- Implementing standard work for Case Pick, Layer Pick, Full Pallet Pick, Loading, Staging, and Putaway
- Leading or supporting technology transfer and training for new tools or equipment
- Implementing components of a Continuous Improvement Daily Management System
- Analyzing insourcing potential and network optimization opportunities across warehouses / co-packers
Required Qualifications:
- Currently pursuing a degree in Data Analytics, Supply Chain, Industrial Engineering, Operations Management, Computer Science, Statistics, or related fields
- Strong analytical skills and experience with SQL and PowerBI
Preferred Qualifications:
- Familiarity with Snowflake, or WMS/Warehouse data
- Highly motivated, self-driven, and curious with the ability to solve problems and collaborate
- Strong communication and willingness to work on the warehouse floor to understand real operations
Required Skills: SQL, PowerBI, Snowflake, Warehouse Management System (WMS) data, Data analysis, Data modeling, Dashboard, report building, API integration, Operational efficiency analysis, Financial analysis, Supply chain analytics, Operations engineering, Curiosity
Benefits: Recharge Time – Holidays and sick days., Health & Wellness – Medical, dental, and vision coverage., Everyday Perks – Free coffee, fresh baked goods, and discounts.
Benefits
Recharge Time – Holidays and sick days.
Health & Wellness – Medical, dental, and vision coverage.
Everyday Perks – Free coffee, fresh baked goods, and discounts.