The Chickasaw Nation Industries, Inc. Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Chickasaw Nation Industries, Inc. Business Intelligence Interview Guide

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


Getting ready for an Business Intelligence interview at Chickasaw Nation Industries, Inc.? The Chickasaw Nation Industries, Inc. Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Chickasaw Nation Industries, Inc. Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Chickasaw Nation Industries, Inc..
- Practice real Chickasaw Nation Industries, Inc. 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 Chickasaw Nation Industries, Inc. Business Intelligence interview.
        

Overview

What Chickasaw Nation Industries, Inc. Looks for in a Business Intelligence

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

Chickasaw Nation Industries, Inc. Business Intelligence Interview Process

Interview Tips

<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>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

<p><strong>Example:</strong></p>

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

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the total salary of slacking employees.

Slacking Employees Salaries

<p>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Chickasaw Nation Industries, Inc. Business Intelligence Interview Questions

Data Analyst
R7793 • Database data systems management it
Oklahoma City, OK • Full-Time
A mid-level  Data Analyst  contributes to analyzing complex data sets, focusing on data modeling, process optimization, and improving supply chain operations. Strong attention to detail and analytical expertise supports decision-making processes by providing accurate, actionable insights for both DOD and commercial supply chain functions. This full-time position is on-site in the Oklahoma City, OK area.
Chickasaw Nation Industries, Inc.  serves as a holding company with multiple subsidiaries engaged in several lines of business (Technology, Infrastructure & Engineering, Health, Manufacturing, Public Safety, Consulting, and Transportation) for the federal government and commercial enterprises. A portion of our profits is used to support Chickasaw citizens. We are proud to support the economic development and long-term viability of the Chickasaw Nation and its people. CNI offers premium benefits eligible on the first day of hire to full-time employees; (Medical - Dental – Vision), Company Life Insurance, Short-Term and Long-Term Disability Insurance, 401(K) Immediate Vesting, Professional Development Assistance, Legal Aid Assistance Program, Family Planning / Fertility Assistance, Personal Time Off, and Observance of Federal Holidays.
As a federal contractor, CNI is a drug-free workplace and adheres to the Federal Controlled Substance Act.
ESSENTIAL REQUIREMENTS
Must be able to obtain and maintain a Public Trust Clearance.
Bachelor’s degree in Engineering, Supply Chain Management, Business Analytics, or a related field.
Three to five (3-5) years of experience in data analytics, with a strong focus on data modeling and process optimization, ideally within supply chain management.
Excellent attention to detail, ensuring high accuracy in data analysis and reporting.
Proficiency in data analysis and modeling tools (e.g., Excel, SQL, Python, R) and experience with visualization tools like Power BI or Tableau.
Strong understanding of supply chain processes, including logistics, procurement, and demand planning, with experience in both DOD and commercial environments.
Ability to clean, validate, and manipulate large datasets to derive meaningful insights.
Strong analytical skills with the ability to translate complex data into actionable recommendations for business stakeholders.
Excellent written and verbal communication skills, with the ability to present technical findings to non-technical audiences.
Ability to work independently, manage multiple tasks, and meet deadlines in a fast-paced environment.
KEY DUTIES AND RESPONSIBILITIES
Essential Duties and responsibilities include the following. Other duties may be assigned.
Analyzes and interpret supply chain data, ensuring accuracy and consistency across datasets.
Develops and maintains data models to support decision-making processes, enabling the optimization of supply chain operations.
Utilizes data analytics tools to assess trends and performance metrics and identify opportunities for process improvements in both DOD and commercial sectors.
Works closely with stakeholders to understand business needs and provide data-driven insights that align with supply chain objectives.
Cleans, transforms, and validates data from multiple sources to ensure integrity and consistency across systems.
Creates and maintains dashboards and reports to track supply chain performance, offering clear, actionable insights to leadership.
Assists in designing and implementing process improvements, ensuring data insights inform strategic and operational decisions.
Collaborates with cross-functional teams, including IT and business units, to ensure data models and processes align with organizational needs.
Supports supply chain transformations by providing data analysis for process redesign and performance tracking.
Ensures detailed documentation of data models, analyses, and reporting methodologies for transparency and future reference.
EDUCATION AND EXPERIENCE
Bachelor’s degree in Engineering, Supply Chain Management, Business Analytics, or a related field and three to five (3-5) years of experience in data analytics, with a strong focus on data modeling and process optimization, ideally within supply chain management.
PHYSICAL DEMANDS
Work is primarily performed in an office environment. Regularly required to sit. Regularly required use hands to finger, handle, or feel, reach with hands and arms to handle objects and operate tools, computer, and/or controls. Required to speak and hear. Occasionally required to stand, walk and stoop, kneel, crouch, or crawl. Must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and ability to adjust focus. Exposed to general office noise with computers printers and light traffic.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job.
EOE including Disability/Vet
CNI offers a comprehensive benefits package that includes:
Medical
Dental
Vision
401(k)
Family Planning/Fertility Assistance
STD/LTD/Basic Life/AD&D
Legal-Aid Program
Employee Assistance Program (EAP)
Paid Time Off (PTO) – (11) Federal Holidays
Training and Development Opportunities
Your application submission will be considered for all potential employment opportunities with Chickasaw Nation Industries (CNI).
Apply Today

