The Us Foods Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Us Foods Business Intelligence Interview Guide

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


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

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

Overview

Us Foods 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.

Us Foods 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>Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>

<tr>
<td><code>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>order_amt</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Monthly Customer Report

<p>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

<p><strong>Example:</strong></p>

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

<p><code>employees</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>

<tr>
<td><code>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Manager Team Sizes

Us Foods Business Intelligence Interview Questions

<b>ARE YOU A CURRENT US FOODS EMPLOYEE? PLEASE APPLY DIRECTLY THROUGH OUR INTERNAL WORKDAY CAREER SITE. </b><br><br>Join Our Community of Food People!<br><br>At US Foods®, innovation and technology is our superpower. By expanding our digital ecosystem and leading with a customer-first mindset, we're delivering technology that empowers our customers and simplifies business. As we transform the digital landscape of the foodservice industry, we're outpacing our competitors faster than ever before. <br><br> We believe diversity is the cornerstone of creativity and innovation-and we foster an open, inclusive, flexible work environment that supports our transformation.<br><br>The Product Analyst I supports the Associate PO, PO or Sr. PO roles to drive the vision and strategy of a given Product as they ensure consistent value creation throughout the delivery process, and represents the needs of our customers and stakeholders. The goal of this role is to work on supporting tasks that allow the product teams to maximize the generated ROI of particular features and functionality within the product. They support breaking the requirements down into clear user stories for a well-prioritized backlog, as well as determining the right metrics to measure success against. The Product Analyst II works closely with a combination of Associate PO, PO, Sr PO, Scrum Master, Developers, UX designers, Architects, QA, and DevOps team members to design and deliver innovative solutions and Product features. <br><br>The right candidate has a growth mindset and curiosity with the ability to respond quickly to changing business needs & priorities, offering a versatile set of skills from requirements, to unit testing, integration testing, data analysis, data validation that support the product team in meeting their delivery and value goals. They must possess the ability to rapidly earn trust with both stakeholders and team members, and can work effectively with cross-functional teams.<br><br><b>Flexible Work Policy: The work for the Product Analyst I position is completely 100% remote anywhere in the United States except Hawaii or United States Territories. This position may have the potential to travel up to 20% dependent on business needs.</b><br><br><b>RESPONSIBILITIES </b> <br><ul><li>Establish and maintain relationships with business and technology stakeholders</li><li>Serve as a liaison between the business and development, acting as the voice of the customer and communicating requirements and needs to the Product team</li><li>Deliver on-time, on-budget, on-quality, on-fit service(s) or Product(s)</li><li>Maintain, refine, and continuously groom the Team Backlog within sprint timeframe</li><li>Work within an Agile framework to develop and execute against a Product roadmap</li><li>Develop user stories with detailed requirements and acceptance criteria that address end-user needs</li><li>Participate in recurring Agile ceremonies including Sprint Planning, Daily Standups, Sprint Demos, etc.</li><li>Maintain metrics that track value of delivered Features and team output</li><li>Understand and communicate the value being delivered by their product teams</li><li>Maintain an innovating and future-proofing agenda for given Product(s)</li><li>Maintain User and Technical documentation for release management</li><li>Anticipate, mitigate and chaperone escalations</li><li>Other duties as assigned by manager</li></ul><br><br><b>SUPERVISION</b>:<br><ul><li>The Product Analyst I role is an independent contributor role</li></ul><br><br><b>RELATIONSHIPS</b><br><ul><li><b>Internal: </b>Business Stakeholders and End Users, IT PDL, IT Delivery (Scrum Masters, Developers, Architects, UX Designers, Program Managers, etc.)</li><li><b>External:</b> Application / Systems Vendors (as applicable)</li></ul><br><br><b>WORK ENVIRONMENT</b><br><ul><li><b>Remote</b>: This role is fully remote, and the associate is expected to perform assigned responsibilities from a home-based environment.</li><li><b>Up to 10% Travel</b></li></ul><br><br><b>EDUCATION</b><br><ul><li>Bachelor's degree in Computer Science, Business Administration, Information Systems, or equivalent work experience</li></ul><br><br><b>PREFERRED QUALIFICATIONS</b><br><ul><li>Agile or SAFe certification(s) highly preferred</li><li>Demonstrated ability to influence change within large, complex organizations</li><li>Experience using Agile project management tools (e.g. Atlassian) and flowchart tools (e.g. Visio, Lucid Chart) strongly preferred</li><li>Experience with eCommerce, restaurant, and/or wholesale food distribution industries strongly preferred</li></ul><br><br>The following information is provided in accordance with certain state and local laws. Compensation depends on experience, geographic locations, and other factors permitted by law. In Colorado, the expected compensation for this role is between $62,300 and $83,100. In Connecticut, the expected compensation for this role is between $73,500 and $98,000. In New York, the expected compensation for this role is between $73,500 and $98,000. In California, the expected compensation for this role is between $69,900 and $93,100. In Washington, the expected compensation for this role is between $69,900 and $93,100. This role is also eligible for annual incentive plan bonus. Benefits for this role include health insurance, pre-tax spending accounts, retirement benefits, paid time off, short-term and long-term disability, employee stock purchase plan, and life insurance. To review available benefits, please click here: https://www.usfoods.com/careers/benefits.html.<br><br><b>***EOE Race/Color/Religion/Sex/Sexual Orientation/Gender Identity/National Origin/Protected Veteran/Disability Status***</b>

Us Foods Business Intelligence Interview Guide

Overview

Us Foods Business Intelligence Salary

Us Foods Business Intelligence Interview Process

Us Foods Business Intelligence Interview Questions

Us Foods Business Intelligence Jobs