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

Opendoor Business Intelligence Salary

<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.

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Opendoor Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

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

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

<p><code>bank_transactions</code> table</p>

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

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

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

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

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

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

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

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

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

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

<p>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Opendoor Business Intelligence Interview Questions

Location:Hybrid roles require role responsibilities to be performed in the office for a portion of the week, with an option to work remotely. You must be based within a 50-mile commuting distance of Atlanta, Dallas/Ft. Worth, or Detroit. Check out our office locationshere.What You’ll Need5+ years of professional software development experience5+ years of leading design or architecture with a focus on design patterns and reliability of new and existing systems5+ years of programming with at least one software programming languageExperience as a mentor, tech lead, or manager of an engineering team.About the RoleThe Field Tooling and Safety team is a foundational team within Opendoor focused on building the tools that our team and trade partners use to manage homes. This is a unique opportunity to drive impact across the business from pre-acquisition of a home to listing that home post-renovation.The Field Tooling and Safety team is looking for a senior software engineer to help build solutions that make it possible to better know our homes. This role will involve collaborating across functions to design, build, and release new systems that drive learnings to our business so we can better serve our customers. This full-stack role involves managing and developing essential front-end and back-end services for both our team and other teams, covering both web and mobile applications.What You’ll DoWork with product and design to evaluate, solution, and implement new features, driving the full development lifecycle from idea to release across the frontend and backend.Mentor and coach other engineers, sharing best practices around coding and architecture that support a business at an early growth stage.Take part in code reviews and architectural discussions as you work with other software engineers, UX designers, and product managers.Continuously discover, evaluate, and implement new technologies to improve development velocity and iteration speed.Bonus points if you haveExpertise in the following: Javascript/TypeScript with React on the frontend, and one backend language (we use Ruby and Go).Demonstrated experience in delivering solutions that drive excellence for operationally intensive organizationsCompensation:Our compensation reflects the cost of labor across several<br/><br/>U.S. geographic markets, and we pay differently based on those defined markets. Base pay is one part of our total compensation package and is determined within a range. This provides the opportunity to progress as you grow and develop within a role. The U.S. pay range for this position is $136,000-$192,000annually. Pay within this range varies by work location and may also depend on your qualifications, job-related knowledge, skills, and experience. Your recruiter can share more about the specific salary range for the job location during the hiring process. We also offer a comprehensive package of benefits including paid time off, 12 paid holidays per year, medical/dental/vision insurance, basic life insurance, and 401(k) to eligible employees.#LI-Hybrid#LI-JH1About OpendoorFounded 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 blog.Opendoor Values OpennessWe 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 BelongingOpendoor 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.

