The Reyes Holdings Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Reyes Holdings Business Intelligence Interview Guide

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


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

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

Overview

Reyes Holdings 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.

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

<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

Reyes Holdings Business Intelligence Interview Questions

<p>Responsibilities</p><p>Position Summary:</p><p>The Associate IT Product Manager plays a pivotal role in bridging the gap between technology and business needs. This position develops and manages IT products and services that support the company operations, enhance efficiency and drive growth. The Associate IT Product Manager collaborates with the Product owner and develops forward leaning technologies for the company. This position leverages technology to optimize business processes and deliver exceptional customer experiences.</p><p>Position Responsibilities may include, but not limited to:</p><p>* Collaborate with internal teams, including business analysts and developers, to understand requirements and implement product features</p><p>* Execute on product roadmaps as outlined by senior leadership, focusing on short-term product improvements and tactical delivery</p><p>* Work closely with the Product Owner to define product requirements, refine user stories, and ensure clear communication between business and IT teams</p><p>* Prioritize day-to-day tasks within the backlog to ensure timely delivery of product updates and enhancements</p><p>* Conduct user acceptance testing and collaborate with the QA team to ensure product features meet quality standards</p><p>* Maintain the product backlog, ensuring that it remains actionable and aligned with immediate business goals</p><p>* Actively engage in Scrum ceremonies, including daily stand-ups and sprint reviews, to monitor progress and remove blockers for the development team</p><p>* Provide input on product performance, helping to identify minor improvements that can be quickly implemented</p><p>* Assist in the documentation and training for new features, ensuring stakeholders are aware of upcoming changes</p><p>* Support internal teams in piloting new technologies, providing feedback for iterative development</p><p>* Participate in stakeholder meetings to gather insights, document feedback, and implement small-scale adjustments</p><p>* Other projects or duties as assigned</p><p>Qualifications</p><p>Required Skills and Experience:</p><p>* Bachelor's degree in Computer Science, Information Systems or a related discipline, 3 plus years of experience in a product management role or HS Diploma/GED, 6 plus years of experience in a product management role</p><p>* Strong written, verbal and presentation skills with all levels of an organization</p><p>* Strong interpersonal and collaboration skills</p><p>* Detail and results oriented</p><p>* Customer service mindset</p><p>* Strong sense of urgency</p><p>* Entrepreneurial mindset</p><p>* Understanding of IT systems, software development methodologies, and project management principles</p><p>* Ability to learn new technologies</p><p>* Travel up to 25%</p><p>* This position must pass a post-offer background and drug test</p><p>Preferred Skills and Experience:</p><p>* Bachelor's degree</p><p>* One plus years of experience in a product management role in the Consumer-Packaged Goods industry</p><p>* Experience writing user stories, refining product backlogs, and coordinating/prioritizing conflicting requirements</p><p>* Experience working a in fast paced and changing work environment</p><p>* Experience in agile frameworks, i.e., Scrum, Kanban, etc.</p><p>* Experience using Azure DevOps or Jira for project management and collaboration</p><p>* Knowledge of agile development practices, methodologies, and tools</p><p>* Strong strategic thinking and problem-solving skills</p><p>* Strong focus on driving innovation and achieving business objectives</p><p>* Experience as a Product Owner or Scrum Master</p><p>Equal Opportunity Employee & Physical Demands</p><p>Reyes Holdings and its businesses are equal opportunity employers. Company policy prohibits discrimination and harassment against any applicant or employee based on race, color, religion, sex, pregnancy or pregnancy-related medical conditions, marital status, sexual orientation, gender identity or expression, age, national origin, citizenship, disability, genetic information, military or veteran status, or any other basis protected by applicable law. In addition, the Company is committed to providing reasonable accommodation to applicants and employees in accordance with applicable law. Requests for accommodation should be directed to your point of contact in the Talent Acquisition or Human Resources departments.</p><p>Background Check and Drug Screening</p><p>Offers of employment are contingent upon successful completion of a background check and drug screening.</p><p>Pay Transparency</p><p>Our compensation philosophy embraces diverse factors for fair pay decisions, valuing skills, experience, and the needs of our business. Moreover, this role may have the opportunity to participate in a discretionary incentive program, subject to program rules.</p>

Reyes Holdings Business Intelligence Interview Guide

Overview

Reyes Holdings Business Intelligence Salary

Reyes Holdings Business Intelligence Interview Process

Reyes Holdings Business Intelligence Interview Questions

Reyes Holdings Business Intelligence Jobs