Prepare for and practice interview questions from School Specialty, Inc..

School Specialty, Inc. Interview Questions

School Specialty, Inc. Interview Guides

<p>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.</p>

<p>What factors could have biased this result, and what would you look into?</p>


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

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?

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</code> table</p>

<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

<p>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.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

School Specialty, Inc. Salaries by Position

<p>Description

People Passion Purpose

Everything School Specialty offers is designed for one purpose – to help students succeed. We believe every student can flourish in an environment where they feel safe and inspired to explore and grow.

We’re Determined To Positively Impact The Future, One Child At a Time. We Need To Talk If You Share Our Passion

Transforming more than classrooms.

Benefits

School Specialty offers Medical, Dental, & Vision plans (Effective Day 1), Wellness programs, Health Savings Accounts, Flexible Spending Accounts, 401 (k), Unlimited PTO for Salaried Exempt employees, which can also be used for dedicated volunteer hours, Education Reimbursement, Paid Holidays, Fall & Winter Flexible Hours, Employee Discounts and much more!

Product Experience Business Analyst I

We are looking for an experienced Product Experience Business Analyst to join the Program Management team to support our large, enterprise level, strategic projects. Our project Business Analysts work with a variety of Subject Matter Experts, Program Managers, Architects, Business Analysts, Implementation Partners, and Executive Leadership to understand, articulate, document, and champion the needs of your business stakeholders.

The Project Business Analyst I will support ongoing Product Experience projects and will operate as the main business analyst for those projects. This role will work with various business members to elicit, analyze, and document business requirements, and with the architects and system leads to facilitate the development of solution concepts. A candidate for this position must have direct experience as a Business Analyst on agile projects: gathering requirements and writing user stories.

The base salary range for this role is $49K-$65K annually

This is a remote position, ideal candidate can be located anywhere in the US**

Summary Of Primary Responsibilities

Operating as the Business Analyst on multiple enterprise-level initiatives / projects, responsible for participating in the full software development life cycle including:
Analyzing and documenting business requirements and detailed acceptance criteria, including challenging current business processes
Must be able to meet sprint deadlines and call out risks
Working with solution architects and/or vendors to identify, evaluate, and recommend potential solution options
Working with solution architects and/or vendors to analyze the feasibility and cost benefits of potential solutions
Participating in technical design
Supporting the business during UAT, including the writing of test scripts, facilitating business UAT discussions, and triaging and logging business-reported bugs
Participating in user documentation processes and business training sessions
Monitoring Post Go Live business reported issues
Level 2 application support and troubleshooting, approximately 10%
Will / may partner with other business analysts on enterprise technology projects
Travel when approved
Minimum Experience Requirements

BA Degree
3 – 5 years’ experience working as a business analyst on a delivery team responsible for deploying agile software solutions, ensuring business needs were met
Agile project management experience; must be personally experienced with eliciting detailed requirements, and grooming user stories
Ability to understand the connections between a master data management application and subscribing systems
Prior experience working in Jira or a similar project-tracking software
Prior experience working in Confluence or a similar wiki page creation software
Prior experience in Visio or a similar diagramming software
Demonstrated leadership skills and both written and verbal communication skills
Ability to interact with all levels of an organization
Ability to adapt to fluid situations, quick self-learner, and the ability to problem solve and manage through complexity
Knowledge of standard Microsoft applications – Word, Excel, PowerPoint
Ability to work in a fast-paced, team-oriented environment, at times with little supervision

Preferred Knowledge and Skills

Strong organizational, time-management, and analytical skills
Skilled in designing and implementing processes
Strong presentation and facilitation skills; ability to handle multiple tasks concurrently
Excellent verbal, written, leadership, and management skills; must be comfortable speaking in front of large, senior leadership groups
Tech savvy and passionate about building products; track record of using qualitative and quantitative data to prioritize and drive decision-making
Previous master data management experience preferred
Experience capturing requirements in a standard tool or documentation methodology
Experience building workflows and process flows
Excellent communication skills, including written, verbal, and listening
Tailors communication approach to specific situations and audiences
Ability to leverage, influence, navigate, and build partnerships across business teams
Ability to build and nurture relationships with cross-functional team members
Understands standard project management methodologies and requirements
Ability to plan, estimate, organize, and monitor work
Understands company, business segment, and/or project strategy, goals, and objectives

Disclaimers

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

School Specialty, LLC. is a Drug Free Workplace. All applicants are subject to a drug screen and background check as a condition of employment.
We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state or local protected class.
If you need reasonable accommodation for any part of the employment process, please contact us by email at Opportunities@SchoolSpecialty.com and let us know the nature of your request and your contact information.

Job Grade: 11

