Logistics Analyst

Heartland FPG•Indianapolis, IN

1d•Onsite

About The Position

The Logistics Analyst plays a critical role in optimizing freight movement to achieve 100% on-time delivery while minimizing costs. This position serves as the primary point of contact for shipment status, proactively manages and optimizes the carrier base (performance, relationship and reliability), handles routing of customer freight, and delivers actionable insights through advanced Excel analytics and Microsoft Power BI reporting. Strong emphasis is placed on E2Open TMS proficiency, data-driven decision making, and continuous process improvement.

Requirements

Bachelor’s degree in Supply Chain, Logistics, Business Analytics, or related field.
2+ years of logistics experience, including hands-on work with a Transportation Management System (TMS).
Advanced Microsoft Excel skills – expert in data analysis, modeling, pivot tables, lookups, and automation.
Experience in creating reports and dashboards in Microsoft Power BI (or equivalent BI tool).
Solid understanding of Truckload (TL) and Less-Than-Truckload (LTL) operations, carrier management, and routing optimization.
Proven problem-solving, critical-thinking, and analytical skills with a high sense of urgency.
Ability to work independently and collaboratively in a fast-paced, small-team environment.
Proficiency in Microsoft Office Suite (Excel, Word, Outlook) is required; advanced Excel and Power BI experience is essential for success in this role.
Must be able to sit at a computer and use a phone for extended periods (8+ hours/day).
Occasional extended hours, including daily overtime and rare weekends.
Ability to read and interpret computer screens and documents with visual acuity.
Reasonable accommodation may be made for individuals with disabilities.

Nice To Haves

Direct experience with E2Open TMS (formerly BluJay/Lean Logistics).
Background in food/beverage or CPG logistics.
Experience participating in carrier RFP processes, performance reviews and strategic carrier sourcing.

Responsibilities

Shipment Tracking, Tendering & Routing
Demonstrate expert-level proficiency in E2Open Transportation Management System (formerly BluJay) to plan, tender, track, and optimize shipments.
Proactively monitor customer orders and route collect/vendor shipments to ensure optimal carrier selection, cost efficiency, and on-time performance.
Manage suspected late shipments, expedite as needed, and communicate directly with carriers and Customer Service to protect delivery dates and adjust appointments/POs.
Obtain competitive quotes, tender shipments, and ensure all deliveries fall within the Must-Arrive-By-Date (MABD) window.
Communicate customer policies (appointment requirements, etc.) and forecasted demand to carriers to secure capacity.
Review shipping requirements for new customers and approve expedited/detention charges.
File freight claims and complete new carrier onboarding documentation as required.
Carrier Performance & Relationship Management
Maintain carrier scorecards, tracking key metrics including on-time delivery (OTD), tender acceptance rates, damage/shortage frequency, invoice accuracy, and capacity reliability.
Analyze carrier performance data to identify underperformers, top performers, and opportunities for network optimization (e.g., lane consolidation, preferred carrier programs).
Develop and present carrier performance reports/dashboards (in Power BI/Excel) to support quarterly business reviews and strategic sourcing decisions.
Identify trends in carrier spend, service levels, and market conditions to recommend additions, removals, or renegotiations within the carrier base.
Customer Service & Cross-Functional Collaboration
Partner with Customer Service on order delays and proactively extend POs or modify appointments before orders become late.
Reconcile freight-related short pays with Accounts Payable and resolve invoice discrepancies with Accounts Receivable.
Collaborate with Sales, Marketing, and Operations on freight analysis, cost modeling, and customer-specific routing strategies.
Analytics, Reporting and Process Improvement
Build and maintain dynamic reports using data from E2Open TMS in various platforms: advanced Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, Power Query, macros, data modeling), and Microsoft Power BI.
Analyze performance data to identify trends, cost-saving opportunities, process roadblocks, and scalability improvements.
Drive continuous improvement initiatives through data-backed recommendations.
Additional Support
Coordinate daily customer orders with Warehouse Operations.
Manage and maintain the internal shuttle fleet schedule and activities.
Support special projects and other duties as assigned.
Stay current with industry trends through relevant publications and networking.