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

Discount tire Business Intelligence Interview Guide

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


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

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

Overview

Discount tire 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.

Discount tire 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>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

Discount tire Business Intelligence Interview Questions

<p>Overview: Here at Discount Tire, we celebrate the spirit of our people with extraordinary pride and enthusiasm. As America’s largest independent tire retailer, specializing in tires & wheels, we have over 1,100 store locations and continue to grow every year. Our consistent growth over the last 60 years, the loyalty of our customers and passion of our people makes Discount Tire a great place to work. The Senior Business Analyst plays a vital part of the Distribution and Logistics organization. This person serves as a key role in the development of logistics strategy, optimizing transportation networks and driving improved service levels to our stores and customers. This role will be responsible for developing new measures for performance, identifying opportunities for improvement, leading cost savings initiatives and procurement events across various transportation & delivery categories, that includes but not limited to: truckload, less than truckload, parcel, ocean freight, drayage, and parcel.Our ideal candidate exhibits a can-do attitude and approaches their work with persistence and determination. Candidates will be expected to demonstrate excellence in their respective fields, to solve complex problems and to strive for perfection within a fast-paced environment.Essential Duties and Responsibilities:Support strategic planning, opportunity assessment, and implementation of new capabilities for a rapidly evolving logistics network including first mile, middle mile, and final mileOversees the cost of transportation; evaluating cost per truckload, cube per truckload, and cost per mile in support of overall financial goals; ensuring transportation assets are fully utilized to reduce freight costs whenever possibleBuild moderately complex models that use simulation techniques to test different scenarios and optimize supply chain performance by evaluating trade-offs between cost, service levels and efficiencyAnalyze historic data, real-time information and market trends to develop “what-if” scenarios within the models to assess the impact of changes in our supply chain network; monitor model performance and refine based on feedback and changing business needsDesign dashboards using advanced data analytics to evaluate logistics performance and advance speed in decision making; manipulate and visualize data and communicate with stakeholdersAct as a subject matter expert and solution owner to enhance technologies that support our supply chain team: our WMS, routing software, rate benchmarking tool, port logistics platform and network modeling software’s Support negotiations for transportation and logistics services delivering value at the service levels required by Discount TireMotivate people to give their best efforts by goal setting, coaching, and communicating performance expectations, offering recognition and holding people accountable for results. Develop financial and operations metrics and reporting Anticipate challenges and disruptions to transportation flow and design mitigation strategiesAnalyze the financial impact of proposed logistics changes, such as routing, pre-paid to collect conversion, shipping modes, product volumes or lane mixes, or carriersDrive site specific requirements at cross docks, warehouses, and ports to support the most efficient logistics operations possibleBuild and manage benchmarking metrics for Discount Tire’s practices both internally and externally against best-in-class operationsOther responsibilities as assignedQualifications:5+ years relevant experience with automotive or retail supply chain, logistics, and transportation, preferably in a high-volume environment2+ years direct leadership or supervisory experience is a plusStrong knowledge of multi-modal logistics pricing models (truck, ocean, drayage, parcel)Excellent communication and interpersonal skills with success in working across organizations at all levelsAbility to manage and prioritize multiple projects, effective project planning in terms of resources, strategies, cost, and time with ability to meet project timelinesExcellent problem-solving and critical thinking skills (Six-Sigma, LEAN)Strong Data Analytical skills including SQL, Python, R, Excel, LLamasoft, Optilogic or MS AccessExperience with TMS and WMS software applicationsExperience in process implementation and required internal controls Educational Requirements:Bachelor's degree in Industrial Engineering, Supply Chain, Logistics or related equivalent experience is required.LEAN or Six Sigma Certifications a plusDiscount Tire provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local law.#LI-Hybrid#LI-KB1</p>

Discount tire Business Intelligence Interview Guide

Overview

Discount tire Business Intelligence Salary

Discount tire Business Intelligence Interview Process

Discount tire Business Intelligence Interview Questions

Discount tire Business Intelligence Jobs