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

Skechers Business Intelligence Interview Guide

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


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

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

Overview

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

Skechers 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>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

<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

Skechers Business Intelligence Interview Questions

<h3>International Pricing Analyst</h3><p>Apply locations Manhattan Beach, CA time type Full time posted on Posted 2 Days Ago job requisition id JR110021 This position is responsible for analyzing international sales on a customer level and driving performance through new and existing processes, reporting, and campaigns. Large volume customer account price requests, margin analysis, order audits, price surveys and feedback are a key function for this role.</p><b><u>ESSENTIAL JOB RESULTS-</u></b><ul><li>Find opportunities to grow strategic accounts through sales processes and capabilities</li><li>Create wholesale customer email campaigns to support sales strategy</li><li>Formulate customer level price requests for high volume wholesale accounts</li><li>Determine reasons customer orders are not placed and use findings to improve future offers</li><li>Manage ad hoc requests related to customer margin, terms, and allowances</li><li>Ensure net margins are maintained for all business units and summarized for upper management</li><li>Compile and manipulate large amounts of data from multiple systems then analyze and presents findings in a clear format</li><li>Create Alteryx workflows for complex analysis and automation of routine tasks</li><li>Analyze complex business problems and assess how automated systems can be implemented to solve them</li><li>Create reports and pull data for ad hoc analysis from MicroStrategy/Incorta business intelligence tool and various systems</li><li>Other duties as assigned</li></ul><b><u>JOB REQUIREMENTS-</u></b><ul><li>Ability to work on-site</li><li>Familiarity with wholesale customer data, terms, and sales processes</li><li>Experience creating customer-facing email campaigns</li><li>Detail-oriented, accurate, and highly analytical</li><li>Experience working directly with senior leadership on high visibility deliverables</li><li>Ability to manage many projects with changing priorities</li><li>Excellent written and verbal communication skills</li><li>Ability to analyze complex models in Excel and Alteryx</li><li>Experience developing capabilities in Microstrategy and Incorta</li></ul><b><u>EDUCATION & EXPERIENCE-</u></b><ul><li>Bachelor's degree or equivalent experience required.</li><li>2+ years experience as an analyst in a sales or finance organization</li></ul><p>$75K-90K - ANNUALLY</p><p><b>About Skechers</b><br/>Skechers (NYSE: SKX), a global, Fortune 500 brand develops and markets a diverse range of lifestyle and performance footwear, apparel, and accessories. Developing comfort technologies is the foundation of all we do – delivering stylish, innovative, and quality products. Serving over 180 countries and territories, Skechers connects customers to products through department and specialty stores, e-commerce and digital stores, and through our more than 5,200 company-and third-party-owned retail locations. Headquartered in Southern California, with offices and distribution centers around the globe, Skechers has spent 30 years helping people of all ages look and feel good.</p><p><b>Equal Employment Opportunity</b><br/>Skechers is committed to providing a safe, inclusive, and respectful work environment. Skechers provides equal employment opportunities for all employees and applicants for employment without regard race, color, religion, gender, gender identification and expression, national origin, marital status, age, disability, genetic information, military status, sexual orientation, or any other protected characteristic established by local, state or federal law.</p><p><b>Reasonable Accommodation</b><br/>Applicants for employment who require a reasonable accommodation to apply for a job should request appropriate accommodation by emailing benefits@skechers.com. To perform this job successfully, an individual must be able to perform each job responsibility satisfactorily. The skills, abilities and physical demands described are representative of those duties that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities, who are otherwise qualified for the job position, to perform the essential functions.</p>
#J-18808-Ljbffr

Skechers Business Intelligence Interview Guide

Overview

Skechers Business Intelligence Salary

Skechers Business Intelligence Interview Process

Skechers Business Intelligence Interview Questions

Skechers Business Intelligence Jobs