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.
The pay range that the employer in good faith reasonably expects to pay for this position is between $35.00 and $45.00
Our benefits offering includes medical, dental, vision and 401k.
Tundra Technical Solutions would like to thank you for your interest in this opportunity. However, only candidates under consideration will be contacted.
Tundra Technical Solutions is a global workforce and technology delivery firm, ranked by Staffing Industry Analysts as one of the largest in North America. At Tundra, we aren't just hiring top talent at the world's most recognizable brands; we are pioneers of social recruitment.
This post is for a contract assignment. Assignment duties and duration are subject to business needs and requirements. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other legally protected characteristics.
California Notice. Qualified applicants with arrest or conviction records will be considered for employment in accordance with law, including the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act. Criminal history may have a direct, adverse, and negative relationship with the following job duties: protect and return property, adhere to confidentiality requirements, comply with security requirements, adhere to policies and codes of conduct.
We use artificial intelligence tools to help our recruiters screen and assess talent. These tools do not replace human decision making in the process.
Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!