Marketing analyst in Hop Hey

The Hop Hey convenience store chain has been on the market for 15 years and has more than 300 stores. We are part of the Sea of ​​Beer Group of Companies, which has its own production of beer, cider and snacks, so we offer the largest selection of drinks and snacks among beer shops.

In connection with staff expansion, we are opening a marketing analyst vacancy.

What we offer:

• Convenient hybrid work format: office or remote at the request of the employee;
• Competitive salary;
• Professional development in a national scale company, leaders in their segment;
• Education opportunity.

What you will do:

• buyer behavior analysis based on transactions (multiple data sources - QlickView and Database Program data Loyalty);
• segmentation of customers by behavioral characteristics. LTV, RFM customer analysis;
• analysis of the impact of external factors on customer behavior (survey data, promotions, competitor actions, etc.)

What it takes:

< li> advanced level of mastery of MS Excel, including the use of business intelligence tools: Power Query, Power Pivot, setting up macros;
• experience in working with large data sets, in particular customer transactions, as one of the main sources of information;
• knowledge of such metrics as: CAC, LTV, RFM, Churn Rate, Retention Rate, ARPU, CSAT , NPS, CES, ROI, Gross Margin, AOV, Conversion Rate, Cross-sell Rate, Upsell Rate, Engagement Rate,, CPC, CPL, CPA, Impressions, Reach, Attribution Model, Repeat Purchase Rate, Customer Loyalty Index, First Response Time, Active Customer Rate;
• ability to work with qualitative data and converting it into quantitative data through ranking, rating scales, frequency approach, etc.