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

Tubi Business Intelligence Interview Guide

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


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

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

Overview

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

Tubi 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>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

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

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

<p><code>transactions</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>user_id</code></td>
<td>INTEGER</td>
</tr>

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

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</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>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Tubi Business Intelligence Interview Questions

Tubi is a global entertainment company and the most watched free TV and movie streaming service in the U.S. and Canada. Dedicated to providing all people access to all the world's stories, Tubi offers the largest collection of on-demand content, including over 250,000 premium movies and TV episodes and over 300 exclusive originals. With a passionate fanbase and over 80 million monthly active viewers, the company is committed to putting viewers first with free, accessible entertainment for all.<br><br><strong>About the Role:</strong><br><br>With such a large catalog of content, data and machine learning are fundamental to Tubi's success, and Tubi's Data Platform is the cornerstone of all data and ML use. At Tubi, you will join a stellar team of engineers with a passion for solving the most challenging problems using cutting-edge technology. This is a hard-core software engineering role with a data focus. In this role, you will be expected to be a hands-on engineer as you and your team builds out real-time systems to handle data at massive scale. You will enable machine learning engineers to iterate and experiment faster than ever before. You will help data scientists take ideas to production in days or weeks, not months or years. And you will build tools to enable data analysis and modeling for even the least tech-savvy colleagues. In short, you will enable Tubi to be truly data-driven.<br><br><strong>Responsibilities:</strong> <br><ul><li>Handle the collection and processing of large scale raw data.</li><li>Build low latency and low maintenance data infrastructure that powers the whole company</li><li>Develop and enhance our analytics pipeline by creating new tools and solutions to facilitate intuitive data consumption for stakeholders</li><li>Construct and improve infrastructure for data extraction, transformation, loading and cleaning from diverse sources using API's, SQL and AWS technologies.</li><li>Improve data quality by building tools, processes and pipelines to enforce, check and manage data quality at a large scale.</li><li>Ensure our data platform is available, secure, and reliable</li></ul><br><strong>Your Background:</strong><br><ul><li>5+ years of experience building scalable batch and streaming data pipelines (Spark or Flink)</li><li>Experience using Spark cluster-computing framework & Kubernetes (or similar containerization technologies)</li><li>Strong experience developing Bid Data applications using Java/Scala, Spark, and Kafka</li><li>Strong knowledge of Streaming, distributed databases, and cloud storage (e.g., AWS - S3).</li></ul><br>Pursuant to state and local pay disclosure requirements, the pay range for this role, with final offer amount dependent on education, skills, experience, and location is listed annually below. This role is also eligible for an annual discretionary bonus, long-term incentive plan, and various benefits including medical/dental/vision, insurance, a 401(k) plan, paid time off, and other benefits in accordance with applicable plan documents.<br><br><strong>California, New York City, Westchester County, NY, and Seattle, WA Compensation</strong><br><br>$164,000 to $234,000 / year + Bonus + Long-Term Incentive Plan + Benefits<br><br><strong>Colorado and Washington (excluding Seattle, WA) Compensation</strong><br><br>$147,000 to $210,000 / year + Bonus + Long-Term Incentive Plan + Benefits<br><br>#LI-MQ1<br><br>Tubi is a division of Fox Corporation, and the FOX Employee Benefits summarized here, covers the majority of all US employee benefits. The following distinctions below outline the differences between the Tubi and FOX benefits:<br><ul><li>For US-based non-exempt Tubi employees, the FOX Employee Benefits summary accurately captures the Vacation and Sick Time.</li><li>For all salaried/exempt employees, in lieu of the FOX Vacation policy, Tubi offers a Flexible Time off Policy to manage all personal matters.</li><li>For all full-time, regular employees, in lieu of FOX Paid Parental Leave, Tubi offers a generous Parental Leave Program, which allows parents twelve (12) weeks of paid bonding leave within the first year of the birth, adoption, surrogacy, or foster placement of a child. This time is 100% paid through a combination of any applicable state, city, and federal leaves and wage-replacement programs in addition to contributions made by Tubi.</li><li>For all full-time, regular employees, Tubi offers a monthly wellness reimbursement.</li></ul><br>Tubi is proud to be an equal opportunity employer and considers qualified applicants without regard to race, color, religion, sex, national origin, ancestry, age, genetic information, sexual orientation, gender identity, marital or family status, veteran status, medical condition, or disability. Pursuant to the San Francisco Fair Chance Ordinance, we will consider employment for qualified applicants with arrest and conviction records. We are an E-Verify company.

