Category Manager Analytics

Description

The Category Manager Analytics will work cross-functionally within Dr Pepper Snapple Group and externally with Walmart to leverage Modular, POS and Panel data with the goal of maximizing category sales, profit and shopper satisfaction.

The Category Manager Analytics will draw on diverse data sources and use best-in-class technology to create value for Dr Pepper Snapple Group.

This role will support the category managers, the customer (Walmart) and our Corporate Office with detailed analytics.

Below if a brief overview of the role:

• Blending of customer data (Retail Link) with our internal data.
• Managing databases including loading data, extracting it and transforming it.
• Comparing changes to mods i.e. what was on the mod before, what’s on now. What drove the changes and how does it relate to our sales?
• Leveraging our tools e.g. Tableau to create dashboards to help explain the changes to our business and the mods.
• Analyzing the data to identify trends and opportunities (and gaps).
• Predicting future trends based on the data. (clustering, association, decision trees)
• Analyzing the data to identify trends and opportunities (and gaps).
• Predicting future trends based on the data. (clustering, association, decision trees)? this might be a bit more difficult, somebody with an Economics degree.

LOCATION AND TRAVEL:

This person will report to the Director of Category Management. This role is located in Rogers, AR, with up to 10% travel.

ADDITIONAL JOB RESPONSIBILITIES:

• Utilize data and insights to deliver retailer-centric recommendations for growth on DPSG portfolio supporting Walmart and SAMs Club.
• Analyze Mod data to provide prescriptive recommendations and be a value added partner bringing customer first assortment and flow recommendations.
• Apply data mining techniques to modular, sales and syndicated data.
• Processing, cleansing and validation of data used for analysis.
• Propose analytic strategies to solve business problems.
• Analytical interpretation of data and translation into visually impactful presentations. Utilize best in class tools such as Retail Link, Nielsen, IRI, Nitro, JDA, Tableau, Richmix and other industry tools.
• Provide modular support including data extraction and drawing (JDA).
• Collaborate with cross functional teams (Category Management, Insights, Shopper Marketing, Space Optimization) to leverage syndicated data and shopper insights.
• Communicate and educate the organization on best in class data interpretation techniques.
• Manage multiple competing priorities under demanding time constraints with a focus on driving results

CORE COMPETENCIES:

• Building Partnerships- Identifying opportunities and taking action to build strategic relationships between one’s area and other areas, teams, departments, units, or organizations to help achieve business goals.
• Building Trust- Interacting with others in a way that gives them confidence in one’s intentions and those of the organization.
• Decision making- Identifies and understands issues, problems, and opportunities; compares data from different sources to draw conclusions; uses effective approaches for choosing a course of action or developing appropriate solutions; takes action that is consistent with available facts, constraints, and probable consequences.
• Formal Presentation- Presenting ideas effectively to individuals or groups when given time to prepare; delivering presentations suited to the characteristics and needs of the audience
• High Impact Communication- Clearly and succinctly conveying information and ideas to individuals and groups in a variety of situations; communicating in a focused and compelling way that drives others’ thoughts and actions.
• Planning and Organization- Establishing courses of action for self and others to ensure that work is completed efficiently.
• Sales Ability/Persuasiveness- Using appropriate interpersonal styles and communication methods to gain acceptance of a product, service, or idea from prospects and clients.
• Continuous Learning- Actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities; using newly gained knowledge and skill on the job and learning through their application.
• Innovation- Generating innovative solutions in work situations; trying different and novel ways to deal with work problems and opportunities.
• Work Standards- Setting high standards of performance for self and others; assuming responsibility and accountability for successfully completing assignments or tasks; self-imposing standards of excellence rather than having standards imposed.

Qualifications

• Bachelor’s degree from an accredited institution with a focus on business analytics. A Masters or MBA is preferred.
• 5 years’ experience in Category Management/Sales/Finance and/or Marketing analyzing data such as assortment selections, sales trends and market trends.
• 2 years’ experience using IRI, Nielsen Scantrack, or other syndicated data to provide value added insights to retailer and sales personnel.
• 2 years’ experience using Retail Link. Additional experience using RSI a plus.
• 5 years’ experience using MS Office products such as PowerPoint, and Microsoft Excel (e.g. pivot table creation, vlookup, filters, conditional formulas), MS Access or MS SQL.
• A strong foundation in Business Analytics, including an understanding of key predictive measures and tools. Ability to blend big data sources to extract meaningful recommendations from diverse data.
• 2 years experience with data visualization methods and tools (e.g. Tableau)
• 2 years experience with JDA Space Planning.

Dr Pepper Snapple Group, Inc. (NYSE: DPS) is one of North America’s leading refreshment beverage companies, manufacturing, bottling and distributing more than 50 brands of carbonated soft drinks, juices, teas, mixers, waters and other premium beverages.

With a brand heritage spanning more than 200 years, the DPS portfolio includes some of the most recognized beverages in the Americas. More than 75 percent of the company’s overall volume is from brands that are either #1 or #2 in their flavor categories. In addition to its flagship Dr Pepper and Snapple brands, the DPS portfolio includes 7UP, Mott’s, A&W, Sunkist soda, Hawaiian Punch, Canada Dry, Schweppes, RC Cola, Diet Rite, Squirt, Peñafiel, Yoo-hoo, Rose’s, Clamato, Mr & Mrs T and other well-known consumer favorites.

Dr Pepper Snapple Group is an equal opportunity employer and affirmatively seeks diversity in its workforce. Dr Pepper Snapple Group recruits qualified applicants and advances in employment its employees without regard to race, color, religion, gender, sexual orientation, gender identity, gender expression, age, disability, genetic information, ethnic or national origin, marital status, veteran status, or any other status protected by law. Equal Opportunity.Employer. Minorities/Females/Disabled/Protected Veterans