<h3><strong>Location: </strong> </h3><p>Hybrid roles require role responsibilities to be performed in the office for a portion of the week, with an option to work remotely. You must be based within a 50-mile commuting distance of Atlanta, Dallas/Ft. Worth, or Detroit. Check out our office locations <a >here </a>. </p><h3>What You’ll Need </h3><ul><li>5+ years of professional software development experience </li><li>5+ years of leading design or architecture with a focus on design patterns and reliability of new and existing systems </li><li>5+ years of programming with at least one software programming language </li><li>Experience as a mentor, tech lead, or manager of an engineering team. </li> </ul><h3>About the Role </h3><p>The Field Tooling and Safety team is a foundational team within Opendoor focused on building the tools that our team and trade partners use to manage homes. This is a unique opportunity to drive impact across the business from pre-acquisition of a home to listing that home post-renovation. </p><p>The Field Tooling and Safety team is looking for a senior software engineer to help build solutions that make it possible to better know our homes. This role will involve collaborating across functions to design, build, and release new systems that drive learnings to our business so we can better serve our customers. This full-stack role involves managing and developing essential front-end and back-end services for both our team and other teams, covering both web and mobile applications. </p><h3>What You’ll Do </h3><ul><li>Work with product and design to evaluate, solution, and implement new features, driving the full development lifecycle from idea to release across the frontend and backend. </li><li>Mentor and coach other engineers, sharing best practices around coding and architecture that support a business at an early growth stage. </li><li>Take part in code reviews and architectural discussions as you work with other software engineers, UX designers, and product managers. </li><li>Continuously discover, evaluate, and implement new technologies to improve development velocity and iteration speed. </li> </ul><h3>Bonus points if you have </h3><ul><li>Expertise in the following: Javascript/TypeScript with React on the frontend, and one backend language (we use Ruby and Go). </li><li>Demonstrated experience in delivering solutions that drive excellence for operationally intensive organizations. </li> </ul><h3>Compensation: </h3><p>Our compensation reflects the cost of labor across several U.S. geographic markets, and we pay differently based on those defined markets. Base pay is one part of our total compensation package and is determined within a range. This provides the opportunity to progress as you grow and develop within a role. The U.S. pay range for this position is <strong>$136,000-$192,000 </strong> annually. Pay within this range varies by work location and may also depend on your qualifications, job-related knowledge, skills, and experience. Your recruiter can share more about the specific salary range for the job location during the hiring process. We also offer a comprehensive package of benefits including paid time off, 12 paid holidays per year, medical/dental/vision insurance, basic life insurance, and 401(k) to eligible employees. </p>#J-18808-Ljbffr

<p>Location:
Hybrid roles require role responsibilities to be performed in the office for a portion of the week, with an option to work remotely. You must be based within a 50-mile commuting distance of Atlanta, Dallas/Ft. Worth, or Detroit. Check out our office locations here .

What You’ll Need

5+ years of professional software development experience

5+ years of leading design or architecture with a focus on design patterns and reliability of new and existing systems

5+ years of programming with at least one software programming language

Experience as a mentor, tech lead, or manager of an engineering team.

About the Role
The Field Tooling and Safety team is a foundational team within Opendoor focused on building the tools that our team and trade partners use to manage homes. This is a unique opportunity to drive impact across the business from pre-acquisition of a home to listing that home post-renovation.

The Field Tooling and Safety team is looking for a senior software engineer to help build solutions that make it possible to better know our homes. This role will involve collaborating across functions to design, build, and release new systems that drive learnings to our business so we can better serve our customers. This full-stack role involves managing and developing essential front-end and back-end services for both our team and other teams, covering both web and mobile applications.

What You’ll Do

Work with product and design to evaluate, solution, and implement new features, driving the full development lifecycle from idea to release across the frontend and backend.

Mentor and coach other engineers, sharing best practices around coding and architecture that support a business at an early growth stage.

Take part in code reviews and architectural discussions as you work with other software engineers, UX designers, and product managers.

Continuously discover, evaluate, and implement new technologies to improve development velocity and iteration speed.

Bonus points if you have

Expertise in the following: Javascript/TypeScript with React on the frontend, and one backend language (we use Ruby and Go).

Demonstrated experience in delivering solutions that drive excellence for operationally intensive organizations.

Compensation:
Our compensation reflects the cost of labor across several U.S. geographic markets, and we pay differently based on those defined markets. Base pay is one part of our total compensation package and is determined within a range. This provides the opportunity to progress as you grow and develop within a role. The U.S. pay range for this position is $136,000-$192,000 annually. Pay within this range varies by work location and may also depend on your qualifications, job-related knowledge, skills, and experience. Your recruiter can share more about the specific salary range for the job location during the hiring process. We also offer a comprehensive package of benefits including paid time off, 12 paid holidays per year, medical/dental/vision insurance, basic life insurance, and 401(k) to eligible employees.

#J-18808-Ljbffr</p>

Opendoor Business Intelligence Interview Guide

Overview

Opendoor Business Intelligence Salary

Opendoor Business Intelligence Interview Process

Opendoor Business Intelligence Interview Questions

Opendoor Business Intelligence Jobs