I had a 45-minute technical interview with a Senior Data Scientist consultant. The session included three SQL questions and one Python question, focused on sales transactions and data manipulation. One point of friction was that the interviewer asked me not to use window functions and instead pushed for a GROUP BY solution. While I adapted under pressure, I felt the conversation was more rigid than collaborative. Overall, the process was structured and timely, but I would have appreciated more flexibility in the problem-solving approach — especially for senior-level candidates who may use different methods to arrive at the correct solution.
