Writing 3 SQL queries via Live Zoom Interview including several calculation of metrics and including window functions and CTEs. The interviewer seemed disengaged, providing little feedback, making it a frustrating experience.

Hr screening phone call -> interview with one lead analyst (sql, product sense) -> interview with 2 team leads (product sense, A/B test) -> interview with 2 directors (discussing my experience). The process was much more about how to answer questions working with AI, get AI queries and review them etc. The people I met were nice, and the process was overall good. I didn’t get a chance to discuss my experience up until the final interview, which is a bit annoying because I didn’t get the job because I lack customer facing product experience, which could have been discussed in the first interview instead of the last..