practice a little every day, paws crossed ♡
Business Intelligence Engineer Interview Questions
Practice 9403 coding, system design and machine learning questions from 546 companies, sorted by role, topic and interview round. Every question has step-by-step hints, a code runner that supports 8 languages and an AI mentor; members also get the full solution walkthrough.
- 9403
- Questions
- 546
- Companies
- 11
- Topics
- 8
- Languages
Showing 1–10 of 10 results
- AmazonMediumBusiness Intelligence EngineerAnalyze Seller Compliance and Customer Purchase Patterns
This question evaluates a candidate's ability to manipulate and analyze temporal and categorical datasets, covering competencies such as event sequencing, set-based filtering, and cross-table aggregation in SQL/Python.
Data Manipulation (SQL/Python)Onsite - AmazonMediumBusiness Intelligence EngineerCalculate Rolling 7-Day Sum of Answers by Device
This question evaluates proficiency in time-series aggregation and group-wise metric computation on structured data, specifically calculating rolling seven-day sums of answers per device, and assesses familiarity with data manipulation using SQL or Python.
Data Manipulation (SQL/Python)Onsite - AmazonMediumBusiness Intelligence EngineerCompute First Order Proportions by Day and Category
This question evaluates a candidate's ability to perform event-level data manipulation and customer-level deduplication using SQL or Python, focusing on calculating the proportion of orders that represent a customer's first purchase by day and category.
Data Manipulation (SQL/Python)Onsite - AmazonMediumBusiness Intelligence EngineerCount Customers Buying Both 'Kindle' and 'Alexa'
This question evaluates proficiency in relational data manipulation and set-based reasoning, assessing SQL competency such as joins, aggregation, and identifying distinct customers who purchased multiple specified products.
Data Manipulation (SQL/Python)Onsite - AmazonMediumBusiness Intelligence EngineerFind Top Three Books by City in Recent Months
This question evaluates proficiency in time-windowed aggregation, group-level ranking and window-function usage on relational datasets, emphasizing handling of recent date ranges and top-N selection.
Data Manipulation (SQL/Python)Onsite - AmazonMediumBusiness Intelligence EngineerIdentify Most Popular First-Watched Movie in Viewing History
This question evaluates proficiency in data manipulation and temporal event analysis, assessing competency in identifying per-user earliest views and aggregating frequencies using SQL or Python.
Data Manipulation (SQL/Python)Onsite - AmazonMediumBusiness Intelligence EngineerIdentify Top-Buying Customers Daily with SQL Query
This question evaluates a candidate's competency in SQL data manipulation, including aggregation over calendar dates, grouping by customer, and handling ties when determining top buyers.
Data Manipulation (SQL/Python)Onsite - AmazonMediumBusiness Intelligence EngineerIdentify Unique Unordered City Pairs in Flight Log
This question evaluates competency in data manipulation, deduplication of symmetric relationships, and handling unordered pairs within relational or tabular datasets using SQL or Python/Pandas.
Data Manipulation (SQL/Python)Onsite - AmazonMediumBusiness Intelligence EngineerIllustrate SQL Join Results with Duplicate Keys
This question evaluates understanding of SQL join semantics and the effect of duplicate key values on result cardinality, assessing competency in relational data manipulation and reasoning about result sets.
Data Manipulation (SQL/Python)Onsite - AmazonEasyBusiness Intelligence EngineerReason About Composite Join Keys and Predicate Placement
This question tests your understanding of composite join keys, the critical semantic difference between filtering in the `ON` versus `WHERE` clause during joins, and techniques to prevent row fan-out.
Data Manipulation (SQL/Python)Technical Screensqljoinsdata-manipulation
Amazon