Inventory Planning Analyst - DRP (Transportation)

About Us:
Trilliant Food & Nutrition is a leading, vertically integrated manufacturer of premium coffees and powdered beverages, proudly headquartered in Little Chute, Wisconsin. With a legacy rooted in quality, innovation, and service, Trilliant delivers branded and private label solutions across retail, foodservice, and e-commerce channels.

Horseshoe Beverage Company, based in Neenah, WI, is a leading ready-to-drink beverage manufacturer dedicated to delivering an exceptional beverage experience. By combining industry-leading talent, cutting-edge equipment, and a vertically integrated supply chain, we drive innovation and consistently deliver the highest quality products to our customers--first and fast.

Our brand portfolio includes Victor Allen's®, Dutch Bros® beverages and Nurri™, our better-for-you protein beverage line. We are passionate about beverages - and about building a team that's just as energized. We invite you to explore opportunities at Trilliant or Horseshoe, to see if your talents and career aspirations may fit with our openings.

Our Core Values:

Position Overview:
The Inventory Planning Analyst - DRP supports the Inventory Planning Manager in optimizing inventory across Trilliant Food's supply network. This role plays a key part in executing Distribution Requirements Planning (DRP), maintaining inventory visibility, and supporting data-driven decision-making. The analyst will work cross-functionally to assist with inventory strategies, reporting, and planning execution for both short- and long-shelf-life consumer packaged goods (CPG). Proficiency with ERP systems, data analysis tools, and strong attention to detail are critical to success in this position.

Key Duties & Responsibilities:
§ Assist in executing the Distribution Requirements Planning (DRP) process to ensure accurate and timely inventory deployment to manufacturing sites, co-packers, and distribution centers.
§ Monitor inventory levels, shelf-life, and product freshness, and generate alerts for replenishment, run-outs, and potential spoilage.
§ Track and report key inventory metrics including Days of Supply, spoilage rates, forecast accuracy, and aging/excess stock.
§ Utilize Microsoft Dynamics AX and Power BI to support reporting, analysis, and planning tools for inventory performance visibility.
§ Partner with Inventory Manager to maintain and update inventory policies, including safety stock, reorder points, minimum order quantities, and lead times.
§ Prepare and publish routine inventory health reports, including aging inventory, slow-moving SKUs, and stock-out risks.
§ Participate in inventory policy reviews and assist in modeling potential outcomes for safety stock changes, seasonal builds, and run-out strategies.
§ Support the execution of new product launches, discontinuations, and product restages by ensuring data readiness and supply chain alignment.
§ Collaborate with cross-functional teams (Sales, Operations, Procurement, Customer Service) to align supply plans with demand trends and constraints.
§ Help maintain the inventory planning calendar, and track execution adherence (e.g., shelf-life targets, replenishment cycles, service goals).
§ Conduct root cause analysis on inventory discrepancies, shortfalls, or excess, and recommend corrective actions.
§ Support inventory reduction and working capital improvement initiatives through targeted analysis and reporting.
§ Assist in preparing inputs and dashboards for Inventory Steering Committee and IBP (Integrated Business Planning) meetings.
§ Assist with ERP master data related to inventory planning and provide inputs for ERP/Power BI system improvements.
§ Occasionally support physical inventory reviews or audits to validate system accuracy.

Qualifications:

· Bachelor's degree in Supply Chain, Business, Finance, Operations, or a related field
· APICS Certifications are a huge plus: CSCP, CPIM, CLTD
· 2-4 years of experience in inventory planning, supply chain, or production planning
· Experience with ERP systems (Microsoft Dynamics AX preferred)
· Familiarity with Make-to-Order and Make-to-Forecast environments is a plus
· Strong skills in Excel and experience with Power BI or other data visualization/reporting tools
· CPG industry experience and exposure to multi-site or 3PL distribution networks preferred

Hours and Pay:
Position is a straight 5-day week, 8:00 AM - 4:30 PM, and will be based at our facility in Little Chute, WI. We offer a competitive base pay rate and a comprehensive benefits package for full-time employees.


Physical and Mental Demands:
· While performing the duties of this job, the employee is frequently required to sit, hear, use hands to type data, use a personal computer and telephone.
· Specific vision abilities required in this job include close vision and the ability to adjust focus. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
· Mental demands include multi-tasking, decision making, problem solving, comparing, copying, computing, compiling, analyzing, coordinating, and synthesizing data.
· Potential for exposure to chemicals, heights, loud noises, mechanical equipment, wet environments, and other potential hazards exist.

Safety Statement:
At TRILLIANT and HORSESHOE, safety is every employee's first responsibility. We expect all employees to adhere to all safety practices, have the moral courage to stop other individuals from performing unsafe acts, and immediately report unsafe conditions.

Disclosures:
· The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.
· Responsible for following food safety/regulatory policies and procedures, executing responsibilities as identified in standard operating procedures, and reporting food safety/regulatory concerns to the Production or Quality Manager.
· Trilliant Food & Nutrition and Horseshoe Beverage Company are Drug Free Workplaces. All applicants are subject to a drug screen and background check as a condition of employment.
· Trilliant Food and Nutrition and Horseshoe Beverage participate in the E-Verify process.
· EEO/AA including Vets and Disabled
· If you need a reasonable accommodation for any part of the employment process, please contact us by email at HR@trilliantfood.com and let us know the nature of your request and your contact information.
· Trilliant Food and Nutrition is an Equal Opportunity Employer.
· The principles of the OECD and UN have been taken into consideration and used as guidance in our human rights practices and procedures.

Why Join Us:
You'll play a vital role in scaling our operations while maintaining product quality and customer satisfaction. This is a high-impact position for someone who thrives in a dynamic, fast-growing environment and enjoys working with both internal teams and external partners.