This job has closed.

Imagine · 23 hours ago

Business Analyst-Freight Analytics & Operations Finance

Grayslake, IL

Full-time

Onsite

Entry, Mid Level

$69K/yr - $80K/yr

2+ years exp

Imagine is a company focused on optimizing freight operations through analytics and financial management. The Business Analyst will analyze freight data, manage carrier relationships, perform invoice reconciliations, and provide insights for operational efficiency and cost savings.

AdvertisingBusiness IntelligenceMarketingProfessional Services

Culture & Values

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

Freight AnalyticsAdvanced ExcelData Visualization ToolsTransportation Management SystemsMargin AnalysisFreight Invoice ReconciliationBusiness WritingProcess Improvement MindsetCollaboration

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

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

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