Customs Analyst Detroit

Customs Analyst, Import/Export, Shipment, FTA/COO, MS Powerpoint, MS Excel, Power BI, Power Query, Record Keeping If you post this job on a job board, please do not use company name or salary. Experience level: Mid-senior Experience required: 10 Years Education level: Bachelors degree Job function: Supply Chain Industry: Automotive Pay rate : View hourly payrate Total position: 1 Relocation assistance: No Visa sponsorship eligibility: No Position Description: Functions: Gathering the daily broker files and ACE data for adds to merged reporting file to be used by Finance (pull the ACE data, confirm Bucklands 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 Required: Minimum 510 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. Experience Required: Minimum 510 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) Education Required: Education Requirement: Bachelors degree in supply chain, Logistics, Business Administration, or any other related field Any customs related certifications are a plus Additional Information: This is a minimum 12-month contract for a hybrid role, requiring 4 days in the office and allowing 1 remote day per week. Shift timing will be flexible. MUST HAVE Bachelors degree in supply chain, Logistics, Business Administration, or any other related field. Minimum 510 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).