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

Grindr Business Intelligence Interview Guide

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


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

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

Overview

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

Grindr 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

Grindr Business Intelligence Interview Questions

<p>This is a hybrid role based in our Chicago or Bay Area Offices (San Francisco or Palo Alto) and will require you to be in the office on Tuesdays and Thursdays. <br><br><strong>What's so interesting about this role?</strong> <br><br>Come play a key role in building the next generation of the Grindr app! Working on our Android team, you'll have the opportunity to solve challenging problems, work with the latest technologies, collaborate with a kind and capable team, and contribute to a one-of-a-kind app. The Grindr team continues to innovate as the largest social media app in its category. <br><br>In this role, you will collaborate closely with the Android team, Product Managers, and our QA team to build and maintain a fast, reliable, app. We deeply value ownership, empowerment, proactivity, data-driven decisions, and user focus. You'll be an important voice in our product & software architecture decisions. <br><br><strong>What's the job? </strong> <br></p><ul> <li><strong>Working collaboratively</strong> with a brilliant cross-functional, cross-timezone team to make Grindr the best app it can be for its users </li><li>Able to work across multiple work streams and use ambiguity as an opportunity for high-level thinking. </li><li>Create innovation by guiding data-driven decisions to adopt new technologies, architectures, and workflow </li><li>Elevate your team's technical proficiency; help your team adopt new tools and ways of working </li><li>Using the<strong> latest Android technologies</strong> you will be evolving and maintaining the software architecture for current and future needs in order to develop highly innovative, consumer-facing mobile products while supporting the product roadmap </li></ul><strong>What we'll love about you</strong> <ul><li>You love taking ownership. You think beyond your team and know how to implement change across your organization. </li><li>You have at least 6 years of experience building complex Android applications with deep expertise in <strong>Kotlin and Coroutines</strong> </li> <li>You have a well-built technical experience that inspires individual contributors' creativity and innovation. </li> <li>You have experience with product leadership and technical decision-making and know how to leverage that for good judgments and tradeoffs between product and code </li><li>You have been working closely with various levels of business stakeholders, from the c-suite, VP level, and down. </li><li>You can jump into the code on a deep level but can also contribute to long-term initiatives by mentoring your team. </li><li>Strong practical knowledge of software engineering best practices and design patterns such as <strong>MVVM, Coordinator, one-way data flow, modular architecture, performance</strong> <strong>optimization</strong> & metrics </li><li>Experience with <strong>Architecture at scale </strong>and have worked with different tech stacks outside of mobile. </li></ul><strong>We'll really swoon if you have </strong> <ul> <li>You have experience working with <strong>Coroutine Flows, dependency injection frameworks</strong> </li></ul><strong>Have systematic ways to refactor legacy code and can provide effective proposals to relevant stakeholders</strong><br><br><strong>What you'll love about us</strong> <ul> <li>Mission and Impact: Grindr is building the global gayborhood in your pocket. Your role will impact the lives of millions of LGBTQ+ people around the world. Through our success, we are making a world where the lives of our community are free, equal, and just. </li><li>Family Insurance: Insurance premium coverage for health, dental, and vision for you and partial coverage for your dependents. </li><li>Retirement Savings: Generous 401K plan with 6% match and immediate vest in the U.S. </li><li>Compensation: Industry-competitive compensation and eligibility for company bonus and equity programs. </li><li>Queer-Inclusive Benefits: Industry-leading gender-affirming offerings with up to 90% cost coverage, access to Included Health, monthly stipends for HRT, and more. </li><li>Additional Benefits: Flexible vacation policy, monthly stipends for cell phone, internet, wellness, food, and commuting, breakfast/lunch provided onsite, and yearly travel & leisure stipend. </li></ul> <br><strong>About Grindr</strong> <br><br>Grindr is building the global gayborhood in your pocket. With more than 13.5 million monthly active users, Grindr has become a fundamental part of the LGBTQ+ community and is charting a path to make the world more free, equal, and just. Since 2015, Grindr for Equality has advanced safety, health, and human rights for millions of Grindr users and the global LGBTQ+ community in partnership with more than 100 community organizations in every region of the world. <br><br>Our next evolution is underway as a public company that continues to grow and build meaningful experiences for our users. From social issues to product innovations, we're setting audacious goals for our community and the business, and leveraging the latest tech stacks and a culture of engineering excellence to make it happen. At the heart of our work in this new chapter is a shared set of operating principles centered around cultivating curiosity, thinking big, setting and expediting our ambitious goals, and growing through iteration; all while keeping our users #1. <br><br>Grindr is headquartered in West Hollywood, California, with offices in the Bay Area, Chicago, and New York.With a track record of strong financial performance and plans for continued headcount growth, we're building a team of talented, passionate, and open-minded people who want to disrupt the dating app space, innovate products, and advance LGBTQ+ culture. Come be a part of this exciting journey with us. <br><br><strong>Grindr is an equal-opportunity employer</strong> <br><br>To learn more about how we handle the personal data of applicants, visit our Employee and Candidate Privacy Policy. <br><br>#LI-Hybrid <br><br>Grindr is committed to fair and equitable compensation practices. This base pay range is for the U.S. and is not applicable to locations outside of the U.S. The actual base pay is dependent upon many factors, such as training, transferable skills, work experience, business needs, location, and market demands. The base pay range is subject to change and may be modified in the future. This role will also be eligible for equity, benefits, and a company bonus program. <br><br>Chicago Base Pay Range <br><br>$171,000-$201,000 USD <br><br>Bay Area Base Pay Range <br><br>$194,500-$229,000 USD

Grindr Business Intelligence Interview Guide

Overview

Grindr Business Intelligence Salary

Grindr Business Intelligence Interview Process

Grindr Business Intelligence Interview Questions

Grindr Business Intelligence Jobs