Business Planner II
On-site · Detroit, Michigan, United States or El Paso, Texas, United States
Job Summary
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 role may be located at the Detroit office or El Paso office. Duties include preparing or supporting tariff impact reports for multiple clients, supporting monthly tariff impact P&L analysis, allocating tariff impact by customer/broker/origin/HTS code/country of origin, completing monthly reporting, collecting and reviewing broker data, ACE data, Form 7501 data, invoice data, packing lists, ASN, and other tariff information, validating tariff calculation factors, identifying gaps or timing issues, supporting Section 232 credit activity and tracking, supporting PSC/IEEPA progress tracking, coordinating with brokers and internal stakeholders, preparing tariff impact analyses for sales units, maintaining action logs, and assisting in standardization of reporting templates and processes. Qualifications emphasize a bachelor’s degree and 3-5 years of related experience, strong Excel and data-analysis capabilities, and ability to manage multiple weekly/monthly reporting tasks.
Required 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
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.