Brewery Production & Data Analyst

Lift Bridge Brewing Company; Stillwater (MN); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

PTO 2 weeks

6 paid holidays

401K with company match

Employer sponsored healthcare

Free beer and gear

Job summary

Lift Bridge Brewery is seeking a Production Analyst to oversee the flow of operational data from distributor demand to production, packaging and invoicing. You will maintain ERP data accuracy, file excise returns and produce leadership dashboards to guide decisions.

The role requires strong Excel skills, ERP experience, and the ability to manage multiple concurrent workstreams while communicating clearly with brewers, warehouse staff and leadership.

Qualifications

• Two or more years in production planning, supply chain, operations analysis or inventory control.
• Advanced Excel with pivot tables, lookups, and multi-tab workbooks.
• Demonstrated ERP experience and ability to learn mid-market ERP quickly.

Responsibilities

• Order management: process distributor orders, enter in ERP, monitor open orders and resolve exceptions.
• Production planning: translate demand into brewing schedules and plan packaging/CO-pack production.
• Inventory control: maintain materials sheets, track replenishments and perform counts.
• Data management: create and maintain item codes across ERP, VIP and Encompass portals.
• Regulatory/excise: file federal/state returns and support audits with accurate records.
• Reporting/forecasting: generate daily/weekly/monthly reports and analyze variances.
• Taproom/internal consumption: record depletions from POS and ensure accuracy.

Skills

ERP experience

Advanced Excel

Numerical accuracy

Multi-project management

Effective communication

Education

Bachelor's degree in Finance/Accounting/Statistics/Economics/Supply Chain

Tools

Orchestrated / OBeer

VIP

Encompass

DSD Link

SQL

Power BI

Power Query

Job description

Lift Bridge Brewery is seeking a Production Analyst to oversee the flow of operational data from distributor demand to production, packaging and invoicing. You will maintain ERP data accuracy, file excise returns and produce leadership dashboards to guide decisions.

The role requires strong Excel skills, ERP experience, and the ability to manage multiple concurrent workstreams while communicating clearly with brewers, warehouse staff and leadership.