Standard case studies and coding interviews, nothing surprising. Also included behavior questions. Tech screen followed by final loop of 5 rounds of interviews. Talked about past projects and hypothetical scenarios.
I applied online. I interviewed at Compass (New York, NY) in Apr 2021
Interview
1. Phone Screen
2. Technical SQL interview
3. Business Case interview
4. Hiring Manager Interview
Nothing was terribly hard as long as you're prepared to answer some business case questions and know your SQL well.
Interview questions [1]
Question 1
Three SQL questions of various difficulty on pulling and transforming data