Enter a job title or keyword
Business Planner II
Job Location:
Job Location:
El Paso, TX - USA
Monthly Salary:
Not provided by the employer
Monthly Salary:
Posted:
5 June 2026 (30+ days ago)
Posted:
Application Deadline:
2 September 2026
Application Deadline:
Vacancies:
1 Vacancy
Vacancies:
Department:
Job Summary
Description
Support the CCD Tariff Team in tariff impact mitigation tariff reporting customer allocation available benefit tracking government refund tracking and tariff related business planning activities.
This position is allocated 70% to CCD and 30% to Wiring Harness Planning with direction from the CCD Tariff Team Assistant Manager and CCD General Manager. The position may be located at the Detroit office or El Paso office.
The role also supports Wiring Harnes Planning budgeting activities and assists with training and execution of detail recurring tariff reporting tasks.
Duties and Responsibilities:
- Prepare or support tariff impact reports for Expeditors/GPP Rudolph Miles/Mexico UPS/GPP YUSEN/GPP and other assigned categories.
- Support monthly tariff impact P&L analysis including occurrence customer pass-though rebate refund and net impact.
- Allocate tariff impact by customer broker origin HTS code country of origin and other required categories.
- Complete assigned monthly reporting during business day 15 timing.
- Collect and review broker data ACE data Form 7501 data invoice data packing list data ASN data and other tariff related information.
- Validate key tariff calculation factors including country of origin HTS code import value duty rate and duty amount and additional tariff category.
- Identify gaps discrepancies or timing issues and escalate as required.
- Support daily Section 232 credit application activity for Expeditors Rudolph Miles UPS and other applicable brokers.
- Track Section 232 credit amounts application status supporting data and unresolved issues.
- Support weekly FY25 PSC progress tracking and FY25 IEEPA progress tracking assigned.
- Coordinate with customs brokers KPMG overseas affiliates sales business units corporate business planning and other stakeholders.
- Prepare tariff impact analysis and supporting data for sales business units to support customer recovery discussions.
- Maintain action logs open items lists and reporting files.
- Support standardization of reporting templates checklist work instructions and tracking files.
- Identify manual workload reduction opportunities and assist with reporting/system improvement.
- Support Wiring Harnes Business Planning activities including P1 P2 P3 and P4 budgeting activities.
- Assist in training and guiding the Logistics Planner III in recruiting tariff reporting and tracking activities.
- Perform other duties as assigned by the CCD General Manager or CCD Tariff Team Assistant Manager.
Qualifications:
- Bachelors degree in logistics supply chain business accounting finance international trade field preferred.
- Experience in business planning logistics customs compliance tariff reporting finance or data analysis preferred.
- Working knowledge of import activity broker documentation CBP Form 7501 HTS codes country of origin import value duty calculation and tariff recovery preferred.
- Strong Excel skills required; reporting tools such as Smartsheet. Power BI Access SQL or similar tools preferred.
- Ability to collect organize analyze and reconcile data from brokers internal systems overseas affiliates and internal departments.
- Strong communication follow-up documentation and deadline management skills.
- Ability to support monthly business day 1-5 reporting daily support and weekly tracking processes.
- 3-5 years progressive professional business accounting/finance experience.
About Sumitomo Electric Wiring Systems Inc.
Sumitomo Electric Wiring Systems Inc. (SEWS) is part of the Sumitomo family of companies a 400 year old brand with a reputation for quality and reliability. With the support of facilities throughout North America SEWS has been delivering innovative solutions to automakers forover30years and is a leading supplier of electrical distribution systems components and electronics. SEWS is committed to technical development worldwide and with a global network of resources is able to deliver a truly competitive advantage to each of our customers. Our associates are what drive Sumitomos continued growth which is why we proudly offer a competitive salary and comprehensive benefits package including Medical Dental Vision Disability Life 401(k) with match tuition benefits paid holidays and vacation.
Follow Us on LinkedIn: the Sumitomo Electric Group
Since the founding of Sumitomo Electric Industries 1897 with copper wire production we have developed many new technologies and products through innovative R&D activities based on Sumitomo Electric manufacturing technologies for electric wires and power cables. With more than 350 subsidiaries worldwide we continue to introduce a wide variety of products that fulfill the expectations of society in five business fields: Automotive Information & Communications Electronics Environment & Energy and Industrial Materials. We are a Fortune global 500 company.
Follow Us on LinkedIn: Candidates Should Submit Cover Letter and Salary History When Applying.**An Equal Opportunity Employer M/F/D/V
E-Verify is an Internet based system operated by the Department of Homeland Security (DHS) in partnership with the Social Security Administration (SSA) that allows participating employers to electronically verify the employment eligibility of their newly hired employees in the United States. Sumitomo Electric Wiring Systems Inc. participates in E-Verify to confirm that individuals offered employment are legally authorized to work in the United States.
About Company
Sumitomo Electric Wiring Systems’ mission is to be the global leader delivering innovative electrical distribution systems that meet the demands of today’s ever-changing automotive market.
