The Horizon Media Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Horizon Media Business Intelligence Interview Guide

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


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

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

Overview

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

Horizon Media 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 identify customers who placed more than three transactions each in both 2019 and 2020.</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>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>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

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


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


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

Customer Orders

<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

Horizon Media Business Intelligence Interview Questions

This position is embedded with Lionsgate, requiring 4 days/week in the office (Monday-Thursday).
Overview:
We are seeking an experienced and detail-oriented Data Analyst to support Lionsgate’s Motion Picture Group by leveraging data to drive key business decisions. In this role, you will collaborate closely with senior leadership to gather, process, and analyze a wide array of data sources. Your contributions will play a pivotal role in shaping data-driven strategies, optimizing performance, and delivering actionable insights through clear visualizations. This position is ideal for a professional with strong analytical skills who is ready to take ownership of data processes and make impactful business contributions within the entertainment industry.
Key Responsibilities:
Gather, clean, and organize data from various internal and external sources.
Assist in maintaining and updating databases and data systems.
Perform basic data validation and quality checks to ensure data accuracy.
Use statistical methods and tools to support business reporting and decision-making.
Assist in the creation of dashboards and reports to visualize data insights using tools including Excel, Tableau, and Looker.
Assist in the preparation of regular reports for management and various departments.
Develop and maintain dashboards, reports, and visualizations to help other departments monitor campaign health and performance.
Write basic SQL queries to extract relevant data for analysis.
Work closely with other teams or departments to understand their data needs and provide accurate insights.
Assist in developing processes for automating data tasks and workflows.
Ensure data integrity and accuracy in all reports and presentations.
Required Qualifications:
Bachelor’s degree in Data Science, Mathematics, Statistics, Computer Science, Economics, or a related field.
Familiarity with data manipulation and visualization tools, preferably Tableau.
Basic understanding of SQL for querying databases.
Proficiency in Microsoft Excel, including pivot tables, charts, and advanced formulas.
Strong analytical and problem-solving skills.
Strong attention to detail and organizational skills.
Good communication skills with the ability to present data insights clearly.
Willingness to learn and take on new challenges.
Ability to work independently as well as part of a collaborative team.
Prior entry-level or higher experience in data analysis or related fields.
Salary Range:   $70,000.00 - $85,000.00
Horizon Media is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.

#J-18808-Ljbffr

Job Title:  Lead Business Analyst - Banking Domain
Location : Minneapolis, MN
Duration : Contract
Job Description:
Strong knowledge and hands-on experience in Order Management & Customer Data Management.
Document business needs and features.
Document As-Is and To-Be business processes.
Facilitate User Story grooming sessions and create user stories.
Identify and document business and technical requirements for various features.
Conduct data analysis and data mapping on various features.
Create and maintain streamlined documentation for all service efforts, including design documents, business/system process flows, source data mapping, stored procedures used by APIs, session log events, and test support documentation.
Document UAT test scenarios, conduct UAT testing, and facilitate UAT training sessions.
Job Type:  Contract
Work Location:  In person

#J-18808-Ljbffr

