Logistics Analyst

Colonial Group; Caledonia (MI); On-site; USD 52,000 - 68,000; Full time

Job summary

Colonial Group in Michigan is seeking a Logistics Data Analyst to drive process improvements across shipping, warehousing, and international trade compliance. You will leverage Excel, Power BI, and Tableau to analyze transportation costs, carrier performance, and landed costs, and partner with cross-functional teams to optimize distribution and logistics operations.

You should have 1–3 years of supply chain analytics experience, a bachelor’s degree, and strong problem-solving and communication

Qualifications

• Bachelor’s degree required.
• 1-3 years of experience in supply chain analysis, focusing on operations.

Responsibilities

• Use data analytics and AI tools (Power BI, Tableau) to identify trends for process enhancements in shipping, warehousing and related Logistics fields.
• Analyze transportation data, freight costs, transit times, and carrier performance to identify improvement opportunities and ensure compliance with trade regulations.
• Assist with trade compliance audits and maintain accurate logistics records.
• Review and update master data related to International Shipping (HTS, TARIC, GCC Customs) as needed.
• Collaborate with cross-functional teams to optimize Distribution and Logistics processes and improve efficiency.
• Track shipment status and resolve delays, customs holds, and disruptions; support budgeting and procurement initiatives.
• Prepare and maintain international shipping documentation and coordinate with customs brokers and freight forwarders.
• Provide logistics support to Customer Service, Finance and Regulatory Affairs including shipment inquiries and cost requests.
• Review carrier invoices for accuracy and support the freight payment process.
• Build and maintain carrier scorecards and KPI dashboards (on-time delivery, transit time, freight spend).
• Track duty and tariff changes and analyze their impact on landed cost.
• Create and maintain logistics SOPs and work instructions.
• Maintain shipment, carrier and cost data in SAP/IFS ERP systems.

Skills

Analytical thinking

Communication skills

Attention to detail

Self-motivation

Education

Bachelor's degree in Supply Chain Management, Logistics, Business, or related field

Tools

Power BI

Tableau

Excel

SAP

IFS

Job description

In This Position, You Will Have the Opportunity To

• Utilize data analytics and AI tools (PBI, Tableau, Claude) to identify trends and opportunities for process enhancements related to shipping, warehousing, international trade compliance, and other Logistics-related fields.
• Analyze transportation data, freight costs, transit times, and carrier performance to identify improvement opportunities. Ensure compliance with international trade regulations, customs requirements, import/export laws, and company policies.
• Assist with trade compliance audits and maintain accurate logistics records.
• Review and update master data as it pertains to International Shipping (e.g. HTS classifications, TARIC classification, GCC Customs Tariff) as needed.
• Collaborate with cross-functional teams to optimize Distribution and Logistics processes and improve efficiency.
• Track shipment status and proactively resolve delays, customs holds, and transportation disruptions. Support freight budgeting, cost analysis, and transportation procurement initiatives. Support continuous improvement projects focused on international logistics processes and supply chain performance.
• Prepare, review, and maintain international shipping documentation (e.g., commercial invoices, packing lists, certificates of origin, export documents) and coordinate with customs brokers and freight forwarders.
• Provide logistics support to Customer Service, Finance, and Regulatory Affairs, including shipment inquiries, freight accrual and cost allocation support, and trade data requests.
• Review carrier invoices for accuracy, research billing discrepancies, and support the freight audit and payment process.
• Build and maintain carrier scorecards and recurring logistics KPI reports and dashboards (e.g., on-time delivery, transit time, freight spend).
• Track duty and tariff changes and analyze their impact on landed cost.
• Create and maintain logistics SOPs and work instructions.
• Maintain shipment, carrier, and cost data in the ERP system (SAP/IFS) to ensure accuracy and data integrity.
• Other various duties as dictated by business needs.

What You Need to Succeed in This Position

• Bachelor’s degree in Supply Chain Management, Logistics, Business, or a related field.
• 1-3 years of experience in supply chain analysis, with a focus on operations.
• Proficiency in data analytics tools and software, such as Excel, and other data visualization tools.
• Experience with Power BI or Tableau for reporting and data visualization.
• Experience with MRP/ERP systems (SAP, IFS a plus)
• Working knowledge of Incoterms and import/export regulations.
• Transportation management system (TMS) experience a plus.
• Strong analytical, problem-solving, and critical thinking skills.
• Excellent communication and presentation abilities.
• Ability to work collaboratively in cross-functional teams.
• Attention to detail and a commitment to accuracy.
• Ability to self-manage time and performance against deadlines.
• Critical thinking skills
• Problem solving skills
• Strong analytical skills
• Detail oriented and a high level of accuracy
• Self-motivation to work independently
• Ability to multitask and prioritize
• Trade compliance or supply chain certification (e.g., APICS/ASCM) a plus.

PHYSICAL REQUIREMENTS:

• Ability to sit, stand, walk, use computer and electronic devices