Intern - Logistics Supply Chain

G&J Pepsi-Cola Bottlers, Inc. • Columbus, OH

9d

About The Position

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

Requirements

• 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.
• Requires 0-1 year of experience in the related area.
• Knowledge of Microsoft Office Suite, Intermediate to Advanced Excel skills, Power BI, VIP, SQL, Access. Other Routing software applications a plus
• Valid Driver's License or demonstrable ability to gain access to worksites.
• 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.

Responsibilities

• 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)
• Support for RTS move to the Cloud – User Testing, etc
• 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

What This Job Offers

• Career Level: Intern
• Number of Employees: 251-500 employees