"Alerted.org

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

Pay and Benefits

The pay range for this position is $35.00 - $40.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

• Medical, dental & vision • Critical Illness, Accident, and Hospital • 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available • Life Insurance (Voluntary Life & AD&D for the employee and dependents) • Short and long-term disability • Health Spending Account (HSA) • Transportation benefits • Employee Assistance Program • Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a fully onsite position in Troy,MI.

Application Deadline

This position is anticipated to close on Jun 19, 2025.

About Aston Carter:

Aston Carter provides world-class corporate talent solutions to thousands of clients across the globe. Specialized in accounting, finance, human resources, talent acquisition, procurement, supply chain and select administrative professions, we extend the capabilities of industry-leading companies. We draw on our deep recruiting expertise and expansive network to meet the evolving needs of our clients and talent community with agility and excellence. With offices across the U.S., Canada, Asia Pacific and Europe, Aston Carter serves many of the Fortune 500. We are proud to be a ClearlyRated Best of Staffing® double diamond winner for both client and talent service.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email [email protected] (%[email protected]) for other accommodation options.