The Choctaw nation Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Choctaw nation Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Choctaw nation? The Choctaw nation Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Choctaw nation Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Choctaw nation.</li>
<li>Practice real Choctaw nation Business Intelligence interview questions.</li>
</ul>
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 Choctaw nation Business Intelligence interview.


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

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

Overview

Choctaw nation Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Choctaw nation Business Intelligence Interview Process

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.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

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

<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

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</code> table

<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>
<code>managers</code> table

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

<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

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</code> table

<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>
<code>users</code> table

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

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

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Choctaw nation Business Intelligence Interview Questions

**Job Purpose or Objective(s):** The Database Marketing Analyst provides detailed reporting on player and database trends and generates applicable data sets that can be used for marketing efforts (including Direct Marketing). You are also responsible for creating Pro and Post Forma analysis of promotions and events and communicate those findings to management. The Database Marketing Analyst is also responsible compiling trend analysis and communicating any areas of success or concern to management. You will report to the Marketing Analytics Manager. **Primary Tasks:** 1. You will create pro/forma analysis of marketing programs and campaigns before execution to determine expected profitability. 2. Produce comprehensive review of the impact of all Marketing Promotions and Special Events. 3. You will produce monthly tracked play and player tier summary reports for all revenue streams. 4. Produce monthly direct marketing redemption reports showing the redemption habits and associated play with all offers issued. 5. You will create monthly and ad hoc reports from the Accounting and Player Tracking systems for each property outlining their progress towards achieving annual goals. 6. Produce reports showing the performance of new members, redemption of free play grouped by usage type, and tracked play by geography to highlight growth and contraction markets. 7. You will create monthly summary reports detailing play by main database segments and communicate findings. 8. Produce direct marketing and promotional lists from player tracking or data warehouse systems based on specific marketing and player development campaigns. 9. You will produce player summary reports and work with Player Development management to assign players to the appropriate staff in the player tracking system. 10. Other duties as assigned. **MINIMUM** * Bachelor's degree in marketing, accounting, finance, business administration, or related field and one [1] or more years of database marketing/analytics experience, OR five [5] years of directly related experience in lieu of education. * Advanced Microsoft Office skills including, higher level functions in EXCEL such as Pivot Tables, sumifs, Nested formulas, V/H lookups, Macros, Graphing, etc. * Ability to read, analyze, interpret and make recommendations based on statistical reports * Ability to maintain organization, meet deadlines, possesses integrity, confidentiality, and discretion in handling confidential information About the Choctaw Nation The Choctaw Nation is the third-largest Indian nation in the United States, with over 200,000 tribal members and more than 11,000 employees. The first tribe over the Trail of Tears, historic boundaries are in the southeast corner of Oklahoma. The Choctaw Nation's vision, "Living out the Chahta Spirit of faith, family and culture," is evident as it continues to focus on providing opportunities for growth and prosperity. Benefits + Free gym membership + Free access to employee health clinic + Free lunch for casino & resort associates + Earned wages access once per week for hourly Associates + Pet insurance + Paid vacation / sick time + Medical / Dental / Vision + 401(K) with company match + College tuition reimbursement + Short-term disability, long-term disability, and family leave + Employee assistance program + Employee prescription program + CNO Paid Life Insurance + Teladoc + On Site Dental Clinics (Jet Dental) + On Site Mammogram Services + Free diabetes and hypertension monitoring benefit (Livongo) + Accolade- Concierge Benefits Program + Wellness Program that equals savings on health insurance cost (Virgin Pulse) + Maternity Care Program + **(Benefits provided by the Choctaw Nation are based on employment classification)** CNO was selected as a winner in both HRDUS' and Forbes' 2022 "Employer of Choice" competitions: + Choctaw Nation of Oklahoma received recognition as one of six Best Places to Work in the United States as selected by HRDUS + Choctaw Casinos & Resorts received recognition from Forbes as a Best Employer for Diversity in the Travel & Leisure category. + Forbes also recognized the Choctaw Casino and Resorts as one of America's Best Employers for New Graduates. Job Identification: 13104 Job Category: Marketing Posting Date: 10/29/2024, 9:00 PM Job Schedule: Full time Job Shift: Day Shift On-Site/Remote: On-Site

