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

The Zebra Business Intelligence Interview Guide

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


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

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

Overview

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

The Zebra 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 show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

<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

The Zebra Business Intelligence Interview Questions

<p>Introduction:
The Zebra, named a Best Place to Work in Austin four years running, is revolutionizing how connected consumers research and shop for insurance. We intentionally strive to build diverse teams that feel inclusive for all. Our motto is "All Stripes Welcome," and we put that into practice by valuing both traditional and non-conventional backgrounds and perspectives. Our Zeebs are passionate about learning, growing, & working together to tackle exciting problems.

We're adding a Lead Data Product Manager who will join our Data team. In this role, you will lead the development and execution of our data product strategy, ensuring that our data products meet the needs of our customers and align with our business goals. You will work closely with cross-functional teams, including data engineering, data science, product management, and business stakeholders, to deliver high-quality data products that drive business impact.

Location:
While we are open to remote work across the contingent US, we are still establishing our company to support work in all states! We are set up to support employees who want to be fully remote, in-office only or a mix of the two.

Please note: We will not support hiring based in California, Massachusetts, or New Jersey.

What You'll Do:

Strategy Development: Define and execute the data product strategy, aligning it with the company's overall business objectives and customer needs. This includes crafting a roadmap.

Product Management: Lead the end-to-end product management lifecycle for data products, from ideation and requirements gathering to development, launch, and ongoing optimization.

Collaboration: Work closely with data engineering, data science, product management, and other teams to ensure successful product development and delivery.

Customer Focus: Understand customer needs and pain points and use this knowledge to guide product development and improvements.

Data Governance: Ensure data products comply with data governance standards, privacy regulations, and best practices.

Market Analysis: Conduct market research and competitive analysis to identify opportunities for new data products and enhancements to existing products.

Performance Tracking: Define key performance indicators (KPIs) and metrics to measure the success of data products and use data-driven insights to drive continuous improvement.

Leadership: Mentor and guide junior product managers and other team members, fostering a culture of innovation and excellence.

What We're Looking For:
As we evaluate candidates across all roles, we look for folks with a strong sense of ownership, excellent communication and collaboration skills, and a dedication to continuous improvement.

7+ years of experience in product management with a focus on data products or analytics with the fin-tech or e-commerce industry

5+ years of experience with Snowflake and Looker

Strong understanding of logical and physical data modeling

Strong understanding of data engineering, data science, and analytics concepts

Proven track record of successfully launching and managing data products

Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams

Strong analytical and problem-solving abilities, with a data-driven approach to decision-making

Experience with data governance, privacy regulations, and best practices

Benefits & Perks:
Inclusive and healthy environments are crafted intentionally. All of our employees can join and participate in (or create your own!) Employee Resource Groups. Here are some other wonderful perks of working here:

Competitive Compensation & Stock Option Offering

Health, Dental, Vision & Disability Coverages

HSA offering + employer contribution

401k plan + employer match

Unlimited PTO (paid time off)+ the flexibility to enjoy it

Paid Parental Leave Program

Wellness perk ($100/month)

Pet Adoption Reimbursement ($300/year)

Learning & Development Opportunities

Join a team that truly lives their values (outside of the office. Cliche, we know… but we really mean it)

About The Zebra:
The Zebra is the nation’s leading, independent insurance comparison site. With our dynamic, real-time quote comparison tool, consumers can identify insurance companies with the coverage, service level, and pricing to suit their unique needs. Headquartered in Austin, Texas,

The Zebra has sought to bring transparency and simplicity to insurance shopping since 2012 - it's “insurance in black and white.”

We've garnered attention and investment of some of the nation’s top venture capitalists. Check out all of our awards & recognition!

Our core mantra is "All Stripes Welcome." As part of our dedication to maintaining an inclusive and diverse workforce, we provide equal employment opportunities (EEO) to all employees and applicants without regard to race, color, religion, sex, national origin, age, disability or genetics. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform core job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

#J-18808-Ljbffr</p>

The Zebra Business Intelligence Interview Guide

Overview

The Zebra Business Intelligence Salary

The Zebra Business Intelligence Interview Process

The Zebra Business Intelligence Interview Questions

The Zebra Business Intelligence Jobs