Product Line Analyst

Van Drunen Farms • Momence, IL

1d • $70,000 - $85,000

About The Position

The Van Drunen Family of Companies is growing! JOB OVERVIEW: The Product Line Analyst provides critical analytical support to ensure the health, growth, and profitability of assigned product lines. This role collaborates cross-functionally to deliver insights that support strategic decisions across Supply Chain, Sales, Marketing, Operations, and Finance.

Requirements

• 2+ years of experience in planning, financial analysis or inventory management
• Strong proficiency in Microsoft Excel.
• Intermediate skills in Microsoft Office Suite.
• Demonstrates integrity, initiative, reliability, accountability, and teamwork.
• Excellent analytical, communication, and collaboration skills.
• Positive attitude and team-oriented mindset.
• Bachelor’s Degree in Business or closely related field
• While performing the duties of this job, the employee is regularly required to sit for extended periods, use hands to operate a computer and other office equipment, and communicate effectively via phone and email and video.
• The employee must occasionally lift and/or move office supplies or files up to 20 pounds.
• Visual acuity is required for reading documents, spreadsheets, and computer screens.
• The ideal candidate must be able to complete all physical requirements of the job with or without a reasonable accommodation.

Nice To Haves

• Experience with Power BI preferred.

Responsibilities

• Product Costing & Profitability Maintain item-level costing within the product line.
• Collaborate with Finance to maintain accurate ingredient standard costs.
• Maintain and update product price lists in partnership with Sales and Finance.
• Conduct customer and item profitability analyses to support Sales & Marketing.
• Develop cost models for new product initiatives.
• Review pricing on new orders prior to production scheduling.
• Sales & Operations Planning Track progress of upcoming projects.
• Partner with Sales to assess and forecast customer demand.
• Prepare and present global supply plans.
• Regularly update Bills of Resources, load profiles, and capacity calculations.
• Support month-end reconciliation by analyzing customer pulls vs. projections and schedules.
• Reporting & Analytics Generate and analyze daily sales reports for accuracy, profitability, usage, and inventory.
• Maintain monthly product line scorecards with goals and KPIs.
• Provide ad hoc reporting and analysis as needed.
• New Product Development Support costing models for new product development.
• Collaborate with cross-functional teams to support project timelines and deliverables.
• Inventory Management Support setting inventory targets by item.
• Forecast inventory levels for finished goods and raw materials.
• Support raw material projections and MRP for finished goods.
• Track and report on low utility inventory and recommend action plans.
• Additional Responsibilities Support item rationalization efforts.
• Record and report on various operational metrics.
• Contribute to scorecard development and updates.

Benefits

• This role may further qualify for supplemental compensation in the form of bonus and incentive programs, contingent upon achieving pre-established individual and company performance metrics.
• Benefits Available: 2026-benefits-summary.pdf

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees