Bi Engineer Interview Questions

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?

Viewing 2851 - 2860 interview questions

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