Data Analyst - Drawback Reconciliation

Job Title: Data Analyst - Drawback Reconciliation

Location: Houston, TX (Hybrid)

Estimated Duration: 6 Months
 

 

Position Summary

We are seeking a detail-oriented Data Analyst to support our Trade Compliance team in the preparation of customs duty recovery (drawback) claims. This role will focus on collecting, organizing, reconciling, and validating large volumes of import, export, manufacturing, and inventory transaction data from multiple ERP systems.

The ideal candidate will have strong analytical capabilities, advanced Excel skills, and experience working with transactional data within supply chain, procurement, inventory, manufacturing, finance, or operations environments. This individual will play a key role in helping the team accelerate claim preparation by improving data quality, identifying discrepancies, and organizing supporting documentation.

Key Responsibilities

• Extract import, export, inventory, and manufacturing transaction data from ERP systems and reporting tools.
• Consolidate and cleanse large datasets from multiple sources to create accurate and complete records for analysis.
• Reconcile import transactions to corresponding export activity through detailed matching and validation processes.
• Analyze quantities, dates, part numbers, inventory movements, and other transactional attributes to ensure data accuracy.
• Investigate missing information, inconsistencies, and exceptions requiring research or stakeholder follow-up.
• Organize supporting documentation and maintain audit-ready records to support customs duty recovery submissions.
• Create reports, summaries, and reconciliation workbooks using Excel and other analytical tools.
• Partner with Trade Compliance, Supply Chain, Operations, Procurement, Manufacturing, Logistics, and Finance teams to resolve data gaps and improve data quality.
• Identify opportunities to streamline manual processes and improve reporting efficiency through automation and process improvements.

Required Qualifications

• 5-10 years of experience in data analysis, operations analysis, supply chain analytics, finance operations, procurement, inventory management, or related fields.
• Advanced Microsoft Excel skills including:
  • XLOOKUP/VLOOKUP
  • Pivot Tables
  • Data validation
  • Complex formulas
  • Large dataset manipulation
• Experience extracting and analyzing transactional data from ERP systems such as:
  • SAP
  • Oracle
  • JD Edwards (JDE)
  • Microsoft Dynamics
  • Infor
  • Similar enterprise platforms
• Strong analytical and problem-solving skills.
• Demonstrated experience reconciling data across multiple systems and resolving discrepancies.
• Strong attention to detail and ability to maintain accuracy while working with large datasets.
• Excellent organizational and documentation skills.

Preferred Qualifications

• Experience supporting import/export operations, global trade management, customs compliance, or duty drawback programs.
• Experience working with inventory, manufacturing, procurement, logistics, or supply chain transaction data.
• Power Query experience.
• Power BI experience.
• SQL querying and data analysis experience.
• Knowledge of customs compliance requirements and audit support processes.