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–14 of 14 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 - AmazonEasyBusiness Intelligence EngineerDefend an Experiment Decision and Its Incremental Impact
This question tests your ability to articulate a data-driven decision-making process, specifically focusing on the nuance of non-obvious outcomes and the business impact of choosing not to launch a feature.
Behavioral & LeadershipTechnical ScreenBehavioralA/B TestingStakeholder Management - AmazonHardBusiness Intelligence EngineerDesign a One-Page Warehouse Inbound Dashboard
Design an executive warehouse inbound dashboard with throughput, dock-to-stock time, aged backlog, capacity, and quality metrics.
Analytics & ExperimentationTechnical Screen - 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 - AmazonEasyBusiness Intelligence EngineerVisualize Trip Duration, Fees, and Survey Outcomes
This question tests the ability to design an analytical framework for identifying patterns in user satisfaction relative to trip costs and duration, while accounting for potential data quality issues like response bias.
Analytics & ExperimentationTechnical ScreenData VisualizationAnalyticsBias Detection - TeslaEasyBusiness Intelligence EngineerDesign an End-to-End Customer Delivery Experience Dashboard
Design an end-to-end delivery experience dashboard connecting executive KPIs to stage-level operational diagnostics, with clear metric definitions, data freshness SLAs, and handling of late-arriving events.
Analytics & ExperimentationTechnical Screenbusiness-intelligencedashboard-designmetric-definition
Amazon
Tesla