The Kehe Distributors Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Kehe Distributors Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Kehe Distributors? The Kehe Distributors Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Kehe Distributors Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Kehe Distributors.</li>
<li>Practice real Kehe Distributors Business Intelligence interview questions.</li>
</ul>
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 Kehe Distributors Business Intelligence interview.


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

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

Overview

Kehe Distributors Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Kehe Distributors Business Intelligence Interview Process

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.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

<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>
Output:

<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

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</code> table

<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>
<code>managers</code> table

<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>
Output:

<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

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</code> table

<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>
<code>users</code> table

<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>
 
Output:

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

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Kehe Distributors Business Intelligence Interview Questions

Why Work for KeHE?: <ul><li>Full-time <li>Pay Range: $67,700.00/Yr. - $99,220.00/Yr. <li>Shift Days: , Shift Time: <li>Benefits on Day 1 <ul><li>Health/Rx <li>Dental <li>Vision <li>Flexible and health spending accounts (FSA/HSA) <li>Supplemental life insurance <li>401(k) <li>Paid time off <li>Paid sick time <li>Short term & long term disability coverage (STD/LTD) <li>Employee stock ownership (ESOP) <li>Holiday pay for company designated holidays</ul> Overview: Good people, working with good people, for our common good. Sound good? KeHE-a natural, organic, specialty and fresh food distributor-is all about "good" and is growing, so there's never been a more exciting time to join our team. If you're enthusiastic about working in an environment with a people-first culture and an organization committed to good living, good food and good service, we'd love to talk to you! Primary Responsibilities: The IT Business Analyst is an essential part of our product team by providing functional and systemic analysis to clarify scope. The role is a critical link between end users and our esteemed engineers. This team member brings a curious and empathic mindset to elicit the true requirements from business stakeholders. First and foremost, the Business Analyst is an excellent communicator who writes well, speaks well, and most importantly, listens well. The Business Analyst takes the time to understand why the current situation is as its is and positions the team to deliver results. An ideal candidate loves data, isnt afraid to explore the data model, and run queries to more deeply understand. Data visualization is an important skill that the Business Analyst uses to better understand reality. The role is perfect for somebody with a learning mindset who is open to exploring a variety of technologies related to the supply chain. Ultimately our Business Analysts are translators. They speak the languages of technology, business processes, and supply chain. They learn fast and have fun doing it! Are you:<ul><li>Comfortable with technology, including how to query and organize data?</li><li>Someone who welcomes the opportunity to speak up and ask questions?</li><li>Able to lead conversations to understand and document how our business works now and where we can improve?</li><li>Familiar with the Agile/Scrum framework?</li><li>Ok with moving quickly and shipping small, 'good enough' versions of done, knowing we'll iterate several times to find the best solution?</li><li>Someone with an appetite to learn new things, who is willing to share what you've learned with others?</li></ul>If so, and if you have a demonstrated track record of delivering on your commitments, overcoming challenges, and creating an environment where team members are open and can do their best work, the BA position at KeHE may be the right next step for your career! For more on our tech scene, check out <a href="https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftracking.icims.com%2Ff%2Fa%2FpZsh21vruZ14cf-J9tJ3gw~~%2FAAIB5gA~%2FRgRkqK-MP0Q4aHR0cHM6Ly93d3cuYnVpbHRpbmNoaWNhZ28ub3JnL2NvbXBhbnkva2VoZS1kaXN0cmlidXRvcnNXA3NwY0IKYrOMKsZiTjdJrVIVZGFubnkub2xsaWVyQGtlaGUuY29tWAQAAACc&data=05%7C01%7Cdanny.ollier%40kehe.com%7C876c506afed5439ad27808da5fb0bbb2%7C082722e4dbdf4801b74f274a5921d5ec%7C0%7C0%7C637927509917858907%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2BwIS6RVbJXUS9KpUJ78TMgvQgZVB6hTUDx5avSaulug%3D&reserved=0" target="_blank" rel="noopener">KeHE Distributors on Built In Chicago</a>, where we are named one of the Best Places to Work. What Youll Be Doing:<ul><li>Analyze existing business processes to identify gaps and areas of improvement.</li><li>Document as-is and to-be process scenarios.</li><li>Elicit, analyze and document functional and technical requirements as user stories.</li><li>Develop and maintain a customer-focused relationship with business stakeholders and Subject Matter Experts.</li><li>Solicit feedback from users and stakeholders.</li><li>Ask very effective questions to understand motivations and root cause.</li><li>Research and analyze issues. Summarize problem definition and potential solutions.</li><li>Identify test scenarios and assist with testing.</li><li>Assist Product Owner with backlog grooming and user story prioritization.</li><li>Facilitate in Daily Stand up, Sprint Planning, User Story Workshop, and Sprint Reviews</li><li>Participate in Sprint Retrospectives</li></ul> Essential Functions: Major projects include (but not limited to)<ul><li>A B2B e-commerce platform for retailers of the food industry</li><li>A B2B digital platform for suppliers of the food industry</li><li>A top-tier virtual marketing show experience built entirely online</li><li>Charity hackathons and contributions to "Make Lives Better"</li></ul> Minimum Requirements, Qualifications, Additional Skills, Aptitude: What you bring:<ul><li>Bachelor's Degree with at least 2 years of professional experience in related role.</li><li>Experience in an agile environment with an understanding of how each role performs to achieve team goals.</li><li>Proactive, persistent, flexible. Operates independently and reacts quickly, with assistance from Product Owner</li><li>Acts with empathy and curiosity. Listens and seeks to understand.</li><li>Flexible and able to handle a variety of assignments in various stages at the same time.</li><li>Strong oral and written communication and interpersonal skills. Enjoys interacting with others.</li><li>Excellent analytical and problem-solving skills and proven business acumen.</li><li>Business transformation experience, Six Sigma a plus.</li></ul>What you Get: Competitive Salary, Profit Sharing, Paid Time Off, Medical, Dental, Vision, Life/disability insurance, FSA & HSA, 401k, ESOP (Employee Stock Ownership Plan), Wellness Program, Employee Assistance Program, Tuition Reimbursement, Work from Home Requisition ID: 2024-24216 Equal Employer Opportunity Statement: KeHE Distributors provides equal employment opportunities to all employees and applicants for employment and prohibits all forms of discrimination and harassment on the basis of race, color, religion or faith, sex, gender, age, ancestry, national origin, mental or physical disability or medical condition, sexual orientation, gender identity or expression, marital status, military or veteran status, genetic information, or any other category protected under federal, state, or local law. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training as well as the administration of all Human Resources and Talent Acquisition processes.