<p><u><i><b>This position is embedded with Lionsgate, requiring 4 days/week in the office (Monday-Thursday). </b> </i> </u> </p><p><b>Overview: </b> </p><p>We are seeking an experienced and detail-oriented Data Analyst to support Lionsgate’s Motion Picture Group by leveraging data to drive key business decisions. In this role, you will collaborate closely with senior leadership to gather, process, and analyze a wide array of data sources. Your contributions will play a pivotal role in shaping data-driven strategies, optimizing performance, and delivering actionable insights through clear visualizations. This position is ideal for a professional with strong analytical skills who is ready to take ownership of data processes and make impactful business contributions within the entertainment industry. </p><p><b>Key Responsibilities: </b> </p><ul><li>Gather, clean, and organize data from various internal and external sources. </li><li>Assist in maintaining and updating databases and data systems. </li><li>Perform basic data validation and quality checks to ensure data accuracy. </li><li>Use statistical methods and tools to support business reporting and decision-making. </li><li>Assist in the creation of dashboards and reports to visualize data insights using tools including Excel, Tableau, and Looker. </li><li>Assist in the preparation of regular reports for management and various departments. </li><li>Develop and maintain dashboards, reports, and visualizations to help other departments monitor campaign health and performance. </li><li>Write basic SQL queries to extract relevant data for analysis. </li><li>Work closely with other teams or departments to understand their data needs and provide accurate insights. </li><li>Assist in developing processes for automating data tasks and workflows. </li><li>Ensure data integrity and accuracy in all reports and presentations. </li> </ul><p><b>Required Qualifications: </b> </p><ul><li>Bachelor’s degree in Data Science, Mathematics, Statistics, Computer Science, Economics, or a related field. </li><li>Familiarity with data manipulation and visualization tools, preferably Tableau. </li><li>Basic understanding of SQL for querying databases. </li><li>Proficiency in Microsoft Excel, including pivot tables, charts, and advanced formulas. </li><li>Strong analytical and problem-solving skills. </li><li>Strong attention to detail and organizational skills. </li><li>Good communication skills with the ability to present data insights clearly. </li><li>Willingness to learn and take on new challenges. </li><li>Ability to work independently as well as part of a collaborative team. </li><li>Prior entry-level or higher experience in data analysis or related fields. </li> </ul><p><b><u>Salary Range: </u> </b> $70,000.00 - $85,000.00 </p><p><i>Horizon Media is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. </i> </p>#J-18808-Ljbffr

<b>Job Description</b> <br><br><b>This position is embedded with Lionsgate, requiring 4 days/week in the office (Monday-Thursday).</b> <br><br><b>Overview:</b> <br><br>We are seeking an experienced and detail-oriented Data Analyst to support Lionsgate's Motion Picture Group by leveraging data to drive key business decisions. In this role, you will collaborate closely with senior leadership to gather, process, and analyze a wide array of data sources. Your contributions will play a pivotal role in shaping data-driven strategies, optimizing performance, and delivering actionable insights through clear visualizations. This position is ideal for a professional with strong analytical skills who is ready to take ownership of data processes and make impactful business contributions within the entertainment industry. <br><br><b>Key Responsibilities:</b> <br><ul> <li>Gather, clean, and organize data from various internal and external sources. </li><li>Assist in maintaining and updating databases and data systems. </li><li>Perform basic data validation and quality checks to ensure data accuracy. </li><li>Use statistical methods and tools to support business reporting and decision-making. </li><li>Assist in the creation of dashboards and reports to visualize data insights using tools including Excel, Tableau, and Looker. </li><li>Assist in the preparation of regular reports for management and various departments. </li><li>Develop and maintain dashboards, reports, and visualizations to help other departments monitor campaign health and performance. </li><li>Write basic SQL queries to extract relevant data for analysis. </li><li>Work closely with other teams or departments to understand their data needs and provide accurate insights. </li><li>Assist in developing processes for automating data tasks and workflows. </li><li>Ensure data integrity and accuracy in all reports and presentations. </li></ul><b>Required Qualifications:</b> <ul> <li>Bachelor's degree in Data Science, Mathematics, Statistics, Computer Science, Economics, or a related field. </li><li>Familiarity with data manipulation and visualization tools, preferably Tableau. </li><li>Basic understanding of SQL for querying databases. </li><li>Proficiency in Microsoft Excel, including pivot tables, charts, and advanced formulas. </li><li>Strong analytical and problem-solving skills. </li><li>Strong attention to detail and organizational skills. </li><li>Good communication skills with the ability to present data insights clearly. </li><li>Willingness to learn and take on new challenges. </li><li>Ability to work independently as well as part of a collaborative team. </li><li>Prior entry-level or higher experience in data analysis or related fields. </li></ul> <br><br>#LI-TH1 <br><br>#LI-HYBRID <br><br>Horizon Media is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. <br><br><b>Salary Range</b> <br>$70,000.00 - $85,000.00 <br><br>A successful applicant's actual base salary may vary based upon, but not limited to, skill sets, experience and training, licensure/certifications, and equity. As an organization, we take an aptitude and competency-based hiring approach. We provide a competitive total rewards package including a discretionary bonus and a variety of benefits including health insurance coverage, life and disability insurance, retirement savings plans, company paid holidays and unlimited paid time off (PTO), mental health and wellness resources, pet insurance, childcare resources, identity theft insurance, fertility assistance programs, and fitness reimbursement.

