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

Redfin Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Redfin? The Redfin 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 Redfin Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Redfin.</li>
<li>Practice real Redfin 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 Redfin Business Intelligence interview.</p>


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

- Know what skills are necessary for Redfin Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Redfin.
- Practice real Redfin 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 Redfin Business Intelligence interview.
        

Overview

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

Redfin 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>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

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

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

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

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

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</code> table</p>

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

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

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

<tr>
<td><code>team</code></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><code>manager</code></td>
<td>VARCHAR</td>
</tr>

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


Manager Team Sizes

<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

Redfin Business Intelligence Interview Questions

<b>This position is a hybrid role requiring employees to work from our location in Atlanta, GA 2 days per week and remote all other days. </b><br><br>As a Senior Product Manager I, your job is to ship high-quality software that helps drive user acquisition to Rent.com and ApartmentGuide.com. You'll work with SEO managers to identify opportunities, designers to design new features; engineers to ship them, and analysts to measure their impact. In addition to shipping concrete software projects, you'll help determine a longer-term roadmap for the software we build and broadly impact the Consumer Product Management team. <br><br><b>What You Will Be Doing</b><br><ul><li>Identify new opportunities to grow the organic search channel. Strategies may focus on acquiring new users, creating more value for existing users, and improving retention</li><li>Define a clear roadmap for the features you own with minimal supervision.</li><li>Design compelling, intuitive software experiences that make it easier for renters to accomplish their goals. You'll draw wireframes and feature flows to communicate how software should behave, and often work with a designer to turn them into high-quality mock-ups.</li><li>Initiate and conduct user research - interviews, surveys, or user tests - to understand how well the features you own are working, and what needs to be improved.</li><li>Conduct competitive research to understand how others solve similar problems or build similar features. You'll draw on inspiration from other sites and apps for how to build great software.</li><li>Independently write requirements to outline how new features will work and instructions for developers on building them.</li><li>Rally and serve as a leader for cross-functional teams of engineers, designers, marketers, and analysts to ship world-class products.</li><li>Measure and track key features or business metrics.</li><li>Communicate clearly and directly about your features and projects with your core engineering team as well as the broader organization. You excel in crafting concise messages about what matters most. Your immediate team can always turn to you for answers on requirements and documents you have written as well as consult you on the issues that arise</li><li>You can respond to customer feedback about the features you own</li><li>Provide guidance and mentorship to newer and more junior members of the team as well as be a resource for your peers.</li></ul><br><br><b>Who You Are</b><br><ul><li>Advanced technical understanding of web technologies</li><li>Design acumen</li><li>Analytical skills (ie working with a spreadsheet)</li><li>Project management skills</li><li>Ability to identify stakeholders and influence decisions</li><li>Ability to scope a project and identify potential blockers</li><li>Ability to wireframe a project or problem</li></ul><br><br><b>Redfin is an equal opportunity employer committed to hiring a diverse workforce.</b><br><br>A diverse, inclusive culture is vital to Redfin's mission of making real estate better for people from all walks of life. We're proud that Redfin is a place where different points of view and backgrounds are encouraged and respected. We constantly strive to build a company that reflects the world around us, based on our conviction that pursuing and developing talent of all types is the right way for a business to thrive over the long haul.<br><br>Redfin provides equal employment opportunities to all employees and applicants for employment and prohibit discrimination based on race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, and any other characteristic protected by applicable federal, state or local law. If you need accommodation in the application or recruitment process because of a disability or special need, please contact recruitingteam@redfin.com<br><br>Redfin encourages individuals with criminal record histories to apply for employment and considers such individuals for employment consistent with the requirements of any applicable fair chance acts, including but not limited to the California, San Francisco and Los Angeles County Fair Chance Acts. Philadelphia applicants can access a copy of Philadelphia Fair Criminal Records Screening Standards ordinance poster here.<br><br>Redfin accepts applications on an ongoing basis.

Redfin Business Intelligence Interview Guide

Overview

Redfin Business Intelligence Salary

Redfin Business Intelligence Interview Process

Redfin Business Intelligence Interview Questions

Redfin Business Intelligence Jobs