Sr Analyst of Transportation

Description

The Sr. Transportation Analyst is responsible for the data processing in the Transportation department related to freight costs for Inbound & Outbound shipments through oversight of all Access database functions in the department. The Sr. Analyst will validate and provide all RFQ and AMOS data by gathering and analyzing shipment history and freight costs of approximately $100 million annually.

This position will manage carrier and vendor RFQ/RFP specifications and processes. Through weekly and monthly reporting the Sr. Analyst will audit and report the expense of international and domestic transportation versus budgeted amounts and make recommendations for cost savings/reductions. Transportation expenses will be maintained via data obtained from web reporting and query data to explain cost trends. This position will administer communicate and prepare MPA Freight Payment expense reporting for MHQ and executive management including narrative analysis comparing performance to objectives. Service transit times reported from carrier websites will be monitored along with improvement opportunities provided to department managers.

The Sr. Analyst will be the Subject Matter Expert (SME) on Access database processes and will provide training and guidance to other team members as needed. Heavy involvement in special projects including presentations/decks relating to cost studies will be required/performed as management needs. The Sr. Logistics Analyst is expected to operate within the policies and procedures established by the Transportation Department and to adhere to generally accepted business practices. The Sr. Transportation Analyst is expected to identify and resolve issues arising within the areas of responsibility with minimum supervision. (KPIs: Maintain and create transportation databases weekly and as needed; Provide analysis of all inbound and outbound freight expenses weekly/monthly; Review and report department freight spend trends against Department objectives weekly/monthly; Carlisle Subject Matter Expert (SME) manage/produce department data annually or as requested for industry benchmarking purposes.)

Key Responsibilities

• Maintain and create transportation databases as needed and provide analysis of all inbound and outbound freight expenses.
• Update funding documents from the freight payment service website to MPA internal Access databases.
• Update weekly/monthly summary of freight cost versus sales for MPA Review and provide trend analysis to management.
• Recommend carrier and/or mode of transportation changes based on freight expenditures to meet department KPIs/goals.
• Advise freight auditor of weekly files to analyze for possible cost savings.
• Run and distribute monthly HMA and KUS Active Dealer reports.
• Carlisle subject matter expert pull and analyze data as required.
• Run AMOS data warehouse queries as needed for reporting and special projects.
• Provide a monthly forecast of freight spending to Finance.
• Maintain and update carrier files for current insurance and rates.
• Administer the carrier or vendor RFP process and provide management with cost analysis. Recommend carriers/vendors based on service/cost comparisons.
• Work with the Systems Department to improve internal data processes.
• Provide ad hoc reports presentations decks and cost studies as needed by management.

Work Schedule & Travel Requirements

• Monday through Friday 8:00 AM 5:00 PM
• Hybrid work schedule
• Occasional overnight travel (up to 20%) by land and/or air.

Education Requirements

• Bachelors Degree in Business Administration or Finance or a related field.

Experience Requirements

• Minimum of five years experience in related logistics activities such as freight rates freight bill auditing and other sea/air/land carrierrelated activities.
• Minimum of three years of analysis and data mining experience preferably within the automotive industry in the area of traffic/logistics/parts warehouse and claims.

Skills

• Strong working knowledge of SQL (structured query language) and QMF (query management facility).
• IntermediateAdvance skills in MS Office: Excel Word and Powerpoint.
• Intermediate skills in MS Access. Ability to create tables forms charts queries macros and create and maintain new and existing databases as needed.
• Strong analytical skills
• Previous experience with importing data files from mainframes and test formats to MS Excel/Access.
• Strong oral and written communication skills.

Benefits

We offer a competitive benefits package for fulltime employees which include:

• Medical Dental and Vision
• 401K with employer matching
• Tuition Reimbursement
• Paid Vacation Paid Sick Days and Paid Holidays
• Mapped career plans; we believe in developing and promoting our talent!
• Company Discounts & more!