Customs Specialist Data Analyst

About this role

Join our global team for a career filled with opportunities to solve challenges both small and large, local and global, simple and complex.

Main Responsibilities

• Build, maintain and continuously improve customs data sets covering imports, exports, internal transfers and duty-recovery activities (including duties, tariffs, ADD/CVD, MPF, HMF and related charges).
• Consolidate data from brokers’ systems, ACE reports, IFS, freight providers and 3PLs into standardized formats suitable for analysis and audit.
• Perform data mining and data quality checks to identify gaps, inconsistencies, and anomalies in customs-related data (e.g. mis-classified HTS, inconsistent units of measure, missing country codes, missing signatures).

Develop regular and ad-hoc reports/dashboards (e.g. in Excel, Power BI or similar) to Duties and trade remedies paid, Liquidation status and timelines, Duty drawback opportunity pipeline, Storage/hold charges and other customs-related costs.
Automation & Process Improvement

• Design and maintain automation solutions (queries, templates, macros, Power

Query/Power Pivot flows, or similar tools) to streamline recurring customs data tasks (e.g. monthly duty summaries, drawback support files, 7514/7511 support lists).

• Collaborate with IT / IFS support to improve data capture and system configurations that affect customs compliance (e.g. HTS codes, ADD/CVD flags, country codes, Incoterms, units of measure).
• Document data flows, calculation logic and automation routines so that they are transparent, auditable and can be maintained by the wider Customs team.

Support to Customs Compliance & Operations

• Support Yesenia Sauceman and the Customs team in performing entry audits by providing clear data extracts and exception reports highlighting potential errors in valuation, classification, tariff treatment or ADD/CVD exposure.
• Provide data and analysis needed for: Post Summary Corrections (PSCs) and Protests, Duty drawback claims and r...