Prepare for and practice interview questions from Border States.

Border States Interview Questions

Border States Interview Guides

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

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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

Border States Salaries by Position

Be part of a growing, successful company in an exciting and challenging field. Border States is 100% employee-owned, which means you're empowered to make decisions, find solutions and receive rewards for your hard work. This position will be located in: Nashville , TN Job Summary Supports the day-to-day operations of Branches, Account Managers, Quotations Teams, Customer Service Reps, and customers by providing product, application, and technical support and service. Regularly calls on branches along with customer accounts and makes joint sales calls with Account Managers to secure orders and perform other sales support functions for technical products and services, by providing customers field support, application support, training, and other services as required. Responsibilities Essential Functions <ul> <li>Works closely with Border States' sales and marketing staff to meet and exceed sales and gross profit objectives. </li> <li>Regularly calls-on customer accounts and makes joint sales calls with Account Managers to secure orders and perform other sales support functions for technical products and services, by providing customers field support, application support, training, and other services as required. </li> <li>Consults with customers on product and system applications. </li> <li>Supports BSE Quotations teams with timely follow-up on technical inquiries and other requests. </li> <li>Provides continuous contact and interaction with customer's engineering staff, contractors and consultants. </li> <li>Provides specific or specialized product support for branches and customers. </li> <li>Actively participates in the marketing, planning, and sale of Border States' technical products and services. </li> <li>Participates in and advises management on the implementation and success of marketing plans and strategies. </li> <li>Consistently provides responsive, quality service to meet and exceed customer expectations. </li> <li>Provides input to other sales and marketing staff on customer needs and concerns regarding pricing, products, competition, procedures, and market potential.</li> <li>Evaluates new products and makes recommendations on stock levels for new and existing products. </li> <li>Provides input to the pricing and purchasing departments on product evaluations and code descriptions, inventory management, pricing developments, and other related functions. </li> <li>Leads customer and BSE employee training on new and existing technical product lines and applications in specified product areas. </li> <li>Works with associated manufacturing agents/vendors as a liaison on all strategic issues related to planning, marketing, new products, launch and training.</li></ul> Non-essential Functions <ul> <li>Evaluates demo equipment and makes suggestions for new products in specified product areas. </li> <li>Inputs TCCM cost savings documentation that is relevant to the assigned customer base. </li> <li>Ensures existing demos are in functional condition. </li> <li>Performs product updates and new product launches for branches and customers as required. </li> <li>Attends and assists with sales meetings, trade shows and training programs as needed.</li> <li>Performs other duties as assigned by supervisor or designate.</li></ul> Qualifications <ul> <li>Minimum of a four-year technical or engineering degree preferred or the equivalent in work experience. </li> <li>Prefer the knowledge and technical competence in understanding electrical and hi-tech industrial products and applications including industrial automation software and hardware. </li> <li>Minimum of four-years of prior customer service, marketing, quotation or sales experience preferred. </li> <li>Minimum of three-years of prior electrical distribution and quotations experience preferred with a comprehensive knowledge of BSE product lines and applications, alternate product substitutes, and supplier pricing policies. </li> <li>Ability to read, write and speak in English preferred. </li> <li>Prefer strong working knowledge of PC for Windows, Microsoft Office (Excel, Word, Access and PowerPoint), Internet, Email and SAP software.</li></ul> Skills and Abilities <ul> <li>Excellent interpersonal, written and verbal communication and customer service skills are preferred with the ability to effectively plan and organize. </li> <li>Excellent customer service skills include being competent, accurate, responsive and engaged.</li></ul> Physical Requirements Frequency at which you would carry/lift in a typical day: Occasionally 0 - 33% Frequently 34 - 66% Continuously: 67 - 100% <ul><li>Lift from Waist:<ul><li><li>10 to 25 lbs. - Not at all</li><li>26 to 50 lbs. - Not at all</li><li>51 to 75 lbs. - Not at all</li><li>75 to 100 lbs. - Not at all</li><li>100+ lbs. - Not at all</li></ul></li><li>Lift from Floor:<ul><li><li>10 to 25 lbs. - Frequently</li><li>26 to 50 lbs. - Occasionally</li><li>51 to 75 lbs. - Not at all</li><li>75 to 100 lbs. - Not at all</li><li>100+ lbs. - Not at all</li></ul></li><li>Carried for Distance:<ul><li><li>10 to 25 lbs. - Not at all</li><li>26 to 50 lbs. - Not at all</li><li>51 to 75 lbs. - Not at all</li><li>75 to 100 lbs. - Not at all</li><li>100+ lbs. - Not at all</li></ul></li></ul> Physical Activity Frequency at which you would do the following in a typical day: <ul> <li>Sitting (a continuous period of being seated) - Frequently</li> <li>Standing (for sustained periods of time) - Frequently</li> <li>Walking (moving about on foot to accomplish tasks) - Frequently</li> <li>Bending/stooping (downward and forward) - Occasionally</li> <li>Crawling (moving about on hands and knees or hands and feet) - Not at all</li> <li>Climbing/Walking Stairs (ascending or descending) - Frequently</li> <li>Reaching (extending arms in any direction) - Frequently</li> <li>Crouching/squatting (bending the body downward and forward by bending leg and spine) - Occasionally</li> <li>Kneeling (bending legs at knee to come to rest on knee(s)) - Occasionally</li> <li>Balancing (maintaining body equilibrium to prevent falling) - Occasionally</li> <li>Repetitive motion (substantial movement (motions) or the wrists, hands, and/or fingers) - Continuously</li> <li>Pivoting (movement in any direction with one foot, keeping the other in contact with the floor) - Occasionally</li> <li>Pushing/Pulling (using upper extremities to press against or draw or tug) - Occasionally</li> <li>Grasping (Applying pressure to an object with the fingers and palm) - Continuously</li> <li>Fingering (picking, pinching, typing; working with primarily fingers and not whole hand) - Continuously</li> <li>Talking (expressing or exchanging ideas by means of the spoken word) - Frequently</li> <li>Driving (the control and operation of a motor vehicle) - Frequently</li> <li>Desk work (work usually performed at a desk) - Frequently</li> <li>Use of a computer - Continuously</li> <li>Use of a telephone - Frequently</li> <li>Hearing (Perceiving the nature of sounds at normal speaking levels) - Continuously</li> <li>Exposure (to adverse weather & temperature conditions) - Occasionally</li> <li>Travel (travel needed to perform job duties) - Frequently</li></ul> Additional Information This job description is a summary of the job duties and responsibilities and is not intended to cover all possible job duties and is subject to change at the employer's discretion. Employees must be able to perform the essential job duties and satisfy job requirements either with or without a reasonable accommodation. Our History Border States is a leader in the electrical supply distribution industry with over 100 locations in 24 states. Our employee-owners are second to none in delivering top-notch customer service and in demonstrating extra-ordinary people skills. We are one of the largest independent electrical distributors in the United States providing products and services to the construction, industrial and utility industries. Border States has a competitive benefit package and is a 100 percent employee-owned company. Employee-ownership is a significant part of our culture and our success stems from the dedication of our employee-owners. We practice open-book management and our employee-owners are empowered with clearly defined levels of authority to be innovative and decisive, allowing us to respond quickly to the needs of customers. Employee-owners understand their roles in the success of the company and care about customers' needs, which drives our focus on adding value to everything we do. We recognize that not all customers are the same and each has specific requirements. Our employee-owners understand these diverse needs and have the commitment, resourcefulness and flexibility to outperform all others. Values As a Border States employee-owner, you're responsible for living our mission, service philosophy and service standards. Mission Border States provides value to our customers by delivering innovative product and supply chain solutions. Service Philosophy We earn customer loyalty and confidence by caring about their needs and adding value to everything we do. Service Standards Border States employee-owners are competent, accurate, responsive, and engaged . Your career Join an experienced team at one of the largest electrical distributors in the United States. What are you waiting for? Border States has a competitive benefits package which includes but is not limited to: Health, Dental and Vision Benefits Accident, Critical Illness, Hospital Indemnity FSA & HSA Employee Stock Ownership Plan (ESOP) Disability Benefits 401(k) Retirement Plan Life Insurance Employee Assistance Program Paid Holidays Paid Volunteer Time Personal Leave time and more! Border States provides bonuses to their employee-owners upon the achievement of branch and company goals. Equal Opportunity For All It's not just the law. It's something we've believed in since our founding. We value the diversity of all of our employee-owners and will always be an equal opportunity employer. Drug Free/Smoke Free workplace

Border States Interview Questions

Border States Interview Guides

Border States Interview Questions

Border States Salaries by Position

Border States Opening Jobs