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

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>

Overview:<br/><p style="margin: 0px;">Omni Hotels and Resorts creates genuine, authentic guest experiences at 60 distinctive luxury hotels and resorts in leading business gateways and leisure destinations across North America. Omni Hotels is known for its exemplary culture, authenticity to the markets in which we operate, innovation and exceptional service.  Our commitment to career development has created tenure and loyalty that enables us to perpetuate our family atmosphere.</p><br/><br/>Job Description:<br/><p style="margin: 0px;"><span style="font-family: arial, helvetica, sans-serif; color: #374151; font-size: 10pt;">Omni Hotels & Resorts is seeking a highly motivated and skilled Digital Marketing Analyst to join our team in the hospitality industry. As a Digital Marketing Analyst, you will play a crucial role in driving our online marketing efforts, analyzing data, and providing recommendations and insights to enhance our digital presence. You will be responsible for monitoring digital campaigns, conducting market research, analyzing customer behavior, and providing actionable insights to optimize our marketing initiatives. This is an exciting opportunity to contribute to the growth and success of our hospitality business online.</span></p><br/><br/>Responsibilities:<br/><ul><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Develop and execute a standard operating process for successful reporting, data integration, as well as producing key insights for growth through our digital channels.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Monitor and analyze key performance indicators (KPIs) for digital marketing campaigns and web sites, such as website traffic, conversion rates, click-through rates, and ROI, and provide actionable recommendations for optimization across the user journey.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Prepare regular reports and presentations on digital marketing performance, highlighting key findings, trends, and actionable insights to stakeholders as well as ad hoc reports as needed.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Utilize web analytics tools (e.g., Google Analytics) to track user behavior, identify areas for improvement, and measure the effectiveness of marketing strategies.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Collaborate with cross-functional teams, including marketing, sales, and revenue, to develop an automated reporting process aligned with business objectives.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Support our digital product team in A/B testing of our web sites.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Collaborate with external agencies and vendors to ensure tagging/tracking strategy is in place and continues to remain intact through any changes to the site. </span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Creation of comprehensive tracking & UTM tagging implementation strategies and process</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Serve as subject matter expert on digital analytics by providing best practices in defining success, reporting guidelines and validation of tracking.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Responsible for the evaluation of the current measurement practices and capabilities and formulating a vision for further evolution to future proof our reporting standards.</span></li></ul><br/><br/>Qualifications:<br/><ul><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">3- 5 years of proven work experience in Digital, Marketing Analytics or a similar role in the hospitality industry.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Advanced in using digital marketing tools and data visualization tools, such as Google Analytics, Google Tag Manager and Google Ads</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Strong analytical skills with the ability to collect, analyze, and interpret complex data sets to drive marketing decisions.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Excellent understanding of full funnel digital marketing concepts, including SEO, SEM, social media marketing, email marketing, content marketing, and digital advertising.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Experience with A/B or multivariate testing</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Knowledge of hospitality industry trends, customer behavior, and best practices in the digital marketing landscape is preferred.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Ability to work independently and collaboratively in a fast-paced environment, managing multiple projects simultaneously while meeting deadlines.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Strong communication and presentation skills to effectively convey data-driven insights and recommendations to both technical and non-technical stakeholders.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Detail-oriented mindset with a focus on accuracy and the ability to identify patterns and trends in data.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">A passion for the hospitality industry and a customer-centric approach to digital marketing strategies.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">PowerBI and LookerStudio experience a plus.</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Understanding of Advance measurement (Media Mix Modeling, Incrementality testing,etc)</span></li></ul><p style="margin: 0px;"> </p><p style="margin: 0px;"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"><em><span style="font-size: 11.0pt; font-family: 'Arial',sans-serif;">Omni Hotels & Resorts is an equal opportunity/AA/Disability/Veteran employer. The EEO is the Law poster and its supplement are available using the following links: <a href="https://www1.eeoc.gov/employers/poster.cfm" target="_blank" rel="noopener"><span style="color: windowtext;">EEOC is the Law Poster</span></a> and the following link is the <a href="https://www.dol.gov/ofccp/pdf/pay-transp_formattedESQA508c.pdf" target="_blank" rel="noopener"><span style="color: windowtext;">OFCCP's Pay Transparency Nondiscrimination policy statement </span></a><br /><br />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 <a href="mailto:applicationassistance@omnihotels.com?Subject=Application%20Assistance" target="_blank" rel="noopener"><span style="color: windowtext;">applicationassistance@omnihotels.com</span></a></span>.</em></span></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