Import Export Database Administrator

Hunter Douglas is the world’s leading manufacturer of window coverings and a major manufacturer of architectural products. We are a brand that you know and trust. With more than 100 years of innovation, we’ve defined our industry with proprietary products that deliver revolutionary style and functionality and can be found in millions of homes and commercial buildings globally.One of the pillars of our North American division is spread across four different sites in Mexico where a blend of manufacturing and fabrication occurs. At each location we pride ourselves on exemplary safety and employee-first standards, as we pioneer production processes to be best in class. It is our focus on quality and growth that makes us an employer of choice and helps us maintain our culture of excellence.**Position Overview**The position is the gatekeeper of the customs import-export database, regularly updating its catalogs on approved changes by the import-export manager. Works directly with the provider on software performance and maintenance updates and projects related to customs regulations or company requirements changes.Performs the monthly inventory backflush analysis vs the data stage file and SAP inventory balances, reviewing the report with the import-export manager for approval before it’s presented to SAT.Confirms that export declarations via the SAP BOM generated file are correct (SAP, BPM TXT file vs commercial invoice information generated by the customs software) working with the SAP reporting team on required updates that reflect correct information on the Cis.**What you'll do**- Maintain and control the IMMEX inventory balance in the customs compliance software under the threshold period required by Mexican Customs Law by type of operation (18 months for IN, 6 months for V1, etc.- Reconcile all import and export manifests (pedimentos) against the DataStage file that’s received by SAT.- Execute the monthly backflush process in the customs compliance software against the reconciled DataStage inventory to get to the PCN/HTS quantity balance and generate an executive summary.- Cross-reference the backflush report against the SAP inventory by PCN to identify offenders- Transmit the monthly backflush report to SAT once approved by the import-export manager- Direct point of contact with the software provider for maintenance updates or other requirements- Maintain and control project logs for hourly service packages- Work in conjunction with local IT on databases backup- Update all software catalogs as required (new components, finished products, unit costs, HTS codes, etc.)- Update all labor and raw material unit costs once a month- Train new associates in basic user or the software- Generate SQL reports, reporting templates, document layouts and automated month-end report mail outs- Ensures correct commercial invoice EDI transmissions are being received by the MX/US customs brokers- Any other activity assigned by the import-export manager**Who you are**- 5 years of experience in Similar Positions.- Minimum education: Engineering in IT, LCI, LAE or similar.- Organizational skills.- Customs Law and its Regulation.- Trade Treaties.- Foreign Trade Rules.- Database management.- English 85%.- SAP System.- Intermediate to Advanced Excel.**What's in it for you**- Competitive compensation package including annual bonus- Generous benefits package including major medical expenses and life insurance- Vacation days- Vacation premium- Paid time off- Christmas bonus- Cafeteria service- Savings fund- Career developmental opportunities- A company culture that prioritizes internal developmentHunter Douglas is an Equal Opportunity Employer and complies with applicable employment laws. EOE/M/F/Vet/Disabled are encouraged to apply.LI-EM1LI-Onsite