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

Grubhub Business Intelligence Interview Guide

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


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

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

Overview

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

Grubhub Business Intelligence Interview Process

<p>Given two tables:  <code>accounts</code>, and <code>downloads</code>, find the average number of downloads for free vs paying accounts, broken down by day.</p>

<p><em>Note: You only need to consider accounts that have had at least one download before when calculating the average.</em></p>

<p><em>Note: round <code>average_downloads</code> to 2 decimal places.</em></p>

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

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

<p><code>accounts</code> table</p>

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

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

<tr>
<td><code>paying_customer</code></td>
<td>BOOLEAN</td>
</tr>
</tbody>
</table>
<p><code>downloads</code> table</p>

<table>
<thead>
<tr>
<th>column</th>
<th>type</th>
</tr>
</thead>

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

<tr>
<td><code>download_date</code></td>
<td>DATETIME</td>
</tr>

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

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

<tbody>
<tr>
<td><code>download_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>paying_customer</code></td>
<td>BOOLEAN</td>
</tr>

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


Download Facts

<p>Given a table of transactions and a table of users, write a query to determine if users tend to order more to their primary address versus other addresses.</p>

<p><em>Note: Return the percentage of transactions ordered to their home address as <code>home_address_percent</code>.</em></p>

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

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

<p><code>transactions</code> table:</p>

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

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

<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>shipping_address</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><code>users</code> table:</p>

<table>
<thead>
<tr>
<th>Columns</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>address</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Example Output:</strong></p>

<table>
<thead>
<tr>
<th><code>home_address_percent</code></th>
<th>0.76</th>
</tr>
</thead>

<tbody>
</tbody>
</table>


Order Addresses

<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

Grubhub Business Intelligence Interview Questions

<p>We're all about connecting hungry diners with our network of over 300,000 restaurants nationwide. User-friendly platforms and streamlined delivery capabilities set us apart in the world of online food ordering. Grubhub is a place where authentically fun culture meets innovation and teamwork. We believe in empowering people and opening doors for new opportunities. If you're looking for a place that values relationships, embraces diverse ideas–all while having fun together–then Grubhub is the place for you!</p><p><br></p><p><strong>The Opportunity</strong></p><p>At Grubhub, we treat Data as a Product - a valuable asset and a critical piece of our decision making process. The mission of the Grubhub Data Platform team is to democratize data and provide a cost-efficient, observable and reliable data platform that empowers and enables the teams to accelerate their ability to safely use data to generate actionable insights and product features.</p><p>We are looking for a data focused Senior Engineer to join our Data Platform team to own and provide technical expertise and leadership around core data systems ranging from data services to processing frameworks to generate and build domain based data products. You will partner with stakeholders to standardize metrics for usage across reporting, experimentation and ad-hoc analysis. This is an opportunity to use cutting edge big data capabilities of Grubhub's Data Platform and to collaborate with our partner teams to build innovative data solutions, helping Grubhub to derive value from data at a rapid pace.</p><p><br></p><p><strong>The Impact You Will Make</strong></p><ul><li>You'll write performant and concise code to meet the defined standards here at GrubHub, review the code of peers, and ensure security and scalability of the features you work on</li><li>Follow engineering best practices to deliver high quality ETL code and tests. Use CI/CD automated testing, data validations and data observability to ensure high quality data.</li><li>Work with product feature teams enabling them to create data pipelines and publish golden datasets.</li><li>Educate and promote best practices around data engineering, use of data engineering architecture and new technologies.</li><li>Coach and mentor engineers across the engineering team to build a data culture.</li></ul><p><br></p><p><strong>What You Bring to the Table</strong></p><ul><li>Bachelor's Degree in a science, programming or engineering related field</li><li>You have 5+ years of experience in engineering especially distributed systems, software engineering and data engineering.</li><li>You have experience in a cloud environment like AWS with experience running, scaling and deploying data pipelines and microservices in the cloud.</li><li>Strong computer science fundamentals in data structures, algorithms</li><li>You have experience with data serialization/table formats like Avro, Parquet, Iceberg/Hudi/Delta.</li><li>You have experience with Python or Java/ Scala and experience working on large distributed systems and frameworks like Spark/ Flink with high uptimes (4x9's uptime etc.).</li><li>You are passionate about event-driven architecture, microservices , data reliability, observability, and data privacy.</li><li>Proven experience working with rapid product development in an agile environment is preferred</li><li>You are pragmatic without compromising on software quality and standards.</li></ul><p><br></p><p><strong>Got These? Even Better</strong></p><ul><li>Experience in building data pipelines processing high volume clickstream data to support product analytics.</li><li>Familiarity with A/B testing concepts and experience in building pipelines to automate experiment results analysis</li><li>Exposure to concepts of Metric or Semantic layer, related tooling (dbt/cube) and productionized solutions.</li></ul>

