What are the responsibilities and job description for the Intern - Logistics Supply Chain position at G&J Pepsi-Cola Bottlers, Inc.?
Position Summary
The Logistics Analyst Intern position is a combination of Daily Truck Routing, Data Analytics and Project Management. This role is involved in all stages of the Logistics Analysts Day to Day lifecycle including but not limited to supporting the Order / Route / Load aspect of logistics, data pull and analytics from VIP / RTS & Power BI and project management supporting upcoming key projects like Hard Mt Dew & Maysville GA expansion
Essential Functions
Support for RTS move to the Cloud – User Testing, etc
Bachelor’s degree or pursuing a bachelor’s degree from an accredited college/university in Analytics, Logistics, Information Systems, Business Management, Finance or equivalent work experience.
Experience
Requires 0-1 year of experience in the related area.
Computer Skills
Knowledge of Microsoft Office Suite, Intermediate to Advanced Excel skills, Power BI, VIP, SQL, Access. Other Routing software applications a plus
Certificates & Licenses
Valid Driver's License or demonstrable ability to gain access to worksites.
Additional Requirements
Skills in: Project management, problem solving, troubleshooting, internal customer service. Ability to: collaborate effectively with internal customers and vendors, develop good working relationships. Other functions, skills and abilities may also apply.
The Logistics Analyst Intern position is a combination of Daily Truck Routing, Data Analytics and Project Management. This role is involved in all stages of the Logistics Analysts Day to Day lifecycle including but not limited to supporting the Order / Route / Load aspect of logistics, data pull and analytics from VIP / RTS & Power BI and project management supporting upcoming key projects like Hard Mt Dew & Maysville GA expansion
Essential Functions
- Routing Support for Logistics Analysts
- Importing Orders
- Loading Combo / GEO
- Routing Combo Trucks
- Juice Truck Routing
- Practice sessions leading to routing small locations (ATH / ZAN / etc)
- Routing Pass Construction
- Update new accounts in Combo Routing Pass
- Checking Paperwork / Marking Ready
- Support for Maysville transition
- Data Pulls
- Data scrub
- Data analysis
- Support Routing Optimization Mgr on ReRoute
- Power BI reporting – Upgrading Current reporting / Analyze what else is needed
- Analysis on FSV service times due to Gaps in Cantaloupe / Telemetry
- Hours of Service report for TAM’s
- Weekly TAM Merch uploads
- Analysis on Combo Routes – Planned vs Actual time by Driver
- GreenMile Maintenance
- New EE Setup
- Login Issues
- New Product additions in RTS
- New Customer setup RTS – Equip / TW / Priority
- Review current / ID errors
- Time Window Analysis
- Comparison by Chain
- Less than 4 hrs
- Open after 9:00 - Retail
- Online Portal Support
- Teams Channel Analysis
- Service Time analysis at Customer level
- Route needs for Hard Mt Dew (Ohio Maysville Cust KY Franklin Furnace Customers)
- Collaborative Routing due to Cloud
- Columbus ReRoute Post Analysis
- TAM Territory Analysis – Stops / Service Time / Mileage / Tot Hrs
- Vacation coverage
- SIPP Calls
- SOM period Reviews Participation
Bachelor’s degree or pursuing a bachelor’s degree from an accredited college/university in Analytics, Logistics, Information Systems, Business Management, Finance or equivalent work experience.
Experience
Requires 0-1 year of experience in the related area.
Computer Skills
Knowledge of Microsoft Office Suite, Intermediate to Advanced Excel skills, Power BI, VIP, SQL, Access. Other Routing software applications a plus
Certificates & Licenses
Valid Driver's License or demonstrable ability to gain access to worksites.
Additional Requirements
Skills in: Project management, problem solving, troubleshooting, internal customer service. Ability to: collaborate effectively with internal customers and vendors, develop good working relationships. Other functions, skills and abilities may also apply.