Import Export Database Administrator

Reposted Yesterday
Be an Early Applicant
Agua Prieta, Sonora
In-Office
Senior level
Software • Automation • Manufacturing
The Role
Manage customs import-export database, update catalogs, reconcile data against SAP inventory, and ensure compliance with customs regulations. Prepare monthly reports and serve as contact for software maintenance.
Summary Generated by Built In

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

  • 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 development


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.




#LI-EM1

#LI-Onsite


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, https://www.hunterdouglas.com/privacy-policy or terms of use https://www.hunterdouglas.com/terms-of-use

Top Skills

Datastage
Edi
Excel
SAP
SQL
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Pearl River, NY
2,265 Employees

What We Do

Hunter Douglas offers premium, intelligent window fashions that beautifully transform natural light and enhance your home's interiors. Our products are thoughtfully engineered to craft your perfect light, and many designs offer additional energy efficiency and child safety benefits. A versatile product portfolio and broad selection of innovative operating systems—including advanced automation—allow you to effortlessly choose the look you desire and how your window treatments function.

Similar Jobs

Magna International Logo Magna International

Planeador de Logistica

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
Hermosillo, Sonora, MEX
In-Office
Ciudad Obregón, Cajeme, Sonora, MEX

Sidara Logo Sidara

Designer

Professional Services
In-Office or Remote
3 Locations

Sidara Logo Sidara

Designer

Professional Services
In-Office or Remote
3 Locations
20-30

Similar Companies Hiring

Credal.ai Thumbnail
Software • Security • Productivity • Machine Learning • Artificial Intelligence
Brooklyn, NY
Standard Template Labs Thumbnail
Software • Information Technology • Artificial Intelligence
New York, NY
10 Employees
PRIMA Thumbnail
Travel • Software • Marketing Tech • Hospitality • eCommerce
US
15 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account