<p>Grubhub is seeking a Backend Engineering Manager to join our team. You will play a key role in translating business objectives into technical plans, monitoring system performance, and driving improvements that contribute to both user satisfaction and business success. Additionally, you'll be instrumental in growing and mentoring your team, attracting top engineering talent, and ensuring that our systems remain at the forefront of industry standards.</p><p><br></p><p>This role can be based in our Chicago or NYC office working a hybrid in office 2 x per week schedule. We do not offer remote at this time.</p><p><br></p><p><strong>The Impact You Will Make</strong></p><ul><li>Manage a team of software engineers, including providing guidance on their career progression, planning, and continually challenging them to raise the bar.</li><li>Communicate with stakeholders, product owners, other technologists, and users to create software based on an understanding of business and technical priorities.</li><li>Be accountable for delivery, deployment, maintenance, monitoring the performance of the application and the platform.</li><li>Evaluate tools, technologies, and vendors for the platform along with other senior team members.</li><li>Ensure that your team maintains a high bar for quality and follows established engineering and operational guidelines.</li><li>Facilitate your team's agile operations by overseeing all sprints and manage the team backlog.</li><li>Participate in future product direction, drive technology strategy and execution.</li><li>Create a backlog of Tech Debts/ Features, suggesting areas of improvement and ensuring short-term decisions don't build into long-term problems.</li></ul><p><br></p><p><strong>What You Bring To The Table</strong></p><ul><li>Master’s or Bachelor’s Degree in Science, Programming or Engineering related field</li><li>7+ years experience building highly scalable consumer-facing applications (e-commerce preferred)</li><li>3+ years experience managing a team of Engineers and providing mentorship and career progression and planning in a formal setting</li><li>Strong proficiency and experience with Java, C#, or a similar modern object-oriented language</li><li>Strong fundamentals of computer science (object oriented programming, foundations of data structures and algorithms, etc) to guide the team in building optimal solutions</li><li>Experience architecting, designing, and developing testable, fault-tolerant, and performant software</li><li>AWS experience, or similar cloud-based offerings</li><li>Experience with eventually consistent databases (Cassandra/MongoDB/CouchDB). Experience with ElasticSearch is a big plus</li><li>Experience with Memcache/ Redis Distributed Caching mechanisms</li><li>Automated testing experience applicable for services (Junit/testing, Mockito + JMeter/Gatling.io)</li><li>Experience developing highly-available distributed systems (5x9’s uptime etc.)</li><li>Docker, or similar containerized solutions</li><li>CI / CD tools preferable Gradle, Jenkins or similar</li><li>Experience with stakeholder management with data-driven communication and prioritization</li></ul><p><br></p><p><strong>And Of Course, Perks!</strong></p><ul><li><strong>Flexible PTO. </strong>Grubhub employees enjoy a generous amount of time to recharge.</li><li><strong>Health and Wellness.</strong> Excellent medical benefits, employee network groups and paid parental leave are just a few of our programs to support your overall well-being.</li><li><strong>Competitive Pay. </strong>You’ll receive a competitive base salary with eligibility for generous incentives, bonuses, commission or RSUs (role-specific).</li><li><strong>Learning and Career Growth. </strong>Your personal and professional development is a priority at Grubhub. We empower you to be a leader and grow your career through training, coaching and mentorship opportunities.</li><li><strong>MealPerks.</strong> Get meals on us! Our employees get a weekly Grubhub credit to enjoy and support local restaurants.</li><li><strong>Fun. </strong>Every Grubhub office has an employee-led Culture Crew that connects people through fun, meaningful events and initiatives like Wellness Wednesdays, Slack competitions and virtual happy hours!</li><li><strong>Social Impact. </strong>At Grubhub we believe in giving back through programs like the Grubhub Community Relief Fund and donating $1 million to the Equal Justice Initiative in 2020. Employees are also given paid time off each year to support the causes that are important to them.</li></ul><p></p>

Grubhub Business Intelligence Interview Guide

Overview

Grubhub Business Intelligence Salary

Grubhub Business Intelligence Interview Process

Grubhub Business Intelligence Interview Questions

Grubhub Business Intelligence Jobs