Business Planner II

Description

Position at Sumitomo Electric Wiring Systems, Inc.

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 1–5 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:

Bachelor’s 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 for over 30 years, 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 Sumitomo’s 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. 

To learn more about us, please visit www.sewsus.com. 

Follow Us on LinkedIn: https://www.linkedin.com/company/sumitomo-electric-wiring-systems 

About the Sumitomo Electric Group 

Since the founding of Sumitomo Electric Industries, Ltd. in 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.  

To learn more about Sumitomo Electric Group, please visit http://global-sei.com.

Follow Us on LinkedIn: http://www.linkedin.com/company/sumitomo-electric
 

**Interested 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.