Customer and Product Consultant I

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.Schedule: Monday - Friday.We invest in our team members and are dedicated to their success and well-being by offering:Weekly Pay, Every Friday!Health, Dental, & Vision insurancePaid Vacation & Sick Time401k with Company Match (FREE Money!!)Nike Branded UniformsAnd 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!Here's more of what you will do...A Customer and Product Consultant can be expected to perform the following tasks in this role as a routine part of their job:Customer, Product Pricing and Promotions 40%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 increase.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 quarter.Implements quart-end change requests.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.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.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.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.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.This is a multi-level role; role level varies by experience, expertise/knowledge, and complexity of assigned product pricing data and communication. Here at Andrews, we always step outside of our normal responsibilities to assist each other and effectively care for Customers.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.CapabilitiesA Customer and Product Consultant has a greater opportunity to succeed if they can develop and master the following job-related capabilities and KSAs:KnowledgeAccounting PrinciplesAnalysis and Reasoning PrinciplesAndrews Business, Structure and WorkflowAndrews PortfolioBeer, Spirits and Distribution IndustryBusiness AcumenBeverage Retail BusinessCompetitive PortfoliosCustomer Service PrinciplesDFW and Corpus Christi Geographic AreaMerchandising LiteracyPricing ManagementProject Management ProcessQuality StandardsRetail Channels and StrategiesSelling PrinciplesSupplier ExpertiseSyndicated DataTABC GuidelinesSkills & AbilitiesAbility to Collaborate in a Team EnvironmentAbility to Draw Insights from DataAbility to Use Accounting Software EfficientlyAbility to Draw Insights from DataAbility to Interpret and Applying Business/Financial DataAbility to Solve Problems and Develop Potential SolutionsAbility to Work Steadily at a Fast Pace to Meet Time Schedules and DeadlinesAnalytical Thinking and Problem-Solving SkillsAttention to Detail SkillsCollaboration SkillsCommunication and Interpersonal SkillsCustomer Service SkillsGathering, Interpreting and Applying Business/Financial DataOrganizational skillsProficient MS Office Suite SkillsProject Management SkillsTeam Building and Collaboration SkillsTechnical Aptitude/Computer/iPad SkillsTime Management and Prioritization SkillsQualificationsA qualified candidate for the Customer and Product Consultant role should satisfy the expectations (Experience and Education) below:RequiredTwo Plus Years Accounting and/or Finance ExperienceAdvanced MS Office (Excel) Experience; VLOOKUP, Advanced Formulas, External Data Connections, PowerPivot, PowerQuery, MacrosMust be Detail Oriented, Have Strong Analytical and Organizational Skills and Have the Ability to Work in a Fast-paced Work EnvironmentHigh School Graduate with some Business, Marketing or Other Related Field College EducationGood Understanding of the Sales IndustryProven Technical Aptitude; Ability to Learn New Technologies and Acquire Technical SkillsPreferredBachelor’s Degree in Finance, Accounting, Economics or Related FieldPrevious Distribution ExperiencePrevious Data Management and/or Data Entry ExperienceStrong Analytical SkillsAdvanced Communication SkillsAdvanced Technical Skills; Experience Working with Varied Systems, Applications, etc.DISCLAIMERAndrews Distributing Company of North Texas, 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.Please note -we ask all candidates to create an account in order to apply for a position with us. Please click "Apply" then "Create Account" to create a new account, or sign in if you are a returning applicant. #J-18808-Ljbffr