Transportation Clerk

Hillman Group; Kansas City (MO); Hybrid; USD 33,000 - 45,000; Full time

Job summary

Hillman Group is seeking a transportation clerk to provide administrative support for cross-functional teams and graduate staff. The role involves handling emails, preparing RTS orders, and updating TMS/RTS data in Excel, ensuring accuracy and timely shipping readiness.

The position requires attention to detail, ability to manage multiple data sources, and a willingness to collaborate with colleagues on production planning and routing tasks.

Qualifications

• Problem solving and analytical thinking to identify issues and propose solutions.
• Resilience to work under pressure and adapt to changing priorities.
• Commitment to continual learning and self-improvement.

Responsibilities

• Check and send emails and RTS IDs as needed.
• Open TMS raw data from email and save to documents.
• Update information into Excel and rename files.
• Review daily data to determine funds needed for routing.
• Prepare RTS orders two days out and update RTS & TMS files.
• Ensure accuracy by correcting errors in cells and recalculating as needed.
• Coordinate with team to review production plans and shipments.
• Coordinate RTS and PO visibility in TMS for timely shipments.
• Prepare RTS confirmation numbers and email them to stakeholders.

Skills

Problem Solving

Resilience

Continual Learning

Education

Associate degree preferred

Job description

Job Summary

Schedule: 6:00 am - 3:00 pm (Monday - Thursday) & 6:00 am - 12:00 pm (Friday)

Hourly Pay Rate: $18.75

Transportation clerk provides administrative support for full and part time professional staff members and graduate students; provides reports and correspondence by utilizing various software programs including word processing, spreadsheets, and databases.

Essential Job Functions *

• Check/Send email (RTS Id’s: If not done already)
• Open TMS raw data (pm) from email (I save them in documents daily)
• Update new info into excel document (copied and pasted in documents from previous file; rename)
• Review TMS- Schedule by Day data to see dollar amount needed to route
• Work from previous day RTS file and begin getting orders RTS (2 days out)
• Update TMS and RTS files after am report from email
• Updating RTS files consist of raw data report inputted into excel data tab
• sage: stock status report, exported to excel; copied and then pasted in stock status tab
• sage: sales order lines (if sales price needed) invoice tab- Update inventory tab from item summary tab
• Updating TMS file consist of raw data inputted into excel data tab and update necessary prices in invoice price tab
• Any error in a cell must be fixed to report properly, for example, pallet size tab incomplete/missing will give an error - research how many pieces on a pallet for that item and record in that tab
• Review Production plan for Displays and Cradling, calibrating with Andrew, Ken, and Shae when needed
• In updated RTS (daily) file mark PO’s ready for ship (I try to plan ahead from previous day RTS file)
• TMS Supplier hub portal - TMS- Purchase Order - Views- Primary Fields (pickup start-dates wide range) - add conditions (ready to ship = No or partial, destination facility = RTS #, purchase order = PO #’s)
• Apply- ready to ship tab- select date and input cubic feet calculations (# of Pallets divide by 50 times 3000), right click save, record RTS confirmation # in RTS excel beside marked yes-ok to ship
• Send email to Susan/Monica/Kilah with RTS confirmation #
• View Delivered and Transit tab in TMS - find if a PO is committed or not in Mobe, locate BOL if committed, ask Rachel to commit if not committed.
• Submit overage tickets for PO’s left off truck

* This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice.

Employees are expected and encouraged to participate in safety and health program activities including immediately reporting hazards, immediately reporting unsafe work practices and incidents to supervisors, wearing required personal protective equipment, and participating in and supporting safety committee activities.

Education & Experience

• Associate degree preferred or the equivalent in education and one-year related experience.

Competencies – Knowledge, Skills, and Abilities

• Problem Solving - Identifies and analyzes problems; weighs relevance and accuracy of information; evaluates and generates alternative solutions; makes recommendations.
• Resilience - Positively impacts the team and the organization by dealing effectively with pressure; remains optimistic and recovers quickly from setbacks.
• Continual Learning - Assess and recognizes own strengths and weaknesses; pursues self-development.

Operational Equipment

• N/A

Work Environment and Physical Demands

Work Environment

Office: Office setting. Seldom exposed to fumes or airborne particles. Loud working environment of the shop area. Functional vision and hearing required.

Physical Demands

Office: Sedentary.