The Opendoor Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Opendoor Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Opendoor? The Opendoor Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Opendoor Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Opendoor.</li>
<li>Practice real Opendoor Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Opendoor Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Opendoor? The Opendoor Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Opendoor Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Opendoor.
- Practice real Opendoor Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Opendoor Business Intelligence interview.
        

Overview

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Opendoor Business Intelligence Interview Process

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the total salary of slacking employees.

Slacking Employees Salaries

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><strong><code>players</code></strong> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

<p>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

Opendoor Business Intelligence Interview Questions

Location:  Hybrid in San Francisco Office - 3 days per week on site
Team:  Pricing Services
Key Skills:  Golang, SQL, TypeScript/Javascript, React
Project Overview:
The Pricing Services team is responsible for developing and maintaining the systems that support Opendoor’s pricing engine. The team builds backend services in  Go  that implement pricing algorithms and expose APIs for both internal and external consumers. These services process and analyze large volumes of data stored in  PostgreSQL  databases. The team also develops internal web applications using  React  and  TypeScript  for pricing operations, analytics, and workflow management.
Development is organized around cross-functional projects that require coordination with engineering, data science, and product management. Work involves end-to-end ownership, from system design and implementation to code review and operational support.
All systems are deployed on  Linux  and rely on a stack that includes Go, PostgreSQL, TypeScript, React, Kafka for streaming, Redis for caching, BPMN for workflow, and gRPC for service communication.
The ideal candidate will bring strong experience in Golang, SQL, and TypeScript/Javascript, as well as proficiency with React.
Responsibilities:
Implement and maintain backend pricing algorithms and services in Go
Write and optimize SQL queries for large data sets in PostgreSQL
Build and update React-based UIs using TypeScript
Integrate pricing services with Opendoor’s main platform
Participate in code reviews, technical discussions, and troubleshooting
Requirements:
1+ years fullstack software development (production experience)
1+ years Golang (backend/API development)
1+ years SQL (query optimization, database design)
1+ years TypeScript (application logic, React components)
1+ years React (UI development)
Nice to Have:
Kafka (streaming/event-driven systems)
BPMN (workflow/process automation)
gRPC (microservices communication)
Environment:
Go, PostgreSQL, TypeScript, React, Kafka, Redis, BPMN, gRPC, Linux
About Opendoor Founded in 2014, Opendoor’s mission is to power life’s progress one move at a time. We believe the traditional real estate process is broken and our goal is simple: build a digital, end-to-end customer experience that makes buying and selling a home simple and certain.
To learn how we are reinventing the Real Estate industry check out  our website .
Hear about our culture directly from team members by visiting  The Muse .
Discover what we are building for our customers by reading our  b   log .
Opendoor Values Openness We believe that being open about who we are and what we do allows us to be better. Individuals seeking employment at Opendoor are considered without regard to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, sexual orientation, gender identity or other protected status under all applicable laws, regulations, and ordinances. We collect, use, and disclose applicant personal information as described in our personnel privacy policies. To learn more, you can find the policy details for  California residents here  and for  Canada residents here .
We’re committed to Diversity, Equity, Inclusion, and Belonging  Opendoor is dedicated to creating an inclusive and collaborative culture. We value the diverse strengths, perspectives, and backgrounds of all our employees, and believe in empowering our teams to do their best work through teamwork and building a sense of belonging and trust. Our four employee-led Opendoor Employee Resource Groups amplify diverse voices and promote collaboration and inclusion. Our focus is on attracting and retaining exceptional talent, and we believe in empowering our employees to continuously innovate and strive for 1% improvement every day. You can find more information on our  Career Page.
We are committed to assisting members of the military community in utilizing their skills at Opendoor. U.S. candidates are able to review your military job classification at  MyNextMove.org  and apply for positions that align with your expertise.
At Opendoor, we are committed to providing reasonable accommodations throughout our recruitment processes for candidates with disabilities, pregnancy, religious beliefs, or other reasons protected by applicable laws. If you require assistance or a reasonable accommodation, please contact us at TAops-accomodations@opendoor.com.

#J-18808-Ljbffr

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

Opendoor Business Intelligence Interview Guide

Overview

Opendoor Business Intelligence Interview Process

Opendoor Business Intelligence Interview Questions

Opendoor Business Intelligence Jobs