Why Work for KeHE?: <ul> <li>Full-time </li><li>Pay Range: $54,243.00/Yr. - $79,556.00/Yr. </li><li>Shift Days: , Shift Time: </li><li>Benefits on Day 1 <ul> <li>Health/Rx </li><li>Dental </li><li>Vision </li><li>Flexible and health spending accounts (FSA/HSA) </li><li>Supplemental life insurance </li><li>401(k) </li><li>Paid time off </li><li>Paid sick time </li><li>Short term & long term disability coverage (STD/LTD) </li><li>Employee stock ownership (ESOP) </li><li>Holiday pay for company designated holidays </li></ul>Overview: Good people, working with good people, for our common good. Sound good? KeHE-a natural, organic, specialty and fresh food distributor-is all about "good" and is growing, so there's never been a more exciting time to join our team. If you're enthusiastic about working in an environment with a people-first culture and an organization committed to good living, good food and good service, we'd love to talk to you! Primary Responsibilities: The Pricing Analyst position is responsible for performing pricing, margin and profitability analysis for products, categories, suppliers and customers within the KeHE distribution network. This includes inbound cost components, outbound price points and the resulting standard margin. All accountabilities are to be fulfilled in a manner consistent with the Company Mission and Values. This position is based out of our Naperville IL headquarters and is onsite Tuesday, Wednesday, and Thursday with the ability to work remotely Monday and Friday. Essential Functions: <ul> <li>Facilitate implementing actionable analytics and forecasting relative to item cost, selling price, and margin </li><li>Auditing and process oversight on pricing processes and quality controls. </li><li>Consumption of internal and market place data supporting pricing strategy and impact </li><li>Customer RFP pricing and catalog file creation </li><li>Support pricing components of new customer on-boarding </li><li>Support pricing components of customer model change processes </li><li>Support pricing file upload and system control files </li><li>AS400/SAAS System maintenance related to pricing data </li><li>Oversee extensive data mining for cost/price components and vendor/item attributes </li><li>Ad hoc reporting, as required </li></ul>Minimum Requirements, Qualifications, Additional Skills, Aptitude: <ul> <li>Bachelors Degree required </li><li>Extensive knowledge of Microsoft Office programs including: Excel, Access, Word, Outlook and Power Point required </li></ul> Qualifications / Additional Skills / Aptitude: <ul> <li>High math acumen and analytical skills </li><li>Experience with data mining software (e.g., Pricefx, SQL, AS400, Power BI) is strongly preferred </li><li>Pricing/margin management experience required </li><li>Demonstrated oral and written communication skills to transfer process and concept knowledge to all levels of internal and external customer base </li><li>Distribution experience preferred </li></ul> Requisition ID: 2024-24224 Equal Employer Opportunity Statement: KeHE Distributors provides equal employment opportunities to all employees and applicants for employment and prohibits all forms of discrimination and harassment on the basis of race, color, religion or faith, sex, gender, age, ancestry, national origin, mental or physical disability or medical condition, sexual orientation, gender identity or expression, marital status, military or veteran status, genetic information, or any other category protected under federal, state, or local law. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training as well as the administration of all Human Resources and Talent Acquisition processes.</li></ul>

Kehe Distributors Business Intelligence Interview Guide

Overview

Kehe Distributors Business Intelligence Salary

Kehe Distributors Business Intelligence Interview Process

Kehe Distributors Business Intelligence Interview Questions

Kehe Distributors Business Intelligence Jobs