Skip to contentSkip to footer

Bi Engineer Interview Questions

Salaries
Interviews

Bi Engineer Interview Questions

A business intelligence engineer, or BI engineer for short, will probably receive several questions about their ability to use scripting languages, processors, and programs used by the prospective employer's company. Though some questions about human relations may come up, the BI Engineer interview may be more involved with your experience level in data analysis.

Top BI Engineer Interview Questions & How To Answer

Question 1

Question #1: What is a previous project you're proud to have worked on?

How to answer
How to answer: Going into the interview, you'll want to be prepared to talk about a past project you can thoroughly talk about. Whether it's because of the people you worked with or your contribution to making it successful, showing that you have a passion for your work is key. Be sure to highlight the skills you used for the project.
Question 2

Question #2: What languages/ programs/ software are you comfortable using now?

How to answer
How to answer: BI engineering is all about using tools to analyze data. You may likely get an interview question about the tools you're comfortable using. Be sure that you can confidently speak about the languages, programs, and software you claim proficiency in.
Question 3

Question #3: How would you...?

How to answer
How to answer: It's very likely your interview for a BI engineer position will contain a puzzle or problem that you must solve. Whether it's how to handle a SQL issue or calculating performance in Tableau, you should be ready to answer it. Generally, in-depth knowledge of the tools required by the job posting will help you successfully navigate these questions.

4,386 bi engineer interview questions shared by candidates

Interview went as follows: You're guided to a room on the basement floor (where there's a futon and a futon bed along with a conference table with chairs) and given 4 papers stapled together. The first two papers have a question each. First, you have to write a query that will return the top 5 products sold by any given sales representative in the last six months, with the total sales amounts listed in descending order. Second, you are asked to identify the data issues confronting a consulting firm hired to build the a coin collector that is going to be installed at the entrance to the UN. The coin collector can take all currencies. Every time $100 USD has been collected from any country, a bell will ring and someone will come and remove the coins. For 10 minute period each day the coin collector will be off line and connected to the internet. The query to satisfy the first part of the two part question was: --query ;with cte as ( select sum(salesamt) over (partition by salesrep, product order by salesrep) as sumOfSalesAmt, salesrep, product from sales s join salesrep sr on s.sid=sr.sid join product p on p.pid=s.pid where s.qty >= 1 group by salesrep, product, salesamt ), cte1 as ( select rank() over (partition by salesrep order by sumOfSalesAmt desc) as rank, sumOfSalesAmt, salesrep, product from cte ) select * from cte1 where rank <=5; ---query alternative (other alternatives possible including cross apply) select salesrep, product, sum(salesamt) as SumSalesAmt from sales s join product p on s.pid = p.pid join salesrep sr on sr.sid = s.sid where s.qty >= 1 group by product, salesrep order by salesrep, sum(salesamt) desc;
avatar

BI Consultant

Interviewed at Brainbox Consulting

4.2★
Apr 30, 2014

Interview went as follows: You're guided to a room on the basement floor (where there's a futon and a futon bed along with a conference table with chairs) and given 4 papers stapled together. The first two papers have a question each. First, you have to write a query that will return the top 5 products sold by any given sales representative in the last six months, with the total sales amounts listed in descending order. Second, you are asked to identify the data issues confronting a consulting firm hired to build the a coin collector that is going to be installed at the entrance to the UN. The coin collector can take all currencies. Every time $100 USD has been collected from any country, a bell will ring and someone will come and remove the coins. For 10 minute period each day the coin collector will be off line and connected to the internet. The query to satisfy the first part of the two part question was: --query ;with cte as ( select sum(salesamt) over (partition by salesrep, product order by salesrep) as sumOfSalesAmt, salesrep, product from sales s join salesrep sr on s.sid=sr.sid join product p on p.pid=s.pid where s.qty >= 1 group by salesrep, product, salesamt ), cte1 as ( select rank() over (partition by salesrep order by sumOfSalesAmt desc) as rank, sumOfSalesAmt, salesrep, product from cte ) select * from cte1 where rank <=5; ---query alternative (other alternatives possible including cross apply) select salesrep, product, sum(salesamt) as SumSalesAmt from sales s join product p on s.pid = p.pid join salesrep sr on sr.sid = s.sid where s.qty >= 1 group by product, salesrep order by salesrep, sum(salesamt) desc;

Viewing 1641 - 1650 interview questions

Glassdoor has 4,386 interview questions and reports from Bi engineer interviews. Prepare for your interview. Get hired. Love your job.