<b>Job Description</b><br><br><b>This position is embedded with Lionsgate, requiring 4 days/week in the office (Monday-Thursday).</b><br><br><b>Overview:</b><br><br>We are seeking an experienced and detail-oriented Data Analyst to support Lionsgate's Motion Picture Group by leveraging data to drive key business decisions. In this role, you will collaborate closely with senior leadership to gather, process, and analyze a wide array of data sources. Your contributions will play a pivotal role in shaping data-driven strategies, optimizing performance, and delivering actionable insights through clear visualizations. This position is ideal for a professional with strong analytical skills who is ready to take ownership of data processes and make impactful business contributions within the entertainment industry.<br><br><b>Key Responsibilities:</b><br><ul><li>Gather, clean, and organize data from various internal and external sources.</li><li>Assist in maintaining and updating databases and data systems.</li><li>Perform basic data validation and quality checks to ensure data accuracy.</li><li>Use statistical methods and tools to support business reporting and decision-making.</li><li>Assist in the creation of dashboards and reports to visualize data insights using tools including Excel, Tableau, and Looker.</li><li>Assist in the preparation of regular reports for management and various departments.</li><li>Develop and maintain dashboards, reports, and visualizations to help other departments monitor campaign health and performance.</li><li>Write basic SQL queries to extract relevant data for analysis.</li><li>Work closely with other teams or departments to understand their data needs and provide accurate insights.</li><li>Assist in developing processes for automating data tasks and workflows.</li><li>Ensure data integrity and accuracy in all reports and presentations.</li></ul><br><br><b>Required Qualifications:</b><br><ul><li>Bachelor's degree in Data Science, Mathematics, Statistics, Computer Science, Economics, or a related field.</li><li>Familiarity with data manipulation and visualization tools, preferably Tableau.</li><li>Basic understanding of SQL for querying databases.</li><li>Proficiency in Microsoft Excel, including pivot tables, charts, and advanced formulas.</li><li>Strong analytical and problem-solving skills.</li><li>Strong attention to detail and organizational skills.</li><li>Good communication skills with the ability to present data insights clearly.</li><li>Willingness to learn and take on new challenges.</li><li>Ability to work independently as well as part of a collaborative team.</li><li>Prior entry-level or higher experience in data analysis or related fields.</li></ul><br><br>#LI-TH1<br><br>#LI-HYBRID<br><br>Horizon Media is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.<br><br><b>Salary Range</b><br>$70,000.00 - $85,000.00<br><br>A successful applicant's actual base salary may vary based upon, but not limited to, skill sets, experience and training, licensure/certifications, and equity. As an organization, we take an aptitude and competency-based hiring approach. We provide a competitive total rewards package including a discretionary bonus and a variety of benefits including health insurance coverage, life and disability insurance, retirement savings plans, company paid holidays and unlimited paid time off (PTO), mental health and wellness resources, pet insurance, childcare resources, identity theft insurance, fertility assistance programs, and fitness reimbursement.

Horizon Media Business Intelligence Interview Guide

Overview

Horizon Media Business Intelligence Salary

Horizon Media Business Intelligence Interview Process

Horizon Media Business Intelligence Interview Questions

Horizon Media Business Intelligence Jobs