Logistics Analyst

Legrand AV, Inc.; Mascoutah (IL); On-site; USD 70,000 - 100,000; Full time

Job summary

Legrand AV, Inc. in Mascoutah, IL is seeking a Logistics Analyst to analyze transportation operations, freight spend, and carrier performance to identify cost savings and service improvements.

The role combines analytics, financial modeling, and continuous improvement to support strategic and day-to-day transportation decisions. You will partner with Supply Chain, Finance, Operations, IT, and external providers to optimize freight across parcel, LTL, truckload, intermodal, air, and ocean modes,

Qualifications

• BS in business or related field.
• Bachelor's degree in Transportation, Logistics, Supply Chain, Business, Analytics, Finance, or related discipline preferred.

Responsibilities

• Analyze transportation spend, shipment activity, freight costs, accessorials, service performance, and network trends across domestic and international modes.
• Perform transportation network analysis, routing analysis, lane and mode optimization, consolidation studies, and scenario evaluations to improve cost, service, and capacity.
• Develop cost models and cost-benefit analyses for carrier changes, mode shifts, sourcing events, network changes, and transportation productivity initiatives.
• Prepare recurring operational and financial reporting, dashboards, forecasts, and KPI scorecards for transportation performance.
• Support annual transportation budget development, monthly forecasting, accrual analysis, variance analysis, and freight productivity tracking.
• Review routing decisions, routing guides, carrier assignments, rate structures, contracts, fuel programs, and accessorial charges; identify exceptions and recommend corrective action.

Skills

Advanced Excel

Power BI

Tableau

SQL

Microsoft Access

Financial analysis

Cost modeling

Variance analysis

Forecasting

Continuous improvement

Communication

Education

Bachelor's degree in business or related field

Tools

TMS

ERP

Freight audit/payment systems

Job description

At a Glance

Legrand has an exciting opportunity for a Logistics Analyst to join the Electrical Infrastructure division.

The Logistics Analyst is responsible for analyzing transportation operations, freight spend, carrier performance, routing, and network trends to identify cost savings, service improvements, and network optimization opportunities. The role combines transportation analytics, systems knowledge, financial analysis, and continuous improvement to support strategic and day-to-day transportation decisions. This position partners Supply Chain, Finance, Operations, IT, business units, and external transportation providers to improve network performance and support efficient movement of freight across parcel, LTL, truckload, intermodal, air, and ocean modes.

MAJOR JOB DUTIES:

• Analyze transportation spend, shipment activity, freight costs, accessorials, service performance, and network trends across domestic and international modes.
• Perform transportation network analysis, routing analysis, lane and mode optimization, consolidation studies, and scenario evaluations to improve cost, service, and capacity.
• Develop cost models and cost-benefit analyses for carrier changes, mode shifts, sourcing events, network changes, and transportation productivity initiatives.
• Prepare recurring operational and financial reporting, dashboards, forecasts, and KPI scorecards for transportation performance, including cost per shipment, cost per pound, on-time pickup/delivery, claims, accessorials, and carrier performance.
• Support annual transportation budget development, monthly forecasting, accrual analysis, variance analysis, and freight productivity tracking.
• Review routing decisions, routing guides, carrier assignments, rate structures, contracts, fuel programs, and accessorial charges; identify exceptions and recommend corrective action.
• Support transportation sourcing events, RFQs/RFPs, carrier negotiations, bid analysis, award scenarios, implementation, and post-award performance measurement.
• Maintain and analyze carrier and transportation supplier performance; attend business reviews and provide fact-based recommendations for corrective action or network changes.
• Partners with internal teams and external providers to triage transportation service failures, capacity constraints, billing issues, and other active transportation problems.
• Leverage TMS, ERP, freight audit/payment data, carrier systems, and other data sources to improve data quality, reporting, routing compliance, and transportation visibility.
• Support transportation systems implementations, enhancements, testing, master-data requirements, user acceptance testing, process documentation, and end-user training.
• Develop and maintain transportation standard operating procedures, routing instructions, analytical tools, and documentation needed to support consistent processes across locations and business units.
• Identify continuous-improvement projects that reduce freight cost, improve service, simplify processes, or strengthen transportation controls.
• Provide management-by-exception reporting that highlights material cost, service, routing, or carrier performance issues requiring action.
• Perform other transportation analytics, project support, and related duties as assigned.

EDUCATION:

• BS in business or related or equivalent combination of education and experience.

Profile:

• Bachelor's degree in Transportation, Logistics, Supply Chain, Business, Analytics, Finance, or a related discipline preferred.
• At least 3 to 5 years of transportation, logistics, supply chain, or related experience preferred, with direct transportation experience strongly preferred.
• At least 3 to 5 years of analytical experience working with transportation, financial, operational, or network data.

Skills/Knowledge/Abilities:

• Advanced Microsoft Excel skills required; experience with Power BI, Tableau, SQL, Microsoft Access, or other analytics/database tools preferred.
• Working knowledge of transportation modes, carrier pricing, freight terminology, routing, rate structures, accessorials, and transportation performance measures.
• Experience with TMS, ERP, freight or audit/payment systems is preferred.
• Ability to analyze large data sets, identify trends and exceptions, develop actionable insights, and communicate recommendations clearly.
• Strong financial acumen with the ability to perform cost modeling, variance analysis, forecasting, and savings validation.
• Strong continuous improvement skills with the ability to manage multiple priorities and execute crossfunctional initiatives.
• Excellent written and verbal communication skills and the ability to communicate effectively with carriers, operational teams, management, and senior leaders.
• Demonstrated relationship building, teamwork, and collaboration across functions and business units.
• Ability to work independently, challenge assumptions, solve complex problems, and support datadriven decisions.
• Travel requirement: up to 25%.

PHYSICAL REQUIREMENTS:

• Sit, walk, and stand as required in an office or operational environment.
• Hear and speak to exchange information in person, virtually, and by telephone.
• Possess dexterity of hands and fingers to operate standard computer and office equipment.
• Occasional visits to manufacturing, distribution, or transportation operating locations may be required.

Legrand is the global specialist in electrical and digital building infrastructures. Its comprehensive offering of solutions for residential, commercial, and datacenter markets makes it a benchmark for customers worldwide.

Bridging power from sources to pathways to touchpoints, Legrand's Electrical Infrastructure division combines innovation and quality to provide leading solutions for an evolving energy landscape. Our expertly designed products enable customers to confidently address the complex needs and challenges of electrification, while enhancing everyday experiences like plugging in, switching on, and staying connected. Committed to best-in-class service at every stage, we act as a trusted partner for our customers to ensure each project's success and their continued satisfaction. Legrand's Electrical Infrastructure division includes the following brands and product lines: Girtz, Avtron, Power Bus Way, Cablofil, Connectrac, Wiremold and Pass & Seymour.

Legrand, North & Central America offers comprehensive medical, dental, and vision coverage, as well as distinctive benefits like a high employer 401K match, paid time off (PTO) and holiday pay, short-term and long-term disability benefit plans, above-benchmark paid maternity and parental leave, bonus opportunities in accordance with the Company's incentive plans, paid time off to volunteer, and an active/growing Employee Resource Group network. For more information, visit legrand.us.