Onsite| Monday-Friday| 8:00 AM - 4:30PM **Job Purpose or Objective(s):** As the Market Research Analyst, you will interpret data, formulating reports, and making recommendations based on the research findings to identify changes and forecast trends in the field of marketing and communications. You will report to the Market Research Manager. **Primary Tasks:** 1. You will evaluate methods for collecting data, and implement research methods, such as surveys, questionnaires, interviews, focus groups, and opinion polls. 2. Gather data on market conditions, collaborate with teams inside and outside the organization to gather relevant qualitative and quantitative data. 3. Collect and convert complex data and findings into understandable and applicable items, reports, and presentations. 4. Determine the most effective market research methods to track target audience demographic trends and market demands. 5. Conduct market research using traditional and modern statistical techniques and software. 6. Understand departmental goals and design surveys to discover prospective consumer preferences. 7. Evaluate program methodology, important data, and define research goals. 8. Analyze autonomously qualitative and quantitative data, trends, and strategies, especially marketing and communications industry trends. 9. Perform other tasks as assigned. **Job Requirements:** * Bachelor's Degree in business, economics, statistics, math, market research, related field, or four (4) years of relevant experience. * Ability to understand large amounts of information including research data analysis and statistics * Ability to collaborate well with teams * Experience with computers including higher level functions of Microsoft Excel, such as Pivot Tables, and statistical software platforms * Ability to read, analyze, interpret, and make recommendations based on statistical reports * Knowledge of human subject research and ethical research practices * Two years experience in similar role About the Choctaw Nation The Choctaw Nation is the third-largest Indian nation in the United States, with over 200,000 tribal members and more than 11,000 employees. The first tribe over the Trail of Tears, historic boundaries are in the southeast corner of Oklahoma. The Choctaw Nation's vision, "Living out the Chahta Spirit of faith, family and culture," is evident as it continues to focus on providing opportunities for growth and prosperity. **Benefits** + Free gym membership + Free access to employee health clinic + Free lunch for casino & resort associates + Earned wages access once per week for hourly Associates + Pet insurance + Paid vacation / sick time + Medical / Dental / Vision + 401(K) with company match + College tuition reimbursement + Short-term disability, long-term disability, and family leave + Employee assistance program + Employee prescription program + CNO Paid Life Insurance + Teladoc + On Site Dental Clinics (Jet Dental) + On Site Mammogram Services + Free diabetes and hypertension monitoring benefit (Livongo) + Accolade- Concierge Benefits Program + Wellness Program that equals savings on health insurance cost (Virgin Pulse) + Maternity Care Program + **(Benefits provided by the Choctaw Nation are based on employment classification)** CNO was selected as a winner in both HRDUS' and Forbes' 2022 "Employer of Choice" competitions: + Choctaw Nation of Oklahoma received recognition as one of six Best Places to Work in the United States as selected by HRDUS + Choctaw Casinos & Resorts received recognition from Forbes as a Best Employer for Diversity in the Travel & Leisure category. + Forbes also recognized the Choctaw Casino and Resorts as one of America's Best Employers for New Graduates. #LI-onsite Job Identification: 12970 Job Category: Marketing Posting Date: 10/23/2024, 8:23 PM Job Schedule: Full time Job Shift: Day Shift On-Site/Remote: On-Site

Choctaw nation Business Intelligence Interview Guide

Overview

Choctaw nation Business Intelligence Salary

Choctaw nation Business Intelligence Interview Process

Choctaw nation Business Intelligence Interview Questions

Choctaw nation Business Intelligence Jobs