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.

We are searching for candidates that are driven, intelligent, creative, and entrepreneurial. By offering challenging and accelerated opportunities for growth, powered by a shared hunger for success, we create a space for your career to thrive. In return for your expertise, we are committed to providing competitive and robust total compensation and benefit packages to ensure you feel valued. Our dream is to become the fastest growing, most loved, window covering company in the world. What’s yours?

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

What's in it for you

Please note, all offers presented to candidates are carefully crafted to ensure market competitiveness, equity, and reflect the individual candidate’s education, experience, skills and potential.

Hunter Douglas is an Equal Opportunity Employer and complies with applicable employment laws. EOE / M / F / Vet / Disabled are encouraged to apply.

By submitting your application below, you are providing your prior consent to receive SMS messages to notify you of any updates to your application status and to engage in discussion throughout your application process. You can cancel the SMS service at any time. Just text “STOP” to any of our texts to unsubscribe. Message & data rates may apply. Message frequency may vary. If you have any questions regarding privacy, please read our privacy policy, or terms of use