Data Analyst

Conditions

• Employment: full-time
• Location: RF, Moscow
• Citizenship: RF and friendly countries
• Working schedule: MSK
• Format: Hybrid

Position

• Role: Data Analyst
• Level: Senior

Required

• Experience in CRM analytics for 2–3 years in retail and/or e-commerce.
• Confident practical proficiency in Python for data analysis, including working with pandas and tabular data processing.
• Advanced SQL proficiency.
• Experience with web and mobile analytics systems: Yandex.Metrica, AppsFlyer, AppMetrica.
• Experience with PostgreSQL, Greenplum, ClickHouse.
• Experience in analyzing CRM communications, trigger, and promo campaigns.
• Experience in evaluating campaign effectiveness using control groups and comparing metrics before, during, and after the campaign (pre / promo / post).
• Understanding of marketing attribution principles and assessing the contribution of channels/communications to conversion and sales.
• Good knowledge of mathematical statistics: understanding data distributions, statistical significance, confidence intervals; ability to select metrics and evaluation methods considering data properties and business tasks.
• Understanding of time series analysis principles.
• Practical experience in conducting and analyzing A/B test results.
• Higher mathematical or technical education.
• Ability to interpret analysis results and formulate business conclusions and recommendations based on them.
• Ability to independently formulate hypotheses and test them with data.

Tasks

• Participation in the full cycle of analysis for trigger campaigns, pilots, and A/B tests.
• Participation in setting up campaigns and pilots in the CRM system: defining exclusion logic, forming test and control groups, setting up A/B tests; monitoring the correct operation of campaigns.
• Definition and approval of the methodology for evaluating the effectiveness of campaigns and pilots.
• Analysis of the effectiveness of trigger campaigns and pilots:
• analysis of the communication funnel, including deliverability, views/opens, click-through rate, and conversion;
• analysis of A/B test results;
• comparison of test and control groups;
• assessment of the incremental effect of campaigns;
• evaluation of the impact of campaigns on sales and margin;
• analysis of the effectiveness of communication channels and attribution of results; defining key growth points.
• Selection and justification of metrics and evaluation methods depending on the business task and data distribution characteristics.
• Formation and verification of hypotheses for changing mechanics, campaigns, creatives, and pilots based on analysis results.
• Conducting plan-fact and ad-hoc analysis.
• Building short- and medium-term forecasts.
• Automation of reporting for trigger campaigns and pilots.
• Preparation of requirements for CRM system enhancements necessary for launching pilots and conducting A/B tests.