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,384 bi engineer interview questions shared by candidates

Q.Tell me about yourself? Two SQL Questions: Shipment Table (table name - “shipments”): It contains information at a shipment level, with data such as number of items in package, package type, warehouse, country, and the customer ID. Primary key - shipment_id shipment_date shipment_id package_type warehouse_id customer_id num_items country 2020-01-01 112344 BOX WAR1 YYTGBCSDFG 1 US 2020-01-04 927612192 PADDED MAILER WAR2 HIGDSGKJAF 1 UK 2020-04-03 812618726 POLYBAG WAR9 HJFGJLFFHJK 3 IN 2020-06-01 921629712 BOX WAR13 TEEWRJGHKJKG 2 UK 2020-12-05 4982472376 OWN_BOX WAR1 KHGHJFDKLJHFF 10 US Returns table (table name - "returns"): contains information on returns by Amazon customers. Primary key – return_id return_id return_date customer_id 716219621 2017-09-26 ASKGASKAJSA 918261982 2017-03-30 UKHJDLKGSDG 984673876 2017-12-16 UPFASFJSHDV 836453323 2018-09-24 AWETUYOIUBV Q1.Find the number of customers who have had a shipment and made a return during the last 30 days? Q2.Which package type has the highest % of shipments in US in 2020?
avatar

BI Engineer

Interviewed at Amazon

3.5★
Jun 19, 2021

Q.Tell me about yourself? Two SQL Questions: Shipment Table (table name - “shipments”): It contains information at a shipment level, with data such as number of items in package, package type, warehouse, country, and the customer ID. Primary key - shipment_id shipment_date shipment_id package_type warehouse_id customer_id num_items country 2020-01-01 112344 BOX WAR1 YYTGBCSDFG 1 US 2020-01-04 927612192 PADDED MAILER WAR2 HIGDSGKJAF 1 UK 2020-04-03 812618726 POLYBAG WAR9 HJFGJLFFHJK 3 IN 2020-06-01 921629712 BOX WAR13 TEEWRJGHKJKG 2 UK 2020-12-05 4982472376 OWN_BOX WAR1 KHGHJFDKLJHFF 10 US Returns table (table name - "returns"): contains information on returns by Amazon customers. Primary key – return_id return_id return_date customer_id 716219621 2017-09-26 ASKGASKAJSA 918261982 2017-03-30 UKHJDLKGSDG 984673876 2017-12-16 UPFASFJSHDV 836453323 2018-09-24 AWETUYOIUBV Q1.Find the number of customers who have had a shipment and made a return during the last 30 days? Q2.Which package type has the highest % of shipments in US in 2020?

Based on Amazon principles: 1. Share one instance where in you worked beyond your level/work and what was the achievement in terms of metrics? 2. Share one scenario showing leadership skills where you took ownership of some task and how you executed it? SQL questions: 1. userid status Timestamp 1 in 2019-01-01 08:00:00 1 out 2019-01-01 18:00:00 2 in 2019-01-01 09:00:00 2 out 2019-01-01 17:00:00 1 in 2019-01-01 19:00:00 quest: Write a query to give the users in the building between timestamp a & b? 2. Write a query to find the first active timestamp and last inactive timestamp for following? userid status cr_time 1 active 2019-01-01 08:00:00 1 active 2019-01-01 09:00:00 1 inactive 2019-01-01 10:00:00 1 inactive 2019-01-01 11:00:00 2 active 2019-01-01 08:00:00 2 inactive 2019-01-01 12:00:00
avatar

Senior BI Engineer

Interviewed at Amazon

3.5★
Apr 5, 2019

Based on Amazon principles: 1. Share one instance where in you worked beyond your level/work and what was the achievement in terms of metrics? 2. Share one scenario showing leadership skills where you took ownership of some task and how you executed it? SQL questions: 1. userid status Timestamp 1 in 2019-01-01 08:00:00 1 out 2019-01-01 18:00:00 2 in 2019-01-01 09:00:00 2 out 2019-01-01 17:00:00 1 in 2019-01-01 19:00:00 quest: Write a query to give the users in the building between timestamp a & b? 2. Write a query to find the first active timestamp and last inactive timestamp for following? userid status cr_time 1 active 2019-01-01 08:00:00 1 active 2019-01-01 09:00:00 1 inactive 2019-01-01 10:00:00 1 inactive 2019-01-01 11:00:00 2 active 2019-01-01 08:00:00 2 inactive 2019-01-01 12:00:00

Phone interview 1 Q1)Explain bias vs variance (say it in non technical terms) Q2)What is descriptive statisticts Q3)What is spss,explain the steps involved in it Q4)Behavioural question outlining amazon's 14 principles Phone interview 2 Q1) How do you approach data Q2)How do you approach unstructured data Q3)Rate your skills in SQL Q4)Questions on joins (level easy) Q5)Write a sql query related to correlated query (level medium) Q6)Write a sql query related to the previous category implementing it with certain constraints (level hard)
avatar

Senior BI Engineer

Interviewed at Amazon

3.5★
Apr 2, 2020

Phone interview 1 Q1)Explain bias vs variance (say it in non technical terms) Q2)What is descriptive statisticts Q3)What is spss,explain the steps involved in it Q4)Behavioural question outlining amazon's 14 principles Phone interview 2 Q1) How do you approach data Q2)How do you approach unstructured data Q3)Rate your skills in SQL Q4)Questions on joins (level easy) Q5)Write a sql query related to correlated query (level medium) Q6)Write a sql query related to the previous category implementing it with certain constraints (level hard)

Viewing 2841 - 2850 interview questions

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