Transportation Clerk

The Hillman Group, Inc.•Kansas City, MO

3d•Onsite

About The Position

The Transportation Clerk supports logistics and transportation operations by maintaining accurate records and helping daily shipping activities run smoothly. The role works closely with transportation, production, and logistics teams and uses Excel and systems such as TMS, RTS, and Sage to keep orders moving efficiently.

Requirements

Strong attention to detail and accuracy.
Comfort working in Excel, including multiple tabs, formulas, and data entry.
Ability to learn and navigate systems such as TMS, RTS, and Sage.
Clear communication skills and a collaborative mindset.
Reliable, organized, and able to manage daily workflows independently.

Responsibilities

Manage daily email communication, including RTS IDs and shipment confirmations.
Open, save, and organize TMS raw data files and maintain accurate daily documentation.
Update Excel spreadsheets across data, invoice, inventory, and stock status tabs.
Review TMS “Schedule by Day” to determine routing needs and required dollar amounts.
Process RTS orders two days ahead using previous-day files.
Update TMS and RTS files after receiving morning reports.
Research and correct data errors, such as pallet sizes, to ensure accurate reporting.
Coordinate with production team members regarding displays, cradling, and calibration needs.
Mark purchase orders as “Ready to Ship” and plan ahead using daily RTS updates.
Use TMS Supplier Hub to review purchase orders, apply filters, update ready-to-ship status, and calculate cubic feet.
Record RTS confirmation numbers and send updates to internal team members.
Check Delivered/Transit tabs to verify PO commitment status and locate BOLs.
Submit overage tickets for purchase orders left off trucks.