Join Tubi (www.tubi.tv), Fox Corporation's premium ad-supported video-on-demand (AVOD) streaming service leading the charge in making entertainment accessible to all. With over 200,000 movies and television shows, including a growing library of Tubi Originals, 200+ local and live news and sports channels, and 455 entertainment partners featuring content from every major Hollywood studio, Tubi gives entertainment fans an easy way to discover new content that is available completely free. Tubi's library has something for every member of our diverse audience, and we're committed to building a workforce that reflects that diversity. We're looking for great people who are creative thinkers, self-motivators, and impact-makers looking to help shape the future of streaming.<br><br><strong>About the Role:</strong><br><br>We seek a Senior Data Scientist to play a pivotal role in advancing Tubi's Experimentation platform. You will contribute to the company's data-driven experimentation process, supporting continuous improvements to the user experience and the organization's strategies. You will be involved in designing, analyzing, and interpreting our testing calendar, which includes A/B, holdout, MMT, and switchback tests. You will advance our technical infrastructure to improve test velocity and statistical rigor. Finally, you will provide insights and recommendations to inform data-driven decisions across all departments.<br><strong>Responsibilities:</strong><br><ul><li>Plan and execute experimentation strategies, fostering a culture of innovation</li><li>Enhance statistical rigor, metric alignment, transparency, and effectiveness of Tubi's experiment frameworks</li><li>Research advanced features and methods to add to the experimentation pipeline, aiming to reduce test duration, increase sensitivity, accurately determine sample size, etc</li><li>Define and select experiment proxy metrics that align with the company's North Star objectives</li><li>Provide expert evaluation of experiment design, including pre-test planning, in-flight monitoring, and post-experiment analysis for graduation decisions</li><li>Collaborate with cross-functional teams to define and execute domain-specific and global holdout tests, measuring the individual and collective impact of the company's initiatives</li></ul><strong>Your Background:</strong><br><ul><li>Strong technical experience in a data science role, with emphasis on A/B testing and experimentation in a technology-focused organization</li><li>Deep knowledge of experimental design, statistical methods, and best practices in A/B testing and causal inference</li><li>Advanced proficiency in programming and data manipulation using SQL, Python, and Spark</li><li>Strong analytical skills with proficiency in statistical analysis and the ability to derive insights from large datasets</li><li>Excellent communication skills with the ability to present complex findings in a structured and transparent manner to non-technical stakeholders</li></ul><strong>Bonus:</strong><br><ul><li>Video streaming industry experience is a plus.</li></ul><br>Pursuant to state and local pay disclosure requirements, the pay range for this role, with final offer amount dependent on education, skills, experience, and location is listed annually below. This role is also eligible for an annual discretionary bonus, long-term incentive plan, and various benefits including medical/dental/vision, insurance, a 401(k) plan, paid time off, and other benefits in accordance with applicable plan documents.<br><br><strong>California, New York City, Westchester County, NY, and Seattle, WA Compensation</strong><br><br>$134,000 to $191,000 / year + Bonus + Long-Term Incentive Plan + Benefits<br><br><strong>Colorado and Washington (excluding Seattle, WA) Compensation</strong><br><br>$120,000 to $172,000 / year + Bonus + Long-Term Incentive Plan + Benefits<br><br>#LI-MQ1<br><br>Tubi is a division of Fox Corporation, and the FOX Employee Benefits summarized here, covers the majority of all US employee benefits. The following distinctions below outline the differences between the Tubi and FOX benefits:<br><ul><li>For US-based non-exempt Tubi employees, the FOX Employee Benefits summary accurately captures the Vacation and Sick Time.</li><li>For all salaried/exempt employees, in lieu of the FOX Vacation policy, Tubi offers a Flexible Time off Policy to manage all personal matters.</li><li>For all full-time, regular employees, in lieu of FOX Paid Parental Leave, Tubi offers a generous Parental Leave Program, which allows parents twelve (12) weeks of paid bonding leave within the first year of the birth, adoption, surrogacy, or foster placement of a child. This time is 100% paid through a combination of any applicable state, city, and federal leaves and wage-replacement programs in addition to contributions made by Tubi.</li><li>For all full-time, regular employees, Tubi offers a monthly wellness reimbursement.</li></ul><br>Tubi is proud to be an equal opportunity employer and considers qualified applicants without regard to race, color, religion, sex, national origin, ancestry, age, genetic information, sexual orientation, gender identity, marital or family status, veteran status, medical condition, or disability. Pursuant to the San Francisco Fair Chance Ordinance, we will consider employment for qualified applicants with arrest and conviction records. We are an E-Verify company.

Tubi Business Intelligence Interview Guide

Overview

Tubi Business Intelligence Salary

Tubi Business Intelligence Interview Process

Tubi Business Intelligence Interview Questions

Tubi Business Intelligence Jobs