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

Shutterfly, Inc. Business Intelligence Interview Guide

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


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

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

Overview

Shutterfly, 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.

Shutterfly, 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 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

<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

Shutterfly, Inc. Business Intelligence Interview Questions

<p>At Spoonflower (part of the Shutterfly family of brands) our mission is to inspire individuals to make, buy and sell unique products built around color and pattern. Our e-commerce website makes it possible for individuals to create, sell, and shop for unique fabrics, wallpaper, and home dcor. Spoonflower's global marketplace connects our customers to more than 1 million designs by independent artists from around the world.</p><p>We are seeking a highly motivated and innovative Sr. Product Specialist II (Product Manager) to join our growing Product Management team. This role focuses on enhancing our search and recommendations platform, utilizing AI and generative AI to help users find the perfect design from billions of possibilities. You'll work on everything from improving search algorithms to developing recommendation systems that deliver personalized experiences, driving conversion, supporting new business initiatives, and optimizing the platform for scale.</p><p>Key Responsibilities:</p><p>* Drive Search & Recommendations Strategy: Collaborate on the development of an AI-powered, user-centric search and recommendations platform to enhance the design discovery process for Spoonflower's customers.</p><p>* Collaborate with Stakeholders: Partner with the Head of Product, lead Search & Recommendations Product Manager, CX, engineering teams, and business stakeholders to define the vision, strategy, and roadmap. Balance customer experience, growth opportunities, risk, and speed-to-market.</p><p>* AI & Data-Driven Insights: Use AI, machine learning, and data-driven insights to develop and refine algorithms that improve search relevance, accuracy, and personalization. Set hypotheses, conduct A/B tests, and use data to optimize and continuously improve user experience.</p><p>* Customer-Centric Design Discovery: Understand customer pain points and moments of delight during the shopping journey. Identify and deliver innovative solutions that create a seamless and personalized shopping experience.</p><p>* Manage Product Roadmap: Create and maintain a comprehensive product backlog. Develop business cases, define user stories, set requirements, and create acceptance criteria for new features and enhancements.</p><p>* E-Commerce Expertise: Leverage e-commerce industry trends and marry them with Spoonflower's unique product offering. Stay current on developments in AI, search, and recommendations platforms and translate them into meaningful product features.</p><p>* Platform Optimization & Scaling: Collaborate on platform improvements aimed at scaling Spoonflower's search capabilities, managing technical trade-offs, and driving performance optimization across large-scale systems.</p><p>* Agile Product Management: Lead Agile product management processes, focusing on continuous improvement, hypothesis testing, and data-informed decision-making. Manage bug tracking, triaging, and resolution processes for efficient product iteration.</p><p>* Ability to Work East Coast Hours</p><p>Qualifications:</p><p>* Product Management Experience: 3-5 years of product management experience in an Agile environment, with a focus on search and recommendations platforms or relevant e-commerce/tech industry experience.</p><p>* Technical Knowledge: Hands-on experience with search platforms such as Solr, ElasticSearch, Algolia, or similar. Experience managing product backlogs and defining technical requirements for engineering teams.</p><p>* Analytical and Problem-Solving Skills: Proficiency in working with large-scale data, A/B testing, and using data analytics and reporting tools to make informed decisions.</p><p>* Tools Proficiency: Proficiency with Atlassian tools, including JIRA and Confluence, for managing product development in an Agile setting.</p><p>* Collaboration and Communication: Excellent interpersonal and communication skills, with a proven ability to engage with cross-functional teams, including engineering, marketing, and design.</p><p>Preferred Skills:</p><p>* AI and Data Analytics: Strong understanding of AI and machine learning, especially in search, recommendation systems, and personalization. Familiarity with generative AI applications for metadata generation and normalization.</p><p>* Platform Replatforming Experience: Experience leading or contributing to platform replatforming initiatives is highly desirable.</p><p>* E-commerce & SEO Knowledge: Familiarity with search engine optimization (SEO), search engine marketing (SEM), and social media channels and their interplay with .com platforms.</p><p>* Agile Certification:Certified Scrum Product Owner or other Agile-related certifications are a plus.</p><p>What We Offer:</p><p>* A collaborative and innovative work environment where you'll have the opportunity to define the future of design discovery using AI and cutting-edge technology.</p><p>* Competitive compensation and benefits, including health, dental, and retirement plans.</p><p>* Opportunities for personal and professional development in a growing tech-driven company.</p><p>* The chance to work on AI-driven projects with real-world impact, shaping the customer experience and enhancing creativity worldwide.</p><p>Supporting a diverse and inclusive workforce is important to Shutterfly not only because it directly reflects our value of Embracing our Differences, but also because it's the right thing to do for our business and for our people. We welcome all applicants and evaluate them based on their qualifications, without regard to age, race, creed, color, national origin, ancestry, marital status, affectional or sexual orientation, gender identity or expression, disability, nationality, sex, or other characteristic covered by law. Learn more about our commitment to Diversity, Equity, and Inclusion on our Career Site.</p><p>This position will accept applications on an ongoing basis until filled.</p><p>The compensation package for this role is based on multiple factors, such as job level, responsibilities, location, and candidate experience. The base pay ranges included below are specific to the locations listed, and may not be applicable to other locations.</p><p>California : [$104,000-148,000]</p><p>Connecticut, New York, and Rhode Island: [$104,000-135,500]</p><p>Colorado and Washington: [$104,000-125,500]</p><p>Nevada: [$97,750-135,500]</p><p>This position may be eligible for a bonus incentive, health benefits, a 401K program, and other employee perks. More details about our company benefits can be found at https://shutterflyinc.com/benefits/.</p><p>This opportunity can be remote, but candidates must reside in a state in which Shutterfly is registered to do business. This includes all US states except District of Columbia, North Dakota, Mississippi, Rhode Island, Vermont, and Wyoming.</p><p>#SFLYTechnology</p>

Shutterfly, Inc. Business Intelligence Interview Guide

Overview

Shutterfly, Inc. Business Intelligence Salary

Shutterfly, Inc. Business Intelligence Interview Process

Shutterfly, Inc. Business Intelligence Interview Questions

Shutterfly, Inc. Business Intelligence Jobs