Job Summary
The Sales and Marketing Analyst is responsible for driving the data to make impactful decisions in a fun, fast-paced quick-service restaurant environment. This includes managing our analysis for campaigns, pricing, marketing programs, media and delivering those results and recommendations that will guide strategy. This person will work cross-functionally with all disciplines of marketing and our Finance Team. The ideal candidate will have the curiosity and drive to explore solutions driven by the data.
Responsibilities
Campaign Analysis
• Monitor and track sales of campaign items
• Look for trends, calculate break-even points and determine campaign profitability
• Research historical sales trends of campaign items on the proposed calendar to help forecast campaign profitability
Pricing Analysis
• Create and maintain database of historical and current pricing to perform ongoing analytics
• Send and compile periodic surveys real time pricing changes
• Maintain internal databases and files for pricing analysis
Marketing Program Analysis
• Perform return on investment analysis of existing and proposed marketing programs
• Plan, design, and create data visualizations that clearly communicate campaign results for KPIs and other metrics of interest
• Conduct menu analysis of categories to establish seasonality of menu mix
• Determine potential sales lift from test items and new initiatives
• Work collaboratively with Media, Digital and Field teams on data-related analysis
Research and Strategy
• Assist in administering research through internal and external sources
• Provide recommendations based on research in the development of brand strategy
• Make Media & Digital recommendations and POVs when applicable
• Aid in consumer and competitive analysis in campaign development, pricing and media opportunities
• Assist in developing data mining opportunity within our digital analysis
Financial Planning & Analysis
• Prepare annual Budget and periodic Forecast for the Marketing department
• Prepare monthly commentary on sales and marketing performance including variance explanations for actual versus budgeted/expected results
• Develop interface with Great Plains accounting software to facilitate budget preparation and monthly results analysis
Reporting and Analysis
• DOMO – Develop expertise on the product and determine appropriate application for Jack’s.
• Develop content and delivery method for sales KPI reporting
• Plan experiments and offer internal analysis for A/B testing on multi-variate tests
• Prepare presentation materials for Board of Directors meetings
• Maintenance of automated reporting dashboard and data pipelines
• Perform Ad-hoc analysis and manage special assignments as needed
Qualifications
• Bachelor’s Degree in Business or related field required. Master’s degree desired.
• 5+ years’ experience in field or related field
• Strong SQL background
• Advanced data analytics and statistical analysis skills
• Dashboard-building and reporting experience
• Detailed understanding of sales and marketing functions
• Detailed understanding of financial measures and KPIs
• Excellent computer skills in Excel and other MS Office programs
• Strong organization, problem-solving, and time-management skills
• Good verbal and written communication skills
• Relational database experience preferred