Analyst, Merchandising Promotions

Job Summary

Job Description

• Experience Required: 1 to 3 years merchandising/promotions insights analysis experience
• Experience Desired: 3 years of data analysis and program evaluation for marketing and merchandising;
• 2+ years SAS programming experience and ability to use SAS and SQL to deal with various data processing tasks and statistical analysis
• Experience Desired: Python and Databricks
• Education Desired: Bachelors Degree in Marketing, Business, Finance, Economics or related field

Job Responsibilities

• Evaluate impact on customer behavior from various market activities including competitive defense activities, grand openings and remodels on all formats
• Support marketing and merchandising initiatives by analyzing customer behavior and sales impact from changes in loyalty programs, merchandising initiatives on pricing and promotions, gift cards promotional programs and item-based promotions.
• Gather and analyze data using appropriate technical and analytic techniques. Interface with database tables, pull data from different sources (flat files, database tables) and link them logically.
• Have knowledge on how to deal with the inherent structure of the data. Use SAS SQL and other tools to perform standard statistical analysis, profiling, reporting and models to evaluate programs.
• Develop and maintain knowledge of all internal (Customer Datamart, Data Warehouse) and external, including but not limited to Nielsen, data that support customer analysis and decision making.
• Synthesize primary and secondary customer information, prepare and present comprehensive reports of findings, illustrating data graphically and recommending actions from key insights.
• Act as main point of contact for data availability questions/expertise throughout the organization.
• Work with a line of business leaders and marketing managers in designing reports and analysis. Participate in cross-functional teams to support new initiatives throughout the organization.