Spirits Allocations Analyst

Andrews Distributing; United States; On-site; USD 60,000 - 90,000; Full time

Benefits offered by this job

Weekly Pay

Health, Dental, & Vision Insurance

Paid Vacation & Sick Time

401k with Company Match

Free Beer (Root beer for under 21)

Job summary

Andrews Distributing seeks a Spirits Allocations Analyst I to manage allocation processes for beer and spirits brands across multiple accounts and regions. You will analyze historical sales, monitor inventory, and collaborate with Sales, Brand, and Finance to optimize allocation strategies.

The role emphasizes governance, data storytelling, and cross-functional teamwork in a fast-paced distribution environment. Experience with ERP and advanced Excel is valued.

Qualifications

• Bachelor’s degree required; two+ years in FP&A, commercial finance, revenue management, or related analytics role preferred.
• Experience with inventory or allocation planning is a plus.
• Must be detail oriented with strong analytical and organizational skills.

Responsibilities

• Collaborate with Product Management to set up new allocations and item distributions.
• Manage allocation models for limited or highly allocated SKUs and input allocations into ERP.
• Monitor inventory positions, inbound supply, depletion rates, and identify risks.
• Coordinate with Sales, Brand, and Finance to align allocation with revenue and margin forecasts.
• Create dashboards and reports showing allocation vs depletion, inventory health, and exception trends.

Skills

Analytical thinking

Data interpretation

Inventory planning

Cross-functional collaboration

Forecasting

Attention to detail

Communication

Advanced MS Excel

PowerPivot/PowerQuery

Education

Bachelor’s Degree in Finance, Supply Chain, Economic or Related Field

Tools

ERP system

Microsoft Excel

Power BI

Job description

Cheers to a Beer & Spirits Career! Join the team that has been recognized by both USA Today and The Dallas Morning News as a Top Workplace! The fact that you landed here indicates you are looking for a better workplace. Maybe you feel unappreciated, and you are tired of being treated like just another employee. When you join our team, you become part of the Andrews family, a place where you are valued and respected.

We invest in our team members and are dedicated to their success by offering:

• Weekly Pay
• Every Friday Health, Dental, & Vision Insurance Paid Vacation & Sick Time
• 401k with Company Match (FREE Money!!)

And yes, you will receive free Beer throughout the year! (Root beer to those under 21 years old.)

After all, you will be working for an award-winning BEER & Spirits distributor, and we want you to enjoy the brands you already love like Modelo, Coors, Miller Lite, Corona, Heineken, Blue Moon, Shiner, Sam Adams, Dos Equis, Revolver, Lakewood, Rahr, Truly, Topo Chico, Twisted Tea, Pacifico, and many more!!

And for those who enjoy spirits, Andrews is now distributing some of the top brands within the Spirits category such as Buffalo Trace, Fireball, Southern Comfort, Corazon, Wheatley, Seagram's, Canadian Mist, and other Whiskey, Rum, Vodka, Gin, Brandy, Cognac, and Tequila brands!

So let's talk about the role...

A Spirits Allocations Analyst I can be expected to perform the following tasks in this role as a routine part of their job:

Product and Order Management

• Collaborates with Product Management team for set up of all new allocation and single barrel allocated items.
• Communicates with Sales and local supplier teams for distribution of single barrel items when received.
• Manages entry of allocated orders in ERP system.
• Manages allocation models for limited and highly allocated spirits SKUs.
• Distributes product across: Accounts (On Premise, Off Premise, Chains and Independents), regions/territories and channels (retail, wholesale, e commerce).
• Ensures allocations align with documented allocation methodologies, contractual obligations, brand strategy and regulatory compliance requirements.

Data Analysis and Forecasting

• Analyzes historical sales, depletion trends, and customer performance.
• Monitors inventory positions, inbound supply, and depletion rates.
• Identifies risks (over allocation, stockouts, misalignment).

Stakeholder Collaboration

• Partners with Sales leadership to understand account priorities.
• Coordinates with Brand team and Supply Chain on supply availability and timing.
• Supports Finance with allocation assumptions tied to revenue and margin forecasts.
• Communicates allocation logic clearly to internal teams and external partners.

Allocation Governance and Controls

• Maintains transparent, defensible allocation rules and documentation.
• Supports audit and compliance requests (especially for highly scrutinized allocations).
• Identifies and flags exceptions or special requests.
• Ensures consistency across regions while allowing for strategic flexibility.

