Prepare for and practice interview questions from Shaw Industries.

Shaw Industries Interview Questions

Shaw Industries Interview Guides

<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

<p>Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.</p>

<p>The company has been consistently growing new users in the city from January to March.</p>

<p>What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?</p>


<p>What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?</p>

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Shaw Industries Salaries by Position

<p>Job Title Commercial Business Intelligence Analyst Position Overview This position will be a part of the Commercial Business Intelligence team, which resides within the Commercial Strategy and Insights group. The BI Analyst will be a leader in supporting the Commercial Sales and Marketing organization by building, maintaining, and improving key platforms for insight development and decision making. They will be a steward of Commercial Business data, delivering high quality insights for both operational use and strategic development. Responsibilities: Collaborate, consult, and lead discussions with business leaders, analysts, and engineers to collect business requirements and design effective solutions Organize and transform data to be used in analysis and visualization, utilizing SQL (within the Databricks platform) for data source development/ETL Develop clear and concise visual insights that lead to optimal decision making and business improvements, utilizing Tableau for visualization Ensure insights are accessible, repeatable, explainable, and actionable Deliver compelling communications about business insights with mid-level and senior leadership Drive projects with minimal supervision, effectively managing project scope, prioritization, and timelines Be a valuable partner to our business stakeholders, providing a positive user experience Organize and document data assets and visualizations, continuously knowledge sharing with team members Continuously learn about data visualization, cloud data engineering, and advanced analytics concepts Communicate with others at appropriate times in order to seek solutions to problems and/or clarify task requirements Partner with Shaws Enterprise IT organization to receive support and ensure data governance standards are met Be able to travel locally among Shaw facilities to train on the systems and information by presenting in front of groups of sales or marketing; or to travel to conferences Be able to work with confidential data and safeguard as appropriate Qualifications: 2 or 4 Year Degree in Business or Computer Science or equivalent program Experience developing insights with Data Visualization tools such as Tableau or PowerBI Experience coding in SQL both for querying and creating database objects Ability to creatively analyze data and find trends utilizing Excel, Tableau, and SQL Ability to contribute and lead cross functional teams to develop collaborative solutions Ability to effectively communicate to a variety of audiences with various technical backgrounds Strong problem-solving, critical thinking skills with willingness to challenge the status quo Strong learning agility and adaptive skills to new software and methodologies Strong business acumen with financial and sales literacy Flexible work environment with remote days Preferred Qualifications: Knowledge of Shaw Commercial Division business processes Experience with Databricks cloud-based platform Familiarity with Salesforce.com for sales quoting/opportunities/customer management, etc. Familiarity with Shaws order management system Experience with Data Science tools such as R or Python Experience with Data Lakes such as Azure, AWS, or Hadoop Required Competencies: Innovate: Create novel solutions with measurable value for existing and potential customers (internal and external); experiment with new ways to solve work problems and seize opportunities that result in unique and differentiated solutions. Adapt and Change: Maintain effectiveness during change, adjusting to new responsibilities or environment by exploring the benefits, trying new approaches, and collaborating with others to make the change successful. Influence Others: Create and execute strategies that commitment to of ideas and commitment to actions that support specific work outcomes. Build Trusting Relationships: Establish effective relationships with key stakeholders, customers and partners; interacting with others in a way that promotes openness and trust and gives them confidence in ones intentions. Demonstrate Customer Orientation: Craft and implement service practices that meet customer and organization needs, placing a high priority on the internal or external customers perspective when making decisions and taking action. Shaw benefits include: Medical, dental, and vision insurance Life insurance and disability coverage Tuition reimbursement Employee assistance program Health savings account Paid Time Off Parental Leave 401K and Retirement Plans Product discounts for employees Adoption assistance Shaw Family Health Center (Dalton, GA, and Cartersville, GA, locations) Work Shift 8 Hr non-rotating shift, Hrs fall to in punch day, Observed Calendar, shift starts AM Shaw Industries is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, gender identity, religion, sexual orientation, national origin, disability, genetic information, pregnancy, protected veteran status, or any other protected characteristic as outlined by federal, state, or local laws.</p>

Shaw Industries Interview Questions

Shaw Industries Interview Guides

Shaw Industries Interview Questions

Shaw Industries Salaries by Position

Shaw Industries Opening Jobs