Logistics Jr. Analyst and Administrator - Summer Internship

Do you want to work for a stable, growing organization that reaches back more than 130 years?  Our steel tube and pipe products have helped build landmarks and buildings in North America; Come build your career at Zekelman Industries! 

Z-Modular, a division of Zekelman Industries, is a Logistics Jr. Analyst and Administrator Intern for our facility in Troy, MI. Reporting to the Director of Logistics and Scheduling, this individual will provide analytical support for all functions of logistics, including carrier management, report creation/distribution, freight payment and auditing, management of freight rates database, inventory reconciliation and other operations as required. The responsibility of this role is to turn raw data into critical information and knowledge.  Will create reports, visualizations, dashboards, and metrics that provide business insight and aid business decision-making. 

RESPONSIBILITIES:  

• Work to ensure all aspects of the Logistics Team’s needs are met. 
• Create, maintain, update, and distribute D365 logistics reports, including cost tracking. 
• Analyze all system shipments, ensuring that the system matches financial reports. 
• Correct errors in Freight POs, and freight Invoices, clean up open items in the system, and check cost centers and WBS, ensuring accurate financial reporting. 
• Create, maintain, update, and distribute various Excel documents utilized in logistics and project work. 
• Create, maintain, update, and distribute all templates and procedural documentation. 
• Maintain and organize filing systems. 
• Research and implement ways to decrease costs whenever possible without hindering customer services. 
• Carrier vetting, onboarding, and maintenance, ensuring insurance is adequate and up to date. 
• Update and maintain the freight rates database. 
• Become super user in D365 to aid Logistics. 
• Assist in all customs for cross-border shipments. 
• Other duties as assigned by managers. 

QUALIFICATIONS:  

• Post-secondary education in related fields (Business Administration, Finance, Analytics, Computer Science, Data Science). 
• Strong Excel experience required (Pivot Tables, Complex Formulas, Power Queries, Index, Match, etc.) 
• Proficient in MS Office Suite, including Excel, PowerPoint, and Word. 
• Strong analytic, problem-solving, communication, and presentation skills. 
• Extremely strong organization skills and attention to detail. 
• Power BI expertise preferred, but not required.  
• Experience with Microsoft Dynamics 365 software preferred, but not required. 
• Ability to travel within USA and Canada.  
• Must be able to work independently and quickly adjust to a fast-paced, start-up environment. 
• Regular, full-time, predictable attendance per the posted schedule is an essential function of this role. 
• Lead and promote health and safety work practices as required by regulatory agencies and company policy.