#J-18808-Ljbffr

Senior Data Analyst
R7794 • Database data systems management it
Oklahoma City, OK • Full-Time
A  Senior Data Analyst / Data Analyst V  leverages strong Business Process Reengineering (BPR) and Supply Chain Management (SCM) background to analyze and transform complex data sets. This role focuses on process redesign, data-driven decision-making, and supporting supply chain optimization initiatives within the Department of Defense (DOD) and commercial sectors. Drives process improvements and ensures efficient supply chain operations that meet strategic and operational goals.
Chickasaw Nation Industries, Inc.  serves as a holding company with multiple subsidiaries engaged in several lines of business (Technology, Infrastructure & Engineering, Health, Manufacturing, Public Safety, Consulting, and Transportation) for the federal government and commercial enterprises. A portion of our profits is used to support Chickasaw citizens. We are proud to support the economic development and long-term viability of the Chickasaw Nation and its people. CNI offers premium benefits eligible on the first day of hire to full-time employees; (Medical - Dental – Vision), Company Life Insurance, Short-Term and Long-Term Disability Insurance, 401(K) Immediate Vesting, Professional Development Assistance, Legal Aid Assistance Program, Family Planning / Fertility Assistance, Personal Time Off, and Observance of Federal Holidays.
As a federal contractor, CNI is a drug-free workplace and adheres to the Federal Controlled Substance Act.
ESSENTIAL REQUIREMENTS
Must be able to obtain and maintain a Public Trust Clearance.
Bachelor’s degree in Engineering, Supply Chain Management, Business Analytics, or a related field.
Six to ten (6-10) years of experience in data analysis with a strong focus on BPR and SCM, including expertise in both DOD and commercial supply chain environments.
Proven experience in analyzing large datasets and translating findings into actionable insights that drive process improvement.
Strong knowledge of BPR methodologies and how to apply them within supply chain functions to optimize business operations.
Experience with data visualization tools (e.g., Power BI, Tableau) and business intelligence tools to communicate data insights effectively.
Advanced proficiency in Excel, SQL, and other data analysis tools, with the ability to work with complex data sets and generate meaningful reports.
Understanding of supply chain processes, logistics, and procurement within both the DOD and commercial sectors.
Strong problem-solving skills with the ability to identify process inefficiencies and recommend data-driven improvements.
Excellent communication skills, with the ability to present technical findings to non-technical stakeholders and senior leadership.
Ability to work independently and as part of a cross-functional team in a fast-paced, dynamic environment.
KEY DUTIES AND RESPONSIBILITIES
Essential Duties and responsibilities include the following. Other duties may be assigned.
Analyzes and interprets large datasets to identify trends, inefficiencies, and opportunities for process redesign within supply chain operations in the DOD and commercial sectors.
Utilizes BPR methodologies to assess and redesign business processes across the supply chain, ensuring alignment with best practices and organizational objectives.
Collaborates with cross-functional teams to develop and implement data-driven solutions that improve supply chain efficiency, reduce costs, and optimize overall performance.
Supports the design and development of data models and dashboards to track supply chain metrics, providing actionable insights to leadership and stakeholders.
Ensures data integrity by managing and validating data sources, improving data accuracy, and addressing discrepancies.
Leads the development of reports and presentations to communicate findings, process redesign recommendations, and performance improvements to senior leadership and stakeholders.
Analyzes key supply chain data, identifies bottlenecks, and recommends process enhancements to support supply chain transformation initiatives.
Works closely with IT teams to ensure data systems and tools are aligned with business requirements and optimize data flow across supply chain functions.
Mentors junior analysts, providing guidance on best practices for data analysis, process redesign, and supply chain performance optimization.
EDUCATION AND EXPERIENCE
Bachelor’s degree in Engineering, Supply Chain Management, Business Analytics, or a related field and six to ten (6-10) years of experience in data analysis with a strong focus on BPR and SCM, including expertise in both DOD and commercial supply chain environments.
PHYSICAL DEMANDS
Work is primarily performed in an office environment. Regularly required to sit. Regularly required to use hands to finger, handle, or feel, reach with hands and arms to handle objects and operate tools, computer, and/or controls. Required to speak and hear. Occasionally required to stand, walk and stoop, kneel, crouch, or crawl. Must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and ability to adjust focus. Exposed to general office noise with computers, printers, and light traffic.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job.
EOE including Disability/Vet
CNI offers a comprehensive benefits package that includes:
Medical
Dental
Vision
401(k)
Family Planning/Fertility Assistance
STD/LTD/Basic Life/AD&D
Legal-Aid Program
Employee Assistance Program (EAP)
Paid Time Off (PTO) – (11) Federal Holidays
Training and Development Opportunities
Your application submission will be considered for all potential employment opportunities with Chickasaw Nation Industries (CNI).
Apply Today

#J-18808-Ljbffr