Customer and Product Consultant I

Andrews Distributing Company of North Texas•Dallas, TX

8d•Onsite

About The Position

Join a team recognized as a Top Workplace by USA Today and The Dallas Morning News. This role is for an award-winning Beer & Spirits distributor where team members are valued and respected. The Customer and Product Consultant will be responsible for creating and maintaining customer and product portfolios, managing pricing and promotions, communicating pricing information, and ensuring data integrity. This is a multi-level role where the level varies by experience, expertise, and the complexity of assigned product pricing data and communication. The company emphasizes teamwork and assisting each other to care for customers.

Requirements

Two Plus Years Accounting and/or Finance Experience
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
High School Graduate with some Business, Marketing or Other Related Field College Education
Good Understanding of the Sales Industry
Proven Technical Aptitude; Ability to Learn New Technologies and Acquire Technical Skills

Nice To Haves

Bachelor’s Degree in Finance, Accounting, Economics or Related Field
Previous Distribution Experience
Previous Data Management and/or Data Entry Experience
Strong Analytical Skills
Advanced Communication Skills
Advanced Technical Skills; Experience Working with Varied Systems, Applications, etc.

Responsibilities

Creates and maintains customer and product portfolios.
Maintains and audits product pricing and promotions.
Sets up and maintains frontline prices and monthly promotions by premise type, geo area, and sales channel, as well as supplier laid-in costs.
Assists in general price increases.
Tracks and executes customer and product quarter-end changes.
Reviews customer portfolio to understand which fields require a quarter-end change, including schedule and routing changes.
Reviews product data to fully understand which product fields require a quarter-end change.
Tracks request changes throughout the quarter.
Implements quarter-end change requests.
Submits National Accounts pricing contracts and new item execution into eoStar.
Submits frontline and promotion pricing to all National Accounts monthly via excel spreadsheet or vendor portal.
Researches to determine which promotion level (QD) the National Account will buy to ensure the correct price is submitted.
Works closely with National Account Managers and National Account representatives to service models, outlining step-by-step procedures for price submissions to ensure price realization at market.
Assists Accounts Payable team with supplier laid-in costs discrepancies by researching supplier costs.
Communicates with Brand team and supplier to determine correct costs.
Updates eoStar as applicable.
Participates in other department projects and initiatives as required.
Communicates pricing to Sales and Brand teams, retailers, and suppliers via price letters, bridge buy guides, cheat sheets, and new item letters.
Maintains and updates price letters by geo area, premises, and sales channel to ensure Sales and Brand teams have accurate pricing to communicate to retail partners.
Provides price letters to retail partners and suppliers as requested.
Creates and maintains new item letters for all products capturing product attributes, price, promotion, UPC data, and visuals for Sales and Brand teams, and retail partners.
Creates and communicates price changes, product logs, and Can Sell reports.
Maintains and publishes products and pricing logs on BrewView.
Communicates Product Can and Cannot Sell report to Sales, Brand, and Distribution Center teams on a weekly basis.
Creates and publishes price change posts on BrewView.
Creates and maintains retail price lists for Sales team shelf tag creation.
Communicates general price increase prices.
Creates, maintains, and audits customer and product files including all customer and product attributes.
Ensures all customer and product attributes are up to date and product is approved on TABC website.
Creates, maintains, and audits all relevant product records including supplier, brand, family, and package records.
Creates, maintains, and audits all relevant customer records including sales channels, TABC license permits, customer flags, Nielsen, and TDLinx data.
Creates and runs ad hoc account, activity, and project performance reports on a weekly, monthly, and as-needed basis.