Internship Advanced Excel Jobs (NOW HIRING)

"We connect science to life for a better future." With 50,000 patents, 20,000 employees and 58 locations worldwide, LG Chem is one of the largest science and chemical companies in the world. With its rapid growth, LG Chem endeavors to become a 'Global Top 5 Chemical Company' with a balanced business portfolio that has a competitive advantage across the globe, including business divisions in petrochemicals, advanced materials, life sciences, and a subsidiary specializing in batteries. LG Chem is a leading chemical company in Korea that has continuously achieved growth through relentless challenges and innovation since its establishment in 1947

From the infrangible facial cream lid to the world's most advanced batteries, LG Chem has turned dreams into reality and enriched our lives for 70 years. Building upon a balanced and globally competitive business portfolio, LG Chem manufactures a wide range of products from high-value added petrochemicals to renewable plastics, specializing in cutting-edge electronic and battery materials such as cathodes, as well as drugs and vaccines to deliver differentiated solutions for its customers. Beyond a chemical company, LG Chem will become a leading science-oriented corporation that creates value for our customers and is committed to reaching carbon-neutral growth by 2030 and net-zero emissions by 2050 by managing the impacts of climate change and making positive contributions to society through renewable energy and responsible supply chains.

LG Chem has a newly created entry level, 12-month Logistics Internship position in Troy, MI. This position will be responsible for managing customer orders and handling shipments from our Headquarters in South Korea to Customers in the US. This is an excellent opportunity to gain real world, international experience, and exposure in the areas of creating sales and purchase orders, preparing shipping documents, inventory management, monitoring shipment status and supporting sales.

This is a full-time (40-hours per week), hourly position and is located in our Troy, MI office. To qualify, candidates must have a Bachelor Degree and able to work Monday through Friday during normal business hours of 8AM - 5PM. The goal of this program is to prepare future candidates for LG Chem.

What You'll Be Doing Essential Functions (include but are not limited to): Supply Chain Management Submit Sales and Purchase Orders to HQ and monitor cargo movement and shipping updaes in SAP system. Prepare required shipping documents for customs purpose. Inbound operation with ocean imports forwarders.

Outbound operation and inventory management with 3PL vendors. Support insurance claims for damaged materials in related parties and follow through to resolution of the claim. Prepare, review, and audit all data entry for month-end closing.

Prepare month-end inventory report for each 3PL accounts. Customer Relations Constantly monitor the shipment status and provide the tentative delivery date on a daily basis. Maintain a professional attitude and successful relationship with customers by providing inventory, delivery, invoice status via e-mail, CRM or web conference upon customer's request.

Other duties as assigned Coordinate with other departments for 3PL contract, statement of account reports, Inventory forecasts, commission reports etc. Participate and assist the Team Leader and groups on any projects as needed. Support sales managers who may be traveling.

Follow up customer payments and collect on past due accounts if required. Oversee company vehicle documentation, schedule and drop-off for general maintenance. Perform routine office operations and provide administrative support.

Support general housekeeping for shared office space, including cleanliness and maintenance checks, and notify relevant teams of any issues. Handle FedEx tasks, including perparing shipping labels, receiving incoming packages, and distributing them to the local team. Qualifications, Skills and Experience: What We're Looking For Competencies/Desired Skills: Education: Bachelor's degree required in Supply Chain Management, International Trade, or Economics.

Experience: 0-1 years of work experience related to logistics operation for establishing transportation and warehousing process and vendor sourcing. Experience may include prior internships during undergraduate studies. Knowledge of customs, duty, import/export processes is a plus.

Experience with forecasting tools and advanced EXCEL skills highly preferred. Strong communication and coordination skills. Valid US driver license is required.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, gender, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any characteristic protected by applicable federal, state, or local law.