Reporting and Insights

• Creates dashboards/reports and provide insights showing allocation vs. depletion, customer performance against allocation, inventory health and turns and allocation exception trends and root causes.

This list is not all inclusive of other tasks and subtasks that may be necessary in performing this role, but rather an overview of the role’s primary work tasks.

Capabilities

A Spirits Allocations Analyst I has a greater opportunity to succeed if they can develop and master the following job-related capabilities and KSAs:

Knowledge

• Accounting Principles
• Analysis and Reasoning Principles
• Andrews Business, Structure and Workflow
• Andrews Portfolio
• Beer, Spirits, Beverage and Distribution Industry
• Business Acumen
• Beverage Retail Business
• Category Management
• Competitive Portfolios
• Customer Service Principles
• NTX and STX Geographic Area
• Elevate Your Game Competencies
• Financial Acumen
• Financial Modeling
• Market Segmentation
• Merchandising Literacy
• Model Marketing Concepts
• Pricing Management
• Project Management Process
• Quality Standards
• Retail Channels and Strategies
• Sales Methodologies
• Selling Principles
• Standards for Service Professionals
• Supplier Expertise
• Syndicated Data
• TABC Guidelines

Skills & Abilities

• Ability to Build Trust
• Ability to Collaborate in a Team Environment
• Ability to Draw Insights from Data
• Ability to Gather, Interpret and Apply Business/Financial Data
• Ability Work with Cross-Functional Teams
• Ability to Solve Problems and Develop Potential Solutions
• Ability to Work Steadily at a Fast Pace to Meet Time Schedules and Deadlines
• Active Listening and Feedback Skills
• Analytical Thinking and Problem-Solving Skills
• Attention to Detail Skills
• Collaboration Skills
• Communication and Interpersonal Skills
• Customer Service Skills
• Gathering, Interpreting and Applying Business/Financial Data
• Organizational skills
• Advanced MS Office Suite Skills
• Presentation Skills
• Project Management Skills
• Team Building and Collaboration Skills
• Technical Aptitude/Computer/iPad Skills
• Time Management and Prioritization Skills

Qualifications

A qualified candidate for the Spirits Allocations Analyst I role should satisfy the expectations (Experience and Education) below:

Required

• Bachelor’s Degree in Finance, Supply Chain, Economic or Related Field
• Two Plus Years FP&A, Commercial Finance, Sales Finance, Revenue Management, Demand Planning, Supply Planning or Similar Analytics Role
• Experience with Inventory or Allocation Planning
• Advanced MS Office (Excel) Experience; VLOOKUP, Advanced Formulas, External Data Connections, PowerPivot, PowerQuery, Macros
• Must be Detail Oriented, Have Strong Analytical and Organizational Skills and Have the Ability to Work in a Fast-paced Work Environment
• Good Understanding of the Sales Industry
• Proven Technical Aptitude; Ability to Learn New Technologies and Acquire Technical Skills

Preferred

• Experience in Spirits, Wine, Beer, or CPG
• Experience Working with Highly Allocated or Luxury Products
• Previous Distribution Experience
• Prior Selling Skills
• Advanced Communication Skills

DISCLAIMER Andrews Distributing Company, LLC (the company) reserves the right to revise this job description at any time. This job description does not constitute a contract of employment; the company and employee may exercise its employment-at-will rights at any time. Employees must be able to perform the essential functions of the position satisfactorily; if requested, reasonable accommodations may be made to enable employees with disabilities to perform the essential functions of their job, absent undue hardship.

Andrews Distributing is proudly family owned and operated, as the number one beer and spirits distribution company in Texas as well as one of the nation’s largest beer and spirits distributors. Our six Hometowns operate with facilities in Dallas, Allen, Corpus Christi, Ennis, Fort Worth, and Laredo, Texas. Andrews was named a winner of Top Workplaces by USA Today in 2025 and employs nearly 2,000 proud service professionals. The company is committed to providing a consistently excellent experience for their 13,750 customers with a portfolio that offers over 920 beer and 470 spirits brands in 29 North and South Texas counties. Andrews strives to be known as the most Customer Obsessed, Brand Building team that sets the standard for the beer and spirits industry.

Andrews Distributing is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, or disability status.