Prior to the face to face interview, I had a phone screen. For the phone screen, it was pretty standard with slight weight on the technical side. They asked some basic queries such as those that require Group By and knowledge of basic data modeling like a Junction Table. The face-to-face interview process was intense. There were 3 interviewers: the manager, the BI team lead, and the data warehousing team lead. The questions range from moderately to extremely difficult and I was barraged with remarks such as "How many years of SQL experience did you say you have?" and little gasps whenever I was unable to answer the question. Example of the level of difficulty of questions I was asked is to merge an attribute of multiple rows based on a key. For example, if the key is 1.... input: col1, col2 1; 1 1; 2 1; 3 output: col1, col2 1; 1, 2, 3 2 of the interviewers were inattentive and on their phone a lot of the time. The manager was attentive and gave generic "Very good" responses. According to the recruiter, the team was testing how I would react in a stressful scenario. The entire interview process took 2.5 hours. Also note that if you put down anything on your resume like C# (that is loosely related with Business Intelligence), they will grill you hard on the topic as well. They will ask the libraries and methods you use as well as the API process to connect to the database. I'm not sure how far they would have went with the questions since I was not prepared for deep C# scrutiny in a BI Developer interview; but, brush up on it to a Data Engineer or C#/.NET Developer level if you want to be extra safe. In the end, I was surprised to get the offer because I could not fully answer at least 50% of the questions.