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

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>

Responsibilities:<br/><p style="margin: 0px;"><strong>Pay Transparency Statement:? </strong></p><p style="margin: 0px;">The compensation philosophy reflects the Companys reasonable expectation at the time of posting. We consider a number of factors when making individual compensation decisions including, but not limited to, skill sets, experience and training, and other business needs. ?This role may also be eligible to participate in a discretionary incentive program, subject to the rule governing the program.</p><p style="margin: 0px;"><strong> </strong></p><p style="margin: 0px;"><strong>Position Summary:</strong>  </p><p style="margin: 0px;">The Senior Data Scientist has a solid understanding of advanced analytics and will be responsible for refining existing statistical/machine learning models and developing new ones to support business. Will partner with direct team members as well as cross-functional partners and decision makers. This persons primary tasks will be to develop, refine, deploy, and productionize impactful data science projects for business users.  Additionally, should provide technical guidance for the team members, when necessary.  </p><p style="margin: 0px;"> </p><p style="margin: 0px;"><strong>Position Responsibilities may include, but not limited to:</strong> </p><ul><li>Identify best or most applicable analytical techniques for a given business problem</li><li>Develop and deploy statistical and machine learning models to address business problems using Python and others</li><li>Maintain and refine existing models and related processes</li><li>Utilize statistical or time-series models to make predictions on future outcomes in multiple scenarios</li><li>Implement models and create processes to monitor their performance, including input data integrity</li><li>Employ data visualization tools and codes where appropriate via Power BI and others</li><li>Partner with IT / BI / Data teams to ensure data used for modeling accurately reflects business reality</li><li>Effectively communicate model approaches, outputs, and findings to technical and non-technical audiences</li><li>Document projects including business objectives, data gathering/processing, approaches and algorithms, and detailed set of results and analytical metrics</li><li>Ensure modeling processes always conform to IT security standards</li></ul><br/><br/>Qualifications:<br/><p><strong>Required Skills and Experience:</strong> </p><ul type="disc"><li>Bachelors Degree in Analytics, Data Science, Operations Research, Statistics, or other related quantitative discipline</li><li>4+ years experience in data science, advanced analytics, or quantitative/computational functions</li><li>Deployed regression, time-series, and machine learning models in Python or other languages, for a variety of business problems</li><li>Working knowledge in analytical techniques such as multivariate regression, time series, classification methods, Bayesian methods, or neural networks</li><li>Experiences in databases and SQL and in big data/cloud platforms such Azure, Databricks, Snowflake, and Spark</li><li>Experiences in data visualization tools such as Power BI for reporting model outputs, data trends, business issues, or exceptions</li><li>This position must pass a post-offer background and drug test</li></ul><p><strong>Preferred Skills and Experience:</strong> </p><ul><li>Experience in Blue Yonder</li><li>Experience in consumer-packaged goods or distribution/wholesale</li></ul><p><strong>Physical Demands and Work Environment</strong>:</p><p>Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.  Due to the nature of our business in regard to such things as delivery schedules, order inputs, selection, and Department of Transportation Hours of Service, overtime, attendance and punctuality are essential job functions.  Should an individual in this classification not be able to adhere to this requirement due to a disability, they should contact their Human Resources department to see what, if any, reasonable accommodation may be made. </p><br/><br/>Equal Opportunity Employee & Physical Demands:<br/>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.<br/><br/>Background Check and Drug Screening:<br/>Offers of employment are contingent upon successful completion of a background check and drug screening.<br/><br/>Pay Transparency:<br/>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.

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