Transportation Analyst I
About The Position
The Transportation Analyst I evaluates and designs transportation and distribution procedures to improve delivery efficiency, reduce costs, and support customer satisfaction. The role analyzes freight costs, delivery methods and schedules, transportation costs, equipment availability, and service levels. It maintains freight, network, and carrier data; supports rate negotiations, cost studies, carrier reporting, month-end freight reconciliation, and freight invoice audits. The analyst uses Microsoft Excel to organize, analyze, and report transportation data. The role may also support foreign merchandise production coordination, customs documentation, and resolution of incoming-freight delays with customs officials.
Requirements
- Bachelor's degree preferred, or an equivalent combination of education and experience.
- Knowledge of principles and methods for moving goods by air, rail, sea, or road, including the relative costs and benefits of each mode.
- Basic understanding of transportation and logistics concepts.
- Proficiency in Microsoft Excel, including creating spreadsheets, using formulas, sorting and analyzing data, and generating reports.
- Experience with PivotTables, VLOOKUP/XLOOKUP, and basic data analysis is preferred.
- Strong analytical and problem-solving skills with attention to detail.
- Ability to learn transportation reporting, freight auditing, and carrier performance measurement processes.
- Effective written and verbal communication skills.
- Ability to work independently and collaboratively in a team environment.
Nice To Haves
- Familiarity with Transportation Management Systems (TMS).
- Bachelor's degree.
- Experience with PivotTables, VLOOKUP/XLOOKUP, and basic data analysis.
Responsibilities
- Research and analyze freight costs and classifications, delivery methods, and delivery schedules to minimize delivery costs and maximize customer satisfaction.
- Maintain databases of freight costs, transportation networks, and carrier information.
- Assist in negotiating transportation rates in accordance with company guidelines and standards as needed.
- Analyze transportation costs, equipment availability, and service levels.
- Conduct cost studies to evaluate transportation alternatives and identify cost-saving opportunities.
- Support preparation of monthly carrier performance and transportation reports.
- Assist with month-end freight reporting and reconciliation activities.
- Review and audit freight invoices for accuracy, identify discrepancies, and assist with issue resolution.
- Use Microsoft Excel to organize, analyze, and report transportation data.
- May assist in coordinating foreign merchandise production, quota, customs documentation, and transportation.
- May work with customs officials to help resolve delays and obtain release of incoming freight.
Benefits
- Tuition reimbursement
- Medical, dental, and vision insurance
- Prescription drug coverage
- 401(k) retirement plan
- Short-term disability insurance
- 8 weeks paid birthing leave
- 2 weeks paid bonding leave
- Life and long-term disability insurance
- Up to 12 days paid time off, depending on date of hire and eligibility
- 2 paid well-being days
- 1 paid volunteer day
- 10–11 paid holidays
- 3 floating holidays per year
- Eligibility for an annual bonus in accordance with the applicable company plan
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
