The Churchill downs Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Churchill downs Business Intelligence Interview Guide

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


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

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

Overview

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

Churchill downs Business Intelligence Interview Process

<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>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

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

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

<p><strong><code>players</code></strong> table</p>

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

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

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


Obtain count of players based on games played.

Player Analysis

<p>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

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

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

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

Churchill downs Business Intelligence Interview Questions

Join to apply for the  Data Architect  role at  Churchill Downs Incorporated
1 day ago Be among the first 25 applicants
Join to apply for the  Data Architect  role at  Churchill Downs Incorporated
Get AI-powered advice on this job and more exclusive features.
About Churchill Downs Inc.

Headquartered in Louisville, Kentucky, Churchill Downs Incorporated has expanded through the development of live and historical racing entertainment venues, the growth of the TwinSpires horse racing online wagering business and the operation and development of regional casino gaming properties. Churchill Downs Incorporated is an inclusive and fun place to work. We celebrate unique approaches and points of view. We believe diversity is a mindset that drives excellence. We’re always learning, evolving and growing. We innovate through mutual respect of ideas and collaboration. This allows us to build a common language that inspires our team members and propels us toward the achievement of our vision.
Title: Data Architect

Requisition ID#: 587

Location:

Louisville, KY, US, 40222

Property: Churchill Downs Incorporated

Pay Range: Market Competitive

About Churchill Downs Inc.

Headquartered in Louisville, Kentucky, Churchill Downs Incorporated has expanded through the development of live and historical racing entertainment venues, the growth of the TwinSpires horse racing online wagering business and the operation and development of regional casino gaming properties. Churchill Downs Incorporated is an inclusive and fun place to work. We celebrate unique approaches and points of view. We believe diversity is a mindset that drives excellence. We’re always learning, evolving and growing. We innovate through mutual respect of ideas and collaboration. This allows us to build a common language that inspires our team members and propels us toward the achievement of our vision.

CHURCHILL DOWNS INCORPORATED

Churchill Downs Incorporated is an industry-leading racing, online wagering and gaming entertainment company anchored by our iconic flagship event - The Kentucky Derby. We own and operate Derby City Gaming, a historical racing machine facility in Louisville, Kentucky. We also own and operate the largest online horse racing wagering platform in the U.S., TwinSpires.com.. We are also a leader in brick-and-mortar casino gaming with approximately 11,000 slot machines and video lottery terminals and 200 table games in eight states. Apply today!

Job Summary

We are seeking a skilled Data Architect/Modeler to design and implement extensible data solutions that bridge the gap between business strategy and technical execution. This role plays a critical part in ensuring our data is accessible, scalable, and aligned with reporting and analytics needs.

You will balance strategic planning and hands-on work, driving solution design, data modeling, and requirements gathering while also working directly with data using SQL and other technologies. Your work will shape how business teams’ access and utilize data, influencing key decisions and long-term data infrastructure strategy.

Additionally, your contributions will be instrumental in evolving our reporting ecosystem, supporting the growth of our self-serve business analytics and providing the foundation for machine learning (ML), and structured data LLM projects. This is a high-impact role with significant influence over the future of our data landscape.

Our Team

We are an Agile Scrum team composed of 6 Data Engineers, 3 QA Analysts, 3 Front-End Developers, a System Administrator, a Product Owner, and a Scrum Master. Over the past few years, we’ve steadily expanded to support the rapid growth of our terrestrial (brick and mortar) gaming business, which continues to scale through both organic expansion and acquisitions.

We recently transitioned our data engineering layer to Snowflake and dbt, establishing a scalable foundation for data processing and transformation. While we currently utilize an on-premise MicroStrategy environment with a robust semantic layer, we are actively exploring modern cloud-based BI solutions to expand and enhance our reporting capabilities.

This is an exciting time to join our team, as we continue to push the boundaries of cloud-based data solutions and drive meaningful innovation across the organization.

This role is perfect for someone who enjoys  solving complex data challenges , balancing business and technical constraints, and driving strategic data initiatives forward.

Essential Duties And Responsibilities

