Import And Export Analyst

Acro Service Corp; Detroit (MI); Hybrid; USD 74,000 - 84,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

Acro Service Corp is seeking a detail-oriented import/export data specialist for a 12-month hybrid role in Detroit. You will gather broker files and ACE data, perform data mining, and support duty recovery and reporting for Finance and Sales teams.

Required 5–10 years in import/export, strong documentation knowledge, and proficiency in Excel, Power BI, and Power Query. Bachelor’s degree in a related field and customs certifications are a plus.

Qualifications

• 5–10+ years in import/export with global shipments.

Responsibilities

• Gather daily broker files and ACE data for merged reporting.

Skills

Import/Export

Documentation

FTA/COO certificates

Tariffs/Classifications

PowerPoint

Excel

Power BI

Power Query

Education

Bachelor's degree in Supply Chain / Logistics / Business Administration

Customs certifications (plus)

Tools

PowerPoint

Excel

Power BI

Power Query

Job description

Duration : 12 months (Possibility of Extension)

Pay Rate: $38/hour on w2/without benefits/no holidays/no vacation

Hybrid position, 4 Days Onsite and 1 Day Remote

Job Description:

Gathering the daily broker files and ACE data for adds to merged reporting file to be used by Finance (pull the ACE data, confirm Buckland’s data is received, push EXL for their data, upload files to the Teams site for Finance, eventually, take this process over from finance on the file mergers, etc.) Plus, this will move to reporting out once a month, these resources could work on the last two weeks of the data to try to make them as complete as possible. Investigate the duty spikes that show in the specific week time frame for the report out meeting (like the Wednesday 12:30 meeting with Lynch) Data mining for escalations report out and further investigation: could be any combination of: HTS, part number, supplier, FTA, duties paid, COO, etc. Data mining and investigations on specific requests coming out of Sales, Purchasing, other areas and summarize findings. Investigate findings of the data mining for accuracy, actions that need to be taken (duty recovery, changes for broker filings, missing documentation, additional FOCUS solicitations, etc.) This requires multiple sources of information, broker spreadsheets, 7501 entry packages, certificates from FOCUS/Program Responses, etc. (This is very labor intensive/time consuming. Post entry/duty recovery efforts; complete backlog of duty recovering filings and on=going opportunities with CBP as identified, monitor broker for actions they need to complete, work with broker on missing Enty package documentation, work through data discrepancies, coordinate meetings needed to close out investigations, etc. Potentially some of the “normal” post entry activity probably should roll into this since there could be multiple corrections/adjustments on a given entry and that way all the necessary corrections/adjustments are completed at the same time This function would also include in the tracking of the duty refunds as they are received and making sure they are allocated back to the G/L code Create periodic reporting/presentations (weekly call with PUR, etc.) Other activities as they are continued to be identified.

Skills and Experience Required:

Minimum 5-10 yrs. import/export experience working with shipment to a variety of global countries Strong working knowledge of shipment/entry documentation, specific documentation requirements and record keeping requirements Various FTA/COO certificate understanding, including eligibility status Strong working knowledge of classifications/tariffs (global experience would be a plus) PowerPoint capabilities Strong data analytical skills (Excel, Power BI, Power Query) Strong reporting capabilities (able to develop, standardize and make mechanical where possible) Strong follow through and follow up skills Detailed Oriented.

Education:

Bachelor’s degree in supply chain, Logistics, Business Administration, or any other related field Any customs related certifications are a plus.