- First phase: Sql interview about joins, filters, where statement, loops and other coding tricks - Second phase: Case studies. First one about establishing and assessing which KPI to define for the launch of a new product feature, and based on them build a dashboard. Second, how analytically define how much to pay for a marketing campagin based on a specific objective using some analytical framework. - Third phase: Interview with the manager about experience, views on the responsibilities of the unit and Q&A session (STAR approach) - Fourth phase: Final assessment with a Senior partner about typical STARs frameworks