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

Builders Firstsource Business Intelligence Interview Guide

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


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

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

Overview

Builders Firstsource 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.

Builders Firstsource 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

Builders Firstsource Business Intelligence Interview Questions

<p>We are Builders FirstSource, America's largest supplier of building materials, value-added components and building services to the professional market. You'll feel proud of the work you do here every day to transform the future of home building and help make the dream of home ownership more achievable. At BFS, we believe building a successful career is not solely defined by a degree. Your experience, skills, and passion are just as important, if not more so. As such, we are committed to creating a diverse and inclusive workplace that welcomes candidates from all backgrounds and experience levels. <br> <br><strong>PURPOSE</strong> <br><br>Aids in creating and distributing pricing reports, data, and relevant information as you support Sales/Operations and other members of the Pricing Team. Participates in maintaining price and cost information. <br><br><strong>ESSENTIAL DUTIES AND RESPONSIBILITIES</strong><br><br></p><ul><li>Execute system data maintenance required to uphold accurate pricing, controls, cost, and user permissions. </li><li>Generate and distribute routine reports, providing insights and action items, for both Pricing and Sales/Ops team members. </li><li>Communicate recommended action(s) for data outliers and exceptions to Pricing Team and other internal Teams based on metrics established by Management. </li><li>Present system, reporting, and process enhancement recommendations to Manager to address Pricing and/or Sales/Ops Teams' needs. </li><li>Create Standard Operating Procedures (SOPs) and process documentation on common Pricing Team activities and reports. </li><li>Provide backup support and assistance to other Pricing Team members on various tasks such as reporting, data validations, and Retail pricing processes. </li><li>Support ad-hoc initiatives and analysis for both Pricing Team and Sales/Operation. </li></ul><strong>SUPERVISORY RESPONSIBILITIES</strong> <br><br>This job has no supervisory responsibilities. <br><br><strong>MINIMUM REQUIREMENTS</strong> <br><br>To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. <ul> <li>Bachelor's degree, preferably in Finance/Accounting, IT, Engineering. </li><li>Minimum of 2 years of related work experience, or equivalent combination of education and experience required. </li><li>Proficiency managing large datasets in Microsoft Excel. </li><li>3 years of experience in analytical field - preference given to disciplines focused on Sales, Margin, or Cost Analysis </li><li>Intermediate Microsoft Office Skills (Excel - vlookups, pivot tables, etc) </li><li>Excellent communication skills - verbal and written </li></ul><strong>COMPETENCIES</strong><ul><li>Customer Minded - Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service; Responds to requests for service and assistance; Meets commitments. </li><li>Organized - Prioritizes and plans work activities; Uses time efficiently. Ability to proactively anticipate needs. </li><li>Attentive - Focuses on solving concerns, not blaming; Keenly aware of details; Listens to others without interrupting; Keeps emotions under control; Remains open to others' ideas and tries new things. </li><li>Great Communicator - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; responds well to questions. Writes clearly and informatively; Edits work for spelling and grammar; Varies writing style to meet needs and audience. </li><li>Team minded - Balances team and individual responsibilities; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Able to build morale and group commitments to goals and objectives; Supports everyone's efforts to succeed. </li><li>Analytical - Leverages data to solve problems; Looks for abstract ways to approach challenges; Strives to understand the root cause; Possesses a growth mindset. </li><li>Ethical - Treats people with respect; Keeps commitments; inspires the trust of others; Works with integrity and ethics; Upholds organizational values. </li><li>Inclusive - Shows respect and sensitivity for cultural differences; promotes a harassment-free environment. </li><li>Agile - History of thriving, navigating, and executing in fast-paced and ambiguous environments. </li></ul><strong>WORK ENVIRONMENT / PHYSICAL ACTIVITY</strong> <br><br>The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. <ul><li>Work is in an office setting and generally sedentary with physical effort associated with using a computer, but may involve walking or standing for brief periods of time. </li><li>May be required to occasionally lift, carry, push, pull, or otherwise move objects up to 25 pounds. </li><li>Working after hours may be required to maintain accurate pricing in OnLine. </li><li>Requires approximately 10% travel and may require some travel to attend market specific engagements. </li></ul> <br><br>#LI-JG1 <br><br>#LI-hybrid <br> <br>Successful, innovative, and fulfilling careers are built here, and your professional development is a high priority. We invest in your future through the latest training, tools, and technologies. Highly collaborative, we work together to solve problems and find better ways to continually grow our business and careers every day. You'll be empowered to try new things, gain new experiences, and build a career with unlimited horizons. The scale and depth of resources that being the #1 building materials distributor in the nation provides a variety of opportunities for you to explore - all in a friendly, people-first environment. Join us to be more, do more, and build more, together at BFS. <br> <br>In addition to the base wage listed, this position is also eligible to earn an annual bonus subject to changes in plan design and documents and in accordance with applicable law. Eligibility and the amount of the bonus varies based on overall company success, thresholds met and other terms and conditions of the Company's active bonus policy for the respective year. <br> <br>At Builders FirstSource, we offer competitive, affordable benefits designed to make life better for you and the people you love. Our goal is simple - provide great plans that help you and your family to live happier, healthier and more secure lives. To view all our benefit offerings click here www.bldrbenefits.com. <br> <br>Builders FirstSource is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status or status as an individual with a disability. <br> <br>In compliance with the ADA Amendments Act (ADAAA), if you have a disability and would like to request an accommodation in order to apply for a position with Builders FirstSource, please call (214) 765-3990 or email: ADA.Accommodation@bldr.com. Please do not send resumes to this email address - it is intended only to be used to request an accommodation in submitting an application for a job opening. <br> <br>https://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm <br> <br>Pay Transparency Provision - English/Spanish

Builders Firstsource Business Intelligence Interview Guide

Overview

Builders Firstsource Business Intelligence Salary

Builders Firstsource Business Intelligence Interview Process

Builders Firstsource Business Intelligence Interview Questions

Builders Firstsource Business Intelligence Jobs