Transportation Clerk

The-Hillman-Group; Kansas City (MO); On-site; USD 39,000 - 42,000; Full time

Job summary

The Hillman Group is seeking a Transportation Clerk to provide administrative support for full and part-time staff and graduate students in Kansas City, MO. You will generate reports using Word, Excel and databases, and help maintain RTS and TMS data to ensure accurate shipping operations.

The role emphasizes daily data entry, schedule review, and coordination with team members to prepare shipments two days ahead. Associate degree preferred; on-site, daytime hours.

Qualifications

• Associate degree preferred or equivalent with one year related experience.
• Proficiency with standard office software (word processing, spreadsheets, databases).
• Ability to identify problems, analyze data and propose solutions.

Responsibilities

• Check/Send email and RTS IDs.
• Open TMS raw data from email and save daily.
• Update information in Excel documents (rename and copy from previous file).
• Review TMS-Schedule by Day data to determine required dollars to route.
• Prepare RTS orders two days out using prior day RTS data.
• Update TMS and RTS files after morning reports.
• Enter raw data into Excel data tab and update inventory/price tabs.
• Ensure accuracy; fix any cell errors affecting reports.
• Coordinate with production planning for Displays and Cradling.
• Mark RTS as ready for ship and communicate RTS confirmations by email.

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.