Sr. Analyst, Transportation (2 Month Temp Assignment)

Sr. Analyst, Transportation (2 Month Temp Assignment)

We are searching for an experienced Sr. Analyst, Transportation (2 Month Temp Assignment) at our Headquarters facility.


Hyundai MOBIS Parts America

We think creatively and keep challenging ourselves to help create a new future and eventually make humankind's dreams a reality. Ready for the challenge?

Who We Are

Tomorrow's most advanced automotive technology is being envisioned today at MOBIS Parts America (MPA). A subsidiary of Hyundai MOBIS, we are a top leading automotive parts supplier. Mobis provides after-sales service parts support for Hyundai Motors, Kia Motors, and Genesis. In addition to the distribution of genuine service parts and accessories, Mobis produces chassis, cockpit, and front-end modules; safety products, including airbags; headlights; anti-lock brake systems and electronic stability control products; steering parts; multimedia systems; UVO systems; injection-molded plastic parts, such as instrument panels, carriers, and bumpers; and steel wheel rims and decks.

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.

Required Qualifications

Education Requirements

• Bachelor's 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 carrier-related 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).
• Intermediate-Advance 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.

Employment Type - Non-Exempt

Compensation - Hourly Wage , $62,518.54 - 92,214.85

Hyundai Mobis Parts America - Benefits

We offer a competitive benefits package for full-time 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!

Our company provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.