Customer and Product Consultant I

About the role

The team at Andrews Distributing Company of North Texas, LLC has been recognized by USA Today and The Dallas Morning News as a Top Workplace. This role is available to individuals seeking a better workplace environment.

Responsibilities

• Customer, Product Pricing and Promotions (40%)

• 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.
• Affords assistance 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.
• Tracked request changes throughout the quarter.
• Submits National Accounts pricing contracts and new item execution into eoStar.
• Submits frontline and promotion pricing to all National Accounts monthly whether by 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 the National Account Managers and National Account representatives to service model, outlining step by step procedures for price submissions to ensure price realization at market.
• Affords assistance with supplier laid-in costs discrepancies by researching supplier costs.
• Communicates with Brand team and supplier to determine correct costs.
• Updates eoStar as applicable.

• Pricing Communication (30%)

• Communicates pricing to the 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.
• 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.

• Data Maintenance and Integrity (20%)

• 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.

• Reporting (10%)

• Creates and runs ad hoc account, activity and project performance reports on a weekly, monthly and as needed basis.

Qualifications

• Required:

• Two plus years accounting and/or finance experience.
• Advanced MS Office (Excel) experience; VLOOKUP, Advanced Formulas, External Data Connections, PowerPivot, PowerQuery, Macros.
• Detail oriented, strong analytical and organizational skills, and 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.

• PREFERRED:

• Bachelor’s degree in Finance, Accounting, Economics or related field.
• Previous distribution experience.
• Data management and/or data entry experience.
• Strong analytical skills.
• Advanced communication skills.
• Advanced technical skills; experience working with varied systems, applications, etc.

Benefits

• Weekly Pay, Every Friday!

• Health, Dental, & Vision insurance

• Paid Vacation & Sick Time

• 401k with Company Match (FREE Money!!)

• Nike™ Branded Uniforms

• Free Beer throughout the year!

Pay

Commensurate with experience.

Schedule

Monday - Friday.