The Omni Hotels & Resorts Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Omni Hotels & Resorts Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Omni Hotels &amp; Resorts? The Omni Hotels &amp; Resorts 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 Omni Hotels &amp; Resorts Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Omni Hotels &amp; Resorts.</li>
<li>Practice real Omni Hotels &amp; Resorts 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 Omni Hotels &amp; Resorts Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Omni Hotels & Resorts? The Omni Hotels & Resorts Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

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

Overview

Omni Hotels & Resorts 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.

Omni Hotels & Resorts 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 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

<p>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</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>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Omni Hotels & Resorts Business Intelligence Interview Questions

Overview:<br/><p style="margin: 0px;"><strong><span style="font-family: verdana, geneva; font-size: 10pt;">Omni Tempe Hotel at ASU</span></strong></p><p style="margin: 0px;"> </p><p style="margin: 0px;"><img src="https://omnihotels.icims.com/icims2/servlet/icims2?module=AppInert&action=download&id=1177333&hashed=1084769440" alt="Tempe 3" /></p><p style="margin: 0px;"> </p><p style="margin: 0px;">Located at the corner of University and Mill, Omni Tempe Hotel at ASU amplifies Tempes revitalized downtown area and brings some of the largest conference and meeting space to the city. The hotel features 330 guest rooms, four dining outlets, a spacious pool deck, retail, and almost 36,000 square feet of indoor and outdoor meeting space along with expansive views of the ASU campus and the Tempe cityscape. We are building an amazing team that focuses on creating incredible guest experiences. Join us and be a part of something special!</p><br/><br/>Job Description:<br/><p style="margin: 0px;">Are you mechanically inclined, passionate about hands-on problem-solving, and excited to take on a leadership role? Omni Tempe Hotel at ASU is seeking a skilled <strong>Engineering Manager</strong> to join our dynamic team. As the second in command of our maintenance department, you will provide vital technical and administrative support to the Director of Engineering, ensuring the seamless operation and upkeep of our facilities. You will also take on an active role in mentoring the engineers. </p><br/><br/>Responsibilities:<br/><ul><li>Assist the Director of Engineering in managing preventative maintenance, maintaining detailed logs, scheduling, and assigning projects and tasks.</li><li>Oversee the procurement of supplies and issuance of purchase orders.</li><li>Review and prioritize work orders, assigning tasks accordingly.</li><li>Maintain up-to-date inventories of heat, light & power, and repair and maintenance supplies.</li><li>Respond promptly and appropriately to guest requests.</li><li>Coordinate and supervise the activities and training of the Engineering staff on a shift basis.</li><li>Assist with scheduling, payroll administration, and time off requests for the department.</li><li>Assume full responsibility for the Engineering Department in the absence of the Director of Engineering.</li><li>Have a thorough understanding of Omni's safety equipment, fire alarm procedures, and emergency evacuation protocols.</li><li>Demonstrate expertise in all trade skills and code compliance.</li><li>Familiarize with Omni's Systems and Services procedures.</li><li>Assist with budgeting, forecasting, and spending controls, including capital budget production and obtaining quotes.</li><li>Possess extensive HVAC and mechanical experience.</li><li>Communicate effectively, both orally and in writing.</li><li>Work a flexible schedule, including nights, weekends, and holidays.</li><li>Serve as a people leader, helping to manage the engineering department and ensuring smooth day-to-day operations.</li><li>Mentor and develop other engineers, fostering a collaborative and supportive work environment.</li><li>Provide guidance and training to the Engineering staff, promoting professional growth and skill development.</li><li>Lead by example, demonstrating a strong work ethic, positive attitude, and commitment to excellence.</li></ul><br/><br/>Qualifications:<br/><ul><li>Must have extensive HVAC and mechanical experience.</li><li>Excellent oral and written communication skills. </li><li>Must be able to work a flexible schedule to include nights, weekends and holidays. </li><li>5+ years of <strong>hotel</strong> engineering experience preferred.</li><li>Experience managing a crew of 5 or more.</li><li>Must be able to lift 50lbs.</li><li>Standing, bending, sitting for long periods of time.</li><li>Desire to learn</li><li>Positive attitude</li><li>Ability to work well with others</li><li>Aspirations of career growth in the industry</li></ul><p style="margin: 0px;"> </p><p style="margin: 0px;"> </p><p style="margin: 0px;"><em><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif; color: black;">Omni Hotels & Resorts is an equal opportunity employer - vets/disability. The EEO is the Law poster and its supplement are available using the following links: </span></em><a href="https://www1.eeoc.gov/employers/poster.cfm" target="_blank" rel="noopener"><em><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;">EEOC is the Law Poster</span></em></a><em><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif; color: black;"> and the following link is the </span></em><a href="https://www.dol.gov/ofccp/pdf/pay-transp_formattedESQA508c.pdf" target="_blank" rel="noopener"><em><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;">OFCCP's Pay Transparency Nondiscrimination policy statement </span></em></a><em><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;">If you are interested in applying for employment with Omni Hotels & Resorts and need special assistance to apply for a posted position, please send an email to </span></em><a href="mailto:applicationassistance@omnihotels.com?Subject=Application%20Assistance" target="_blank" rel="noopener"><em><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;">applicationassistance@omnihotels.com</span></em></a><em><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;">. Omni Hotels & Resorts does not discriminate on the basis of any protected category with respect to the payment of wages.</span></em></p>

Omni Hotels & Resorts Business Intelligence Interview Guide

Overview

Omni Hotels & Resorts Business Intelligence Salary

Omni Hotels & Resorts Business Intelligence Interview Process

Omni Hotels & Resorts Business Intelligence Interview Questions

Omni Hotels & Resorts Business Intelligence Jobs