Logistics Analyst

Description

Full-service tier 1 automotive interior and exterior trim manufacturer is seeking an analyst to support their purchasing / finance team. Mainly plastics but they do some aluminum and steel. Since February they have been taking on Tariff costs as they import materials and products due to the new administration, however they have had trouble keeping track of the actual tariff cost of each level of part/product and how much to actually invoice the customer as they are passing this cost back. Right now they have nearly 1,000 invoices that need to be reviewed and have a cost/invoice report built out for so they can identify what the actual tariff cost was and create each customer invoice accordingly. Cost of the impact is them trying to recover north of 1 million dollars in tariff related costs.

They need someone to:

- Review the invoice for part identification numbers and associate a cost with each item

- Review the actual tariff implication at that time as the numbers have been changing what seems like weekly/monthly

- Review bill of landing and bill or materials to make sure they are properly identifying tariff cost per part

- Work within internal ERP system for resolutions

- Review the HTS codes within the 14 different brokers to identify and formalize costs

- Will be using 3-4 different systems/documents to find and document the info (Electronic records from the ERP/Excel files/PDF's/Scanned in Invoices and possible others)

Main goal will be to sift through all the information they have to properly invoice the customers for the last 6 months of tariffs in hopes to recover the 1 million plus they've spend.

The process for how they will do this is still being built out, however they have to have experience with ERP's, Excel, Bill of lading and Materials and Data Analysis to know how to / where to pull info from even when they process is in place.

Training will be a week - learning the HTS Codes, the 14 Brokers/Importers they work with and a process they will use to start working through the invoices.

Project will go about 12 weeks, M-F 8am - 5pm onsite in Troy

Skills

Logistics, Supply chain, Purchasing, Purchase order, bill of material, bill of lading, Data entry, Data analysis, Erp, excel data entry, automotive parts

Additional Skills & Qualifications

Must have:

- Logistics Background

- ERP experience in some sort of Accounting role

- Strong excel experience

- Knowledge / experience with Bill of Materials / Bill of Lading

- Billing and Invoice experience

Nice to have:

Automotive experience / automotive parts knowledge

ERP - MAPEX experience

Experience Level

Intermediate Level