Production Analyst

Production Analyst Job Description History

Lift Bridge Brewery is a leading production brewery located in Stillwater, the birthplace of Minnesota. We are expanding and looking for the right team members to grow with us!

The Production Analyst owns the flow of operational data through Lift Bridge Brewery. The role converts distributor demand into production and packaging schedules, moves orders through fulfillment to invoice and payment, maintains inventory and item accuracy in our ERP system, prepares and files all federal and state alcohol excise returns, and produces the daily, weekly and monthly reporting leadership uses to run the business.

This is a hands-on operations role. The Production Analyst connects four groups that do not otherwise talk to each other directly like brewing and packaging, the warehouse, sales, and accounting. This role is the single point of accuracy for the numbers the brewery runs on. It is also the person everyone calls when an order, a shipment, or a filing does not look right.

• Receive and process distributor sales orders arriving through the distributor orders inbox, DSD Link, and the Encompass portals for Capitol Beverage and College City Beverage; enter and maintain them in the ERP.
• Monitor the open sales order book daily including aged orders, short ships, allocation conflicts and unshipped lines, and resolve exceptions with sales and the warehouse.
• Invoice shipped orders accurately, applying correct pricing, deals and distributor terms.
• Publish sales orders and inter-facility transfers to the shared warehouse calendar so the team has forward visibility of the shipping schedule.
• Build and schedule outbound loads for distributor pickups.
• Set up and manage outsourced production and contract-brewing orders.
• Process distributor EFT draws and reconcile them against accounts receivable.

• Own and maintain the make-to-order production sheet: translate demand, on-hand inventory and in process volume into an executable brewing schedule.
• Build and publish the bi-weekly packaging schedule, coordinating with materials availability and packaging crew capacity.
• Plan co-packed production with contract partners, submit orders through their systems, and manage the run calendar.
• Receive completed co-packed production into inventory and reconcile actual yield against plan.

• Maintain the materials sheet covering raw goods, packaging materials, cans, labels and brite goods; track reorder points and supplier lead times.
• Enter goods receipts against purchase orders and resolve receiving discrepancies.
• Run periodic physical inventory counts, investigate variances, and post adjustments - including the finished-goods records that support excise reporting.
• Place and track purchase orders through supplier portals.

• Create and maintain item codes across the ERP, VIP and the Encompass distributor portals, keeping all three in sync.
• Manage new product and package setup end to end, so a new SKU is orderable, produceable, reportable and taxable from day one.
• Audit item data regularly to catch drift between systems before it reaches depletion reporting or chargebacks.

• Prepare and file federal TTB excise returns for beer and for spirits, including removals, transfers in bond, exports and losses.
• Prepare and file state excise returns for multiple states on their respective schedules.
• Maintain the production, removal and inventory records that substantiate every filing and would be produced in an audit.
• Track the filing calendar across all jurisdictions and ensure no return is late.

• Produce the…