Senior Financial Analyst - Logistics Transportation

CJ Schwan's; Hopkins (MN); On-site; USD 75,000 - 125,000; Full time

Job summary

CJ Schwan's seeks an experienced financial analyst to transform data into insights and support forecasting for transportation and logistics. You will lead financial analysis, reporting, and ad-hoc projects, partnering with the Transportation team to drive budget-to-actual insights and operational improvements.

Requirements include a finance or accounting degree, 5+ years in financial analysis, and advanced Excel, Power BI, and SAP BEx experience. Competitive benefits and salary offered.

Qualifications

• Bachelor's degree in Finance or Accounting.
• 5+ years of related financial analysis experience, preferably in logistics, supply chain, or transportation.
• Familiarity with transportation cost models – FTL, LTL, ocean, parcel, and consolidation.
• Advanced proficiency in Windows and the Microsoft Office Suite.
• Deep expertise in Excel, including VLOOKUP, INDEX/MATCH, and XLOOKUP.
• Strong skills in Power Query and Power BI for data transformation and automation.
• Experience with SAP BEx to create, edit, and audit queries.
• Experience with SAP BEx and analytics tools: E2open TMS, Breakthrough Fuel, Czarlite, PC*Miler, DAT Analytics, Xeneta benchmarking.

Responsibilities

• Data Analysis & Transformation: transform financial and operational data into meaningful information and actionable insights.
• Financial Reporting & Forecasting: report, analyze, forecast, and interpret financial data including P/L, cost analysis, regional performance.
• Ad-Hoc Projects: prepare complex financial analysis reports and ad-hoc projects.
• Operational Support: act as financial business partner to Transportation leadership, communicate and advise on variances.
• Mentorship: mentor and evaluate lower-level staff and assist other teams as required.

Skills

Power BI

Excel (Advanced)

PivotTables

PivotCharts

VLOOKUP

INDEX/MATCH

XLOOKUP

Power Query

Education

Bachelor's degree in Finance or Accounting

Tools

SAP BEx

E2open TMS

Breakthrough Fuel

Czarlite

PC*Miler

DAT Analytics

Xeneta benchmarking

Job description

At CJ Schwan's, we don't just make food - we help create moments that matter. From kids devouring pizza after soccer practice, to students laughing over dumplings in a cafeteria, to families enjoying pie during the holidays, our team members play an important role in bringing those everyday moments to life. Our portfolio includes iconic pizzas, global flavors and timeless desserts from brands like Red Baron®, bibigo®, Tony's®, Big Daddy's®, Freschetta®, Pagoda®, Edwards® and Mrs. Smith's®. Enjoyed in homes, schools, restaurants and just about everywhere people shop and eat, our products reflect a commitment to quality, innovation and the power of food to bring people together.

What You Will Do

• Data Analysis & Transformation: Transform financial and operational data into meaningful information and actionable insights. This includes developing queries from different data sources, merging and appending them to create consolidated datasets, and automating routine reporting within Excel and Power BI.
• Financial Reporting & Forecasting: Report, analyze, forecast, and interpret financial and operating data - including profit/loss analysis, cost analysis, market niche reporting, regional performance assessments, customer proposals, rate of return, and depreciation. Measure the financial impact of freight RFPs at a lane level. The role also supports select end-of-month accounting activities, including accruals, adjustments, and allocations.
• Ad-Hoc Projects: Prepare complex financial analysis reports and complete individual analytical and ad-hoc projects with abstract guidelines.
• Operational Support: Serve as the key financial business partner to Transportation team management - clearly communicating, advising on, and recommending desirable operational adjustments, and interpreting budget-to-actual variances. Develop operating metrics and review performance against plans.
• Mentorship: Serve as a mentor and evaluator for lower-level staff and assist other teams with financial matters as required.

What We Look For

• Bachelor's degree or equivalent in Finance or Accounting.
• 5+ years of related financial analysis experience, preferably within the logistics, supply chain, or transportation industries.
• Familiarity with transportation cost models - full truckload, LTL, ocean, parcel, and consolidation - is strongly preferred.
• Advanced proficiency in Windows and the Microsoft Office Suite.
• Deep expertise in Microsoft Excel, including functions such as VLOOKUP, INDEX/MATCH, and XLOOKUP, logical statements, and string manipulation.
• Strong skills in Power Query and Power BI for transforming and automating data from various sources; expertise in PivotTables and Pivot Charts is also critical for data manipulation and analysis.
• Experience with SAP Business Explorer (BEx) to create, edit, and audit queries.
• Experience with several of the following transportation and analytics tools is highly preferred: E2open TMS, Breakthrough Fuel, Czarlite, PC*Miler, DAT Analytics, and Xeneta benchmarking.

Compensation And Benefits

The base salary range for this position is $75,000 to $125,000 annually, with eligibility for a 10% annual incentive bonus based on organizational performance. The pay range represents the numerous factors considered in hiring decisions including, but not limited to, education, skills, work experience, certifications, and geography. As such, starting pay for the successful candidate(s) could fall anywhere within the stated range.

Beyond base salary, we offer a competitive Total Rewards package focusing on your overall well-being. We are proud to offer a strong foundation of health benefits, retirement and financial wellbeing, time off programs, and wellbeing support programs.

The employing subsidiaries of CJ Schwan's Company are Equal Employment Opportunity Employers. All qualified applicants will receive consideration for employment without regard to disability, age, race, color, religion, gender, vet status, national origin, or other protected class.