Analyst, Merchandising Promotions

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 and external 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
• Work as the 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

Requirements

• 1 to 3 years merchandising/promotions insights analysis experience
• 3 years of data analysis and program evaluation for marketing and merchandising
• Advanced excel skills
• 2+ years SAS programming experience and ability to use SAS and SQL to deal with various data processing tasks and statistical analysis

Qualifications

• Bachelor's Degree in Marketing, Business, Finance, Economics or related field