Collaborate with stakeholders (BI developers, product owners, analysts, and leadership) to define data accessibility and usability requirements for reporting and analytics.
Effectively communicate with both technical and non-technical audiences—translating complex data concepts into simple, business-friendly terms. Create artifacts and processes in direct support of implementation and provide oversite to other developers implementing the design.
Design and implement data models, define relationships between entities and ensuring data normalization for extensibility in both the data and reporting layers.
Collaborate within the development team to ensure that the logical and conceptual data models you produce are implemented effectively in front front-end structures (e.g., semantic layers, cubes).
Evaluate and communicate trade-offs between different data architecture approaches to stakeholders and developers.
Develop and refine semantic models to support business reporting objectives.
Provide thought leadership on balancing scalability, efficiency, and speed to market.
Create prototypes and mockups to facilitate stakeholder feedback and ensure alignment between business goals and technical execution.
Map business processes to data structures, visualizing how data flows through the organization.
Ensure that data models are flexible and scalable to accommodate future business needs.

Education And Experience

Bachelor's or Master’s in Computer Science, Data Science, Information Systems, or a related field.
5+ years designing conceptual, logical, and physical data models.
Strong knowledge of normalization, dimensional modeling, and data warehousing best practices.
Experience iteratively expanding large and complex data models
Experience with a modern cloud-based data platform (e.g., Snowflake, Redshift, BigQuery, or Azure Synapse).
Hands-on experience with ETL/ELT tools (e.g., dbt, Azure data factory, Informatica, Talend, Fivetran).
Experience with Semantic modeling in BI or AI platforms.
Familiarity with BI tools like MicroStrategy, Sigma, Tableau, Power BI, Looker, or ThoughtSpot.
Knowledge of data governance best practices

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability.

Work With Us

Churchill Downs Incorporated is an inclusive and fun place to work. We celebrate unique approaches and points of view. We believe diversity is a mindset that drives excellence. We’re always learning, evolving and growing. We innovate through mutual respect of ideas and collaboration. This allows us to build a common language that inspires our team members and propels us toward the achievement of our vision.

Already Work Here?

Here's a Link To Apply Internally

Employee Login

Nearest Major Market:  Louisville
Seniority level    Seniority level Mid-Senior level
Employment type    Employment type Full-time
Job function    Job function Engineering and Information Technology
Industries Entertainment Providers
Referrals increase your chances of interviewing at Churchill Downs Incorporated by 2x
Louisville, KY $150,000.00-$200,000.00 1 week ago
Interdisciplinary (Engineer/Architect) - LRL001.  Louisville, KY $73,939.00-$115,213.00 3 months ago
Louisville, KY $200,000.00-$220,000.00 1 week ago
Principal Cloud Database Administrator and Architect  Integrated Justice Architect - Government Sector - Manager - Consulting - Location Open  Louisville, KY $141,200.00-$258,900.00 1 week ago
Data Engineer - Industrials & Energy Sector - Senior Manager - Consulting - Location Open  Louisville, KY $142,600.00-$325,800.00 15 hours ago
Senior Staff Engineer - Finance Data Specialist (Remote)  Louisville, KY $115,000.00-$260,000.00 1 day ago
Kinaxis Integration Lead Specialist Master  Louisville, KY $130,800.00-$241,000.00 6 days ago
Cyber Identity - Data Privacy Senior Consultant  Louisville, KY $118,700.00-$218,600.00 1 week ago
Louisville, KY $1.00-$450,000.50 1 week ago
Principal Data Engineer, Sourcing Transformation  Louisville, KY $140,000.00-$185,000.00 1 week ago
Staff Engineer - Finance Data Specialist (Remote)  Louisville, KY $115,000.00-$260,000.00 1 day ago
Louisville, KY $80,485.00-$154,755.00 1 week ago
Louisville, KY $60,000.00-$100,000.00 4 hours ago
Louisville, KY $90,000.00-$160,000.00 4 days ago
Louisville, KY $101,500.00-$186,000.00 1 week ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

Churchill downs Business Intelligence Interview Guide

Overview

Churchill downs Business Intelligence Interview Process

Churchill downs Business Intelligence Interview Questions

Churchill downs Business Intelligence Jobs