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