Data Analyst

Conditions

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

Position

• Role: Data Analyst
• Level: Senior

Required

• At least 2–3 years of experience in CRM analytics in retail and/or e-commerce.
• Proficient practical knowledge of Python for data analysis, including working with pandas and tabular data processing.
• Advanced SQL proficiency.
• Experience with web and mobile analytics systems: Yandex Metrika, AppsFlyer, AppMetrica.
• Experience with PostgreSQL, Greenplum, ClickHouse.
• Experience analyzing CRM communications, trigger and promo campaigns.
• Experience evaluating campaign effectiveness using control groups and comparing metrics before, during, and after the campaign (pre / promo / post).
• Understanding of marketing attribution principles and evaluating 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 objectives.
• Understanding of time series analysis principles.
• Practical experience in conducting and analyzing A/B test results.
• Higher education in mathematics or technical field.
• 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 campaign correctness.
• Defining and approving the methodology for evaluating campaign and pilot effectiveness.
• Analyzing the effectiveness of trigger campaigns and pilots:
• analyzing the communication funnel, including deliverability, views/opens, click-through rate, and conversion;
• analyzing A/B test results;
• comparing test and control groups;
• evaluating the incremental effect of campaigns;
• assessing the impact of campaigns on sales and margin;
• analyzing the effectiveness of communication channels and attribution of results;
• identifying key growth points.
• Selecting and justifying metrics and evaluation methods based on the business task and data distribution characteristics.
• Forming and testing hypotheses for changes in mechanics, campaigns, creatives, and pilots based on analysis results.
• Performing plan-fact and ad-hoc analysis.
• Building short- and medium-term forecasts.
• Automating reporting for trigger campaigns and pilots.
• Preparing requirements for CRM system enhancements needed for launching pilots and conducting A/B tests.