Data Analyst (Junior+)

What you will be doing: • Write SQL queries of any complexity (from simple selections to multi-level nested queries) to the database (PostgreSQL / ClickHouse) to extract user data • Build dashboards in DataLens for the product team • Test hypotheses: analyze user behavior, segment the audience, search for product growth points • Perform Ad-Hoc queries and help colleagues make data-driven decisions

Our requirements: • SQL: ability to write JOINs, use aggregate functions, groupings and simple subqueries, window functions • Analytical thinking: you are interested not just in calculating a number, but in understanding why it is that way and what to do about it • Basic Python: ability to write a simple script, work in Jupyter Notebook and use classical libraries for data analysis • Knowledge of product/marketing analytics metrics. Ability to not just calculate, but interpret the results • Communication: ability to explain complex things in simple language to managers and the dev team

Will be a big plus: • Experience in setting up tracking (Yandex.Metrica, GA, GTM) or transferring data from ad accounts and working with web analytics • Experience with ClickHouse (or any columnar databases)