Data Analyst

What do you usually do after the SQL for a DBT model is ready?

SQL task: calculate conversion by experiment groups (exp_id=90) from Epic Match Start event to Epic Fight Win based on users, with correct event attribution to the experiment via join on time.

Python task: build user sessions based on events (new session if gap > 30 minutes) and calculate daily aggregates.

Tell me about indexes in ClickHouse.

What is a semi-join and anti-join? Why are they needed and where are they applied?

What is the difference between ORDER BY and PRIMARY KEY in ClickHouse, and why are they separated?.

Provide an example when you initiated changes in DWH, pipeline, or data model yourself.

We have ClickHouse with a DBT query that runs regularly but takes a long time. What could be the reasons and how would you approach optimization?

How do you decide which tests to write for a DBT model? Are alerts needed?

Tell about approaches to building DWH: Data Vault 2.0 vs snowflake/star — main entities, advantages, and disadvantages.