Prepare for and practice interview questions from Pet Supplies Plus.

Pet Supplies Plus Interview Questions

Pet Supplies Plus Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</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>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Pet Supplies Plus Salaries by Position

Overview: Pet Supplies Plus is seeking a Marketing Data Analyst, who will be responsible for providing analytical support to a fast-paced marketing department. This role will be responsible for analyzing information from multiple source systems, finding insights, and designing data stories to explain those insights to a wide variety of audiences. Experience in SQL is a must, and the ability to extract and cleanse information from multiple system types is valued. Responsibilities/Qualifications: Pet Supplies Plus is a brick and mortar retailer with a strong ecommerce and omni-channel emphasis. Experience in retail & digital marketing measures and techniques is a plus. The ideal candidate can dive deep into the data, determine the story it tells and present that story to marketing and senior leadership. Self-direction and motivation are also key characteristics in a qualified candidate. The Marketing Data Analyst will: <ul> <li>Create advanced reporting and analysis for campaigns and projects through Microsoft SQL, Excel and PowerBI. </li><li>Write complex queries for marketing campaigns and analysis of those campaign results. </li><li>Prepare high quality presentations and dashboards for management and marketing teams, highlighting campaign performance and tracking toward business goals. </li><li>Apply various analytic methods to discover and interpret information from multiple data sources . </li><li>Strategize new ways to grow our marketing database and optimize campaign performance response, deliverability, open rate, click rate, conversion rate, ROI, etc. </li><li>Analyze market segments and determine which segment is more responsive, which campaign is most successful, and be able to communicate this from a statistical perspective. </li></ul> PAWsome Marketing Data Analyst candidates will have: <ul> <li>A minimum of two years of experience in an analyst role. </li><li>Experience with SQL including writing queries and creating tables. </li><li>Experience extracting data from multiple data sources i.e. database, and external sources/links. </li><li>Experience with visualization tools, ideally Excel and PowerBI. </li><li>Proven track record of designing and producing analysis projects at the campaign, product, or portfolio level. </li><li>Proficiency in Microsoft Office (Excel, Word, Outlook, PowerPoint). </li><li>Knowledge of digital tools such as Google Analytics and Google Adwords. </li><li>Understanding of marketing concepts like segmentation, personas and incremental response. </li><li>Experience in Python or R is preferred. </li></ul> About Company: Pet Supplies Plus is focused on making it easier to get better products for your pet. With over 700 locations in 42 states, the stores have a streamlined design making it easy to navigate a wide assortment of natural foods, hard goods and pet services. Friendly, knowledgeable staff get to know each pet and their owner by name and provide playful store experiences to remind them just how fun it is to own a pet. Pet Supplies Plus stores are large enough to house an incredible variety of food and equipment, yet small enough to still feel neighborly. Pet Supplies Plus is ranked No. 20 overall in Entrepreneur Magazine's 2022 Franchise 500 list and is the Top Full-Service Pet Supplies Franchise for its exceptional performance in areas including financial strength and stability, growth rate and system size. For more information, please visit www.petsuppliesplus.com. EOE STATEMENT We provide equal employment opportunities to all applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, the company complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment.

Pet Supplies Plus Interview Questions

Pet Supplies Plus Interview Guides

Pet Supplies Plus Interview Questions

Pet Supplies Plus Salaries by Position

Pet Supplies Plus Opening Jobs