Location: Onsite M-F with 1 hour lunch
10913 S River Front Pkwy, South Jordan, UT 84095
Duration: Minimum of 12 weeks (with potential extension based on project scope and business needs)
Project: Rail Billing Reporting & Automation
Who is OOCL - OOCL (Orient Overseas Container Line) is one of the world's largest integrated international container transportation and logistics companies. OOCL is well respected in the industry with a reputation for providing customer-focused solutions, a quality-through-excellence approach, and continual innovation. It is also an industry leader in the use of information technology and e-commerce to manage the entire cargo process.
The Project Overview - This 12‑week internship will focus on automating rail billing KPI reporting and improving operational efficiency by reducing unnecessary email volume. The intern will partner closely with the rail billing and operations teams to streamline reporting, enhance data visibility, and help redirect non‑actionable requests to the appropriate channels. This internship offers hands‑on exposure to business process improvement, data analysis, and automation within a fast‑paced logistics and transportation environment.
Project Outcomes:
-
Gain real‑world experience in reporting automation and operational analytics
- Learn how KPIs are measured and utilized in rail and logistics billing operations
- Contribute to efficiency improvements that reduce manual effort and unnecessary work
-
Develop professional experience collaborating with cross‑functional business teams
Internship Responsibilities:
- Automate daily rail billing KPI data to support daily, weekly, and monthly reporting
- Create visual dashboards or reports to highlight trends, gaps, and immediate action items
- Support the development and automation of a monthly rail billing report
- Analyze incoming rail billing emails and classify them as submitted, actioned, or pending
- Review historical email data to identify opportunities to prevent unnecessary rail billing inquiries
- Assist in redirecting requestors to appropriate self service tools (e.g., supplier portal)
- Help reduce non rail billing related email traffic in rail billing mailboxes
- Document processes and provide recommendations for long term reporting and communication improvements
Qualifications:
- Currently pursuing or recently completed coursework in Business, Analytics, Supply Chain, Information Systems, or a related field
- Strong experience with Microsoft Excel (data manipulation, formulas; automation exposure a plus)
- Working knowledge of Microsoft Outlook
- Interest or experience in reporting, automation, or process improvement
- Strong analytical, organizational, and problem-solving skills
- Ability to work onsite in South Jordan UT (SLC location) for the duration of the internship
Skills:
- Strong attention to detail and accuracy
- Comfortable working with Excel for organizing and reviewing data
- Ability to spot patterns, trends, and inconsistencies in reports and emails
- Interest in improving processes and reducing manual work
- Clear written communication and professional email etiquette
- Ability to stay organized and manage recurring tasks
- Willingness to learn reporting and automation tools
- Ability to work collaboratively with operations and billing teams
All employment is contingent upon the successful completion of a background check
OOCL is an Equal Opportunity Employer and offers a diverse, inclusive, and equitable work environment. OOCL does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. For more information, we encourage you to visit us at www.oocl.com.