Prepare for and practice interview questions from Churchill downs.

Churchill downs Interview Questions

Churchill downs Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</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>

Write a query to randomly sample a row from a big table.

Random SQL Sample

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Churchill downs Salaries by Position

<h3>Job Description</h3><div>Job Description<div>SUMMARYThe Business Analyst – Audio Video (AV) Specialist will focus primarily on the operations, standardization of support processes and documentation related to Audio, Video (e.g. Outdoor LED Video Boards, Naked Eye 3D video Boards), Presentation & Conference room systems and IPTV systems. Their primary responsibility will be to work with local IT and corporate IT to ensure the enterprise AV systems across all of Churchill Downs Incorporated’s gaming sites in the USA are correctly implemented, maintained and have support processes defined and communicated. The ideal candidate has experience managing vendor relationships and maintaining an understanding of vendor support contracts and is comfortable setting-up metrics that allow CDI to measure and maintain a high levels of up-time for those systems. In an outage, the AV Specialist will work with the onsite and third-party support teams to restore service as quickly as possible. Utilizing their working knowledge of various applications within the AV space the AV Specialist will guide property operations and IT teams who may be new to the AV system’s space. This individual will write functional specification documents, test plans, training plans, deployment plans, and policies and procedures supporting AV operations and projects.ESSENTIAL DUTIES and RESPONSIBILITIES include the following:<ul><li>Responsible for documenting existing processes for AV support and building and maintaining a new process for defining a support structure for existing AV systems.</li><li>Continuously look for opportunities to standardize AV support processes and systems across all existing properties and future properties.</li><li>Facilitate meetings to discuss end-user requirements, status, issues, planning, training, and/or operational needs related to a facility AV system.</li><li>Maintain an equipment list with warranty/support agreement dates included for each property.</li><li>Work with vendors and the local IT teams to keep AV systems up to date and remediate any security vulnerabilities discovered.</li><li>Stay current on industry standards and practices within the AV industry to offer potential alternatives and upgrade options, mainly when replacement or installation of new systems is being considered.</li><li>Work with Local IT and vendors for issue monitoring and quick resolution.</li><li>Work with construction & vendor timelines to schedule vendors at the appropriate times to deliver systems when needed with minimal impact to the business.</li><li>Work with businesses to identify and improve business processes within the application's abilities.</li><li>Ensure the business is aware of system capabilities to better utilize available systems.</li><li>Responsible for timely and complete communications between the corporate IT team, vendors, and all property staff as needed.</li><li>Analyze the application needs and contribute to the design, structure, and maintenance of the systems and architecture.</li><li>Analyzes business and user needs, documentation of requirements, and translation into proper system requirement specifications.</li><li>Ability to plan, estimate, and schedule multiple tasks and develop detailed resource and project plans.</li><li>Possesses technical and AV industry knowledge of most phases of systems analysis and considers the business implications of applying technology to the current and future business environment.</li><li>Analyzes business requirements and defines information systems solutions to address complex business needs (requiring innovative and creative solutions and frequently involving multiple platforms, software, hardware, technologies, and tools).</li><li>Provides support to users in system and software administration and usage.</li><li>Communicate and coordinate maintenance schedules, backups, and downtime to users.</li><li>Additional duties as assigned.</li></ul>REGULATORY Ability to obtain racing and/or gaming licenses as required in any jurisdiction where CDI operates. The gaming industry is highly regulated and, as such, requires an extensive background check to obtain a license. Must be 21 years of age.EDUCATION and EXPERIENCE:<ul><li>Bachelor’s degree in Information Technology or equivalent experience.</li><li>Minimum 3 years of experience in Information Technology supporting AV systems.</li><li>Project Management background a plus.</li><li>Experience in gaming applications support preferred.</li><li>Experience understanding of major business processes within Gaming industry preferred.</li><li>Experience with planning, budgeting, and standard business processes preferred.</li></ul>REQUIRED SKILLS:<ul><li>Ability to articulate/demonstrate 2+ major IT/casino AV project implementations.</li><li>Minimum 3+ years of proven vendor relationship management experience.</li><li>Understanding of core ITIL processes (i.e. Incident, Request, Change Management).</li><li>Excellent interpersonal and communication skills (oral and written).</li><li>Support a 24/7 365 information systems environment.</li><li>Ability to manage multiple complex projects simultaneously according to agreed-upon schedules and budgets.</li><li>Strong attention to detail and prompt follow-up.</li></ul>PHYSICAL DEMANDS/ WORKING CONDITIONS:<ul><li>Extended periods of sitting at a desk and working on a computer.</li><li>Regular use of a keyboard and mouse for typing and navigating software.</li><li>Viewing a computer screen for prolonged periods.</li><li>Ability to manipulate paperwork, including filing, sorting, and organizing.</li><li>Moving within the office environment to attend meetings, use office equipment, or interact with colleagues.</li><li>Occasional lifting of office supplies or paperwork (up to 20 pounds).</li><li>Speaking and listening to colleagues and clients in person, over the phone, or via video conferencing.</li><li>Working in a climate-controlled office environment with moderate noise levels.</li><li>Performing repetitive tasks such as data entry or document preparation.</li><li>Working under artificial lighting conditions typical of an office environment, including fluorescent or LED lighting.</li></ul></div></div>

Churchill downs Interview Questions

Churchill downs Interview Guides

Churchill downs Interview Questions

Churchill downs Salaries by Position

Churchill downs Opening Jobs