The Lithia Motors, Inc. Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Lithia Motors, Inc. Business Intelligence Interview Guide

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


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

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

Overview

Lithia Motors, Inc. 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.

Lithia Motors, Inc. 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 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

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

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

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

<p><strong><code>players</code></strong> table</p>

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

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

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

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

Lithia Motors, Inc. Business Intelligence Interview Questions

<p>Locations: Lithia Innovation Hub, Tigard, OR 97223; Lithia Motors Home Office, Medford, OR 97501</p><p>Time Type: Full Time</p><p>Posted On: Posted 3 Days Ago</p><p>Job Requisition ID: R75680</p><h3><b>Lithia & Driveway | Staff Data Engineer</b></h3><p>The Staff Data Engineer is responsible for leading the creation and delivery of high-quality software within a team of cross-discipline engineers. The Staff Software Engineer is responsible for writing code, creating tests, mentoring engineers, and championing best practices in software development on their team. They are able to lead their teams to create high-quality software and further grow their team’s agile development practices. Staff Software Engineers are role models to engineers within the larger organization, providing technical leadership that influences our practice of software development.</p><p>Location: Portland, OR preferred; open to remote</p><p>Compensation: $90,000-200,000 annually. Typically, initial compensation falls in the mid-range and will be determined by factors including experience, skills, training, certifications, and education.</p><h3><b>Responsibilities</b></h3><ul><li>Lead team planning and scoping of work as part of an agile software development team</li><li>Consistently deliver high-quality code</li><li>Lead standard setting in code-review practices and collaborate with other engineers to drive business outcomes</li><li>Steer the creation of research spikes to explore new technologies and potential solutions for upcoming challenges</li><li>Maintain a strong internal network of engineers outside the core team to integrate related components and play a significant role in developing organizational standards</li><li>Participate as part of a Tier-3 on-call rotation to support team-built software</li></ul><h3><b>Skills and Qualifications</b></h3><ul><li>6-8+ years delivering high-scale, high-performance web applications</li><li>Storied experience in platforms running with a leading cloud provider, preferably Azure</li><li>Mastery with container-driven development environments</li></ul><h3><b>We Offer Best in Class Industry Benefits:</b></h3><ul><li>Competitive pay</li><li>Medical, Dental, and Vision Plans</li><li>Paid Holidays & PTO</li><li>Short and Long-Term Disability</li><li>Paid Life Insurance</li><li>401(k) Retirement Plan</li><li>Employee Stock Purchase Plan</li><li>Lithia Learning Center</li><li>Vehicle Purchase Discounts</li><li>Wellness Programs</li></ul><p>High school graduate or equivalent, 18 years or older required. Acceptable driving record and a valid driver's license in your state of residence necessary for select roles. We are a drug-free workplace. We are committed to equal employment opportunity (regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status). We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.</p><h3>About Us</h3><p>Driveway is a forward-thinking, tech-embracing, customer-centric brand excited about imparting knowledge to its users, sharing enjoyment over a customers’ interaction, and happy to meet them wherever they’re at – literally – without a second thought. We’re looking for fellow thinkers and doers to join our rapidly growing team.</p><p>Driveway is bringing car ownership into the digital age. We are passionate about transforming how people buy and sell cars, inspiring a new generation of car owners to own the road on their terms and on their turf.</p>
#J-18808-Ljbffr

Lithia Motors, Inc. Business Intelligence Interview Guide

Overview

Lithia Motors, Inc. Business Intelligence Salary

Lithia Motors, Inc. Business Intelligence Interview Process

Lithia Motors, Inc. Business Intelligence Interview Questions

Lithia Motors, Inc. Business Intelligence Jobs