#J-18808-Ljbffr</p>

<p>People Passion Purpose
Everything School Specialty offers is designed for one purpose – to help students succeed. We believe every student can flourish in an environment where they feel safe and inspired to explore and grow.

We’re determined to positively impact the future, one child at a time. We need to talk if you share our passion:

Transforming more than classrooms.

Benefits

School Specialty offers Medical, Dental, & Vision plans (Effective Day 1), Wellness programs, Health Savings Accounts, Flexible Spending Accounts, 401 (k), Unlimited PTO for Salaried Exempt employees, which can also be used for dedicated volunteer hours, Education Reimbursement, Paid Holidays, Fall & Winter Flexible Hours, Employee Discounts and much more!

Product Experience Business Analyst I

We are looking for an experienced Product Experience Business Analyst to join the Program Management team to support our large, enterprise level, strategic projects. Our project Business Analysts work with a variety of Subject Matter Experts, Program Managers, Architects, Business Analysts, Implementation Partners, and Executive Leadership to understand, articulate, document, and champion the needs of your business stakeholders.

The Project Business Analyst I will support ongoing Product Experience and Salesforce projects and will operate as the main business analyst for those projects. This role will work with various business members to elicit, analyze, and document business requirements, and with the architects and system leads to facilitate the development of solution concepts. A candidate for this position must have direct experience as a Business Analyst on agile projects: gathering requirements and writing user stories.

The base salary range for this role is $49K-$65K annually
**This is a remote position, ideal candidate can be located anywhere in the US**

Summary of Primary Responsibilities Operating as the Business Analyst on multiple enterprise-level initiatives / projects, responsible for participating in the full software development life cycle including: Analyzing and documenting business requirements and detailed acceptance criteria, including challenging current business processes Must be able to meet sprint deadlines and call out risks

Working with solution architects and/or vendors to identify, evaluate, and recommend potential solution options
Working with solution architects and/or vendors to analyze the feasibility and cost benefits of potential solutions
Participating in technical design
Supporting the business during UAT, including the writing of test scripts, facilitating business UAT discussions, and triaging and logging business-reported bugs
Participating in user documentation processes and business training sessions
Monitoring Post Go Live business reported issues

Level 2 application support and troubleshooting, approximately 10%
Will / may partner with other business analysts on enterprise technology projects
Travel when approved
Minimum Experience Requirements BA Degree
3 – 5 years’ experience working as a business analyst on a delivery team responsible for deploying agile software solutions, ensuring business needs were met
Agile project management experience; must be personally experienced with eliciting detailed requirements, and grooming user stories
Ability to understand the connections between a master data management application and subscribing systems
Prior experience working in Salesforce, in particular Service Cloud
Prior experience working in Jira or a similar project-tracking software
Prior experience working in Confluence or a similar wiki page creation software
Prior experience in Visio or a similar diagramming software
Demonstrated leadership skills and both written and verbal communication skills
Ability to interact with all levels of an organization
Ability to adapt to fluid situations, quick self-learner, and the ability to problem solve and manage through complexity
Knowledge of standard Microsoft applications – Word, Excel, PowerPoint
Ability to work in a fast-paced, team-oriented environment, at times with little supervision
Preferred Knowledge and Skills Strong organizational, time-management, and analytical skills
Skilled in designing and implementing processes
Strong presentation and facilitation skills; ability to handle multiple tasks concurrently
Excellent verbal, written, leadership, and management skills; must be comfortable speaking in front of large, senior leadership groups
Tech savvy and passionate about building products; track record of using qualitative and quantitative data to prioritize and drive decision-making
Previous master data management experience preferred
Experience capturing requirements in a standard tool or documentation methodology
Experience building workflows and process flows
Excellent communication skills, including written, verbal, and listening
Tailors communication approach to specific situations and audiences
Ability to leverage, influence, navigate, and build partnerships across business teams
Ability to build and nurture relationships with cross-functional team members
Understands standard project management methodologies and requirements
Ability to plan, estimate, organize, and monitor work
Understands company, business segment, and/or project strategy, goals, and objectives

Disclaimers
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed. School Specialty, LLC. is a Drug Free Workplace. All applicants are subject to a drug screen and background check as a condition of employment.
We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state or local protected class.
If you need reasonable accommodation for any part of the employment process, please contact us by email at Opportunities@SchoolSpecialty.com and let us know the nature of your request and your contact information.
#LI-Remote
Job Grade: 11
#J-18808-Ljbffr</p>

School Specialty, Inc. Interview Questions

School Specialty, Inc. Interview Guides

School Specialty, Inc. Interview Questions

School Specialty, Inc. Salaries by Position

School Specialty, Inc. Opening Jobs