Trade Data Consultant

Job Description

Client: Top # 5 Consulting Firm

Title: Trade Data Consultant

Location: Remote (Client is in Central Time Zone)

Duration: 9-Month Project

Pay: $95-$105 per hour (W2) 1.5x (Overtime)

Overview

We are seeking a Trade Data Consultant with strong knowledge of U.S. trade regulations, customs systems, and data analytics to support compliance, reporting, and strategic initiatives for a global consulting client.

Key Responsibilities

• Support trade compliance activities by leveraging knowledge of the U.S. Customs Automated Commercial Environment (ACE), with an emphasis on Entry Summary and Reporting modules.
• Analyze and interpret U.S. tariff classifications, including supplemental and reciprocal tariffs (e.g., Section 232) and provisions under Chapter 99, Subchapter III of the HTSUS .
• Manage, clean, and transform trade datasets to support compliance, audits, and advisory engagements.
• Build reports and visualizations that summarize complex trade and tariff data for both technical and non-technical stakeholders.
• Collaborate with consulting teams to design solutions that integrate trade knowledge with data engineering, wrangling, and analytics
  
  

Required Qualifications

• Familiarity with ACE system, particularly Entry Summary and Reporting modules.
• Knowledge of supplemental tariffs, reciprocal tariffs, and HTSUS Chapter 99 (Subchapter III) provisions.
• Strong proficiency in Microsoft Excel , including formulas such as VLOOKUP, SUMIF/COUNTIF, and dataset manipulation.
• Data wrangling
• Data engineering
• Data visualization
  
  

Preferred Qualifications

• Advanced Excel skills (e.g., SORT, FILTER, UNIQUE array functions).
• Alteryx
• Microsoft Power Platform (Power Query, Power BI, Power Apps) or equivalent
• Tableau
• SQL
• Python, R, VBA, etc.
  
  

#PCFA