Contract Business Planning Assistant at Sumitomo Electric Wiring Systems, Inc.
Sumitomo Electric Wiring Systems, Inc. · Farmington Hills, United States Of America · Hybrid
- Junior
- Office in Farmington Hills
Job Title: Contract Business Planning Assistant
- This is a non-exempt Contract position (40 hours per week) through a Staffing Agency, paid hourly, and eligible for additional hours as necessary.
- This is a Hybrid position, which combines both in office and off-site work. Associates are required to work at least three days in our Farmington Hills, Michigan office each week, but also have the flexibility to work off-site. No relocation benefit will be offered for this position.
Basic Purpose:
Support collection and review of documentation related to SEWS tariff recovery claims to customers. Claims are prepared and submitted to customers on a monthly basis.
Job Responsibilities:
- Search for required documents (CBP forms and invoices) in shared folders and work with team members to locate missing documents.
- Review documents and confirm details align with recovery claims.
- Update Excel templates (using Vlookups and Pivot Tables) to populate import data into customer required formats.
- Prepare summaries of claims submitted and track recoveries (using Excel).
Qualifications:
- Advanced Excel Skills, including capability to use advanced functions like Vlookups and Pivot Table.
- Strong analytical and communication skills
- High School Diploma/GED required.
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.
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.
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
