Midnight Oil · 4 days ago
Business Analyst-Freight Analytics & Operations Finance
Grayslake,IL,US
Full-time
Onsite
Entry, Mid Level
2+ years expMidnight Oil is focused on enhancing operational efficiency within freight operations, and they are seeking a Business Analyst specializing in Freight Analytics and Operations Finance. The role involves analyzing freight data, managing carrier relationships, conducting invoice reconciliations, and providing data-driven insights to support strategic initiatives.
AdvertisingCreative AgencyMarketing
Responsibilities
Analyze freight data to identify trends, inefficiencies, and opportunities for optimization
Develop dashboards and reports using tools like Excel, Tableau, or SQL to monitor key performance indicators (KPIs) such as transit times, costs, and delivery accuracy
Evaluate and manage relationships with freight carriers, including contract negotiations, performance reviews, and partnership development
Conduct regular audits to ensure compliance and identify areas for improved collaboration and cost reduction
Perform detailed reconciliations of freight invoices against contracts, shipment records, and billing terms
Identify discrepancies, resolve billing errors, and implement processes to minimize future issues, ensuring accurate financial reporting
Analyze pricing structures based on location-specific variables (e.g., regional surcharges, fuel costs) and box dimensions (e.g., volumetric pricing models)
Conduct margin analysis to assess profitability, recommend pricing adjustments, and forecast impacts on overall business margins
Collaborate with cross-functional teams (e.g., finance, operations, procurement) to gather requirements, model scenarios, and provide actionable recommendations
Support strategic initiatives by preparing business cases and ROI analyses for freight-related projects
Identify bottlenecks in freight operations and propose solutions, such as automation tools for invoice processing or advanced analytics for carrier selection
Assist Director of Finance in preparation of weekly profitability reporting and data driven process improvements
Work alongside Director of Finance and Director of Sales on finished goods inventory management and reporting, identify and report risk
Other duties as assigned
Qualification
Required
Bachelor's degree in finance, Supply Chain/Logistics, Business, Data Analytics, or a related field OR an equivalent combination of education and relevant professional experience
2-5 years of experience in freight analytics, operations finance, logistics, or transportation roles, with hands-on exposure to carrier management and invoice reconciliation
Preferred
Master's degree in business administration, Finance, Supply Chain, Data Analytics or a related field OR an equivalent combination of advanced education and substantial professional experience
Advanced Excel (pivot tables, complex formulas, Power Query; basic VBA a plus)
Proficiency with data visualization tools for KPI dashboards
Experience with TMS (Transportation Management Systems) and understanding of ERP data structures and ability to quickly adapt to utilization of proprietary software
Ability to perform margin analysis and build pricing models incorporating different cost factors
Strong understanding of freight modes, dimensional pricing, and carrier scorecards
Demonstrated experience with freight invoice reconciliation against contracts and shipment records
Proven ability to identify trends and operational inefficiencies and translating insights into actionable recommendations
Clear, concise business writing and communications to present analyses to finance, operations, sales, and procurement stakeholders
High level of ownership, collaboration, and professionalism
Process improvement mindset – comfortable shaping and automating workflows and efficiencies
Benefits
Medical, dental, and vision coverage
Paid time off
Disability insurance
401(k) with match
Life insurance
Other voluntary supplemental insurance coverages
Tuition assistance
Caregiver leave
Adoption assistance
Employer/partner discounts
Company
Midnight Oil
Midnight Oil is a marketing agency that provides go-to-market, brand strategy, print production, structural design, and audience insight.
201-500 employees
Funding
Current Stage
Growth StageRecent News
The Imagine Group, LLC
2025-11-23
Morningstar.com
2025-08-20
Company data provided by crunchbase