The interview included behavioral questions, a case study focused on data interpretation and business reasoning, and a SQL technical assessment. It was conducted by multiple directors and covered both soft and technical skills.

Went through multiple stages for interviews (phone & in person) and it wasn't too long of a process. Fairly positive experience and not overly stressful. Dealt with multiple parties throughout.

I had one 45min recruiter phone interview, then one 1hr interview with the associate director of the department, and finally one 1hr interview with the senior director of the department.