The Niagara Bottling Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Niagara Bottling Business Intelligence Interview Guide

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


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

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

Overview

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

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

You’ve been asked to analyze the player’s behaviors at a gaming company.

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.

Example:

Input:

<code>players</code> table

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

<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

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

Niagara Bottling Business Intelligence Interview Questions

At Niagara, were looking for Team Members who want to be part of achieving our mission to provide our customers the highest quality most affordable bottled water.Consider applying here, if you want to:Work in an entrepreneurial and dynamic environment with a chance to make an impact.Develop lasting relationships with great people.Have the opportunity to build a satisfying career.We offer competitive compensation and benefits packages for our Team Members.Sr. Data Engineer - (Snowflake & Databricks)As a key member of our team, the Senior Business Intelligence (BI) Developer will be responsible for designing, developing, implementing, and supporting essential enterprise Business Intelligence solutions. The ideal candidate will possess a strong background in data integration, ETL processes, and business intelligence to deliver scalable and efficient data solutions. This role involves collaborating with cross-functional teams to gather requirements and leveraging skills and experience to create end-to-end solutions, from data acquisition and modeling to reporting and visualization. The candidate will continuously assess and adopt new technologies, methodologies and practices to enhance data processing capabilities. This position is crucial in ensuring high-quality data operations and providing valuable insights to support the organizations decision-making processes.Design, develop, and maintain robust ETL processes to extract, transform, and load data from various sources into our data warehouseCollaborate with analysts and BI developers to design and implement data models that support reporting and analytical requirementsMonitor and optimize ETL jobs for performance, reliability, and scalability, implementing best practices for data processingEnsure high levels of data quality and integrity through data validation, cleansing, and transformation processesImplement data governance best practices to maintain data accuracy and compliance with organizational standardsTroubleshoot and resolve ETL job failures and data quality issues, documenting solutions and maintaining technical documentationParticipate in business meetings to gather requirements and translate them into technical specifications for ETL/data pipelines and data modelsProvide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal usersEnsure proper configuration management and change controls are implementedWork closely with offshore team(s) and participate in scrum callsProvide technical assistance and cross training to other team membersDesign and implement technology best practices, guidelines and repeatable processesUnderstand Data Sources and Data Modeling concepts to develop and enhance the existing Data WarehouseUnderstand normalized and star-schema physical models and logical modeling conceptsCollaborate with Oracle ERP Analyst to identify and resolve data quality issuesParticipate and handle full Software Development Life Cycle (SDLC)Coach/mentor other team members as appropriate to facilitate their professional developmentPlease note that this job description is not designed to contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without prior noticeWork ExperienceRequired:7-10 years experience in Cloud databases like Snowflake, Delta Lake, Big Query, Oracle ADW7-10 years E xperience Tools like Databricks/Azure Data Factory, INCORTA5-7 years Experience with Data Modeling, Data Mart design, Data Pipeline/ETL Architecture5-7 years Experience in troubleshooting and resolving issues in ETL jobs and BI solutions3-5 years Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM processes and data elements3-5 years E xperience in performance tuning of ETL process, Reports/Dashboards2-4 years Experience with cloud platforms like OCI, Microsoft Azure, Google Cloud Platform2-4 years E xperience with PL/SQL to support ETL processes2-4 years Experience with Data Analysis using Python or R programming0-2 year(s) Experience in Oracle Analytics Cloud Services (OACS) or PowerBIPreferred:10+ years experience in Cloud databases like Snowflake, Delta Lake, Big Query, Oracle ADW10+ years e xperience with tools like Databricks/Azure Data Factory, INCORTA10+ years E xperience in designing and building complex Data Pipelines7-10 years Experience with Data Modeling, Data Mart design, ETL Architecture7-10 years Experience in troubleshooting and resolving issues in ETL jobs and BI solutions5-7 years Experience in understanding Finance, Supply Chain, Manufacturing, Procurement and EAM modules of an ERP application3-5 years E xperience in performance tuning of ETL process, reports/dashboards3-5 years E xperience with PL/SQL to support ETL processes3-5 years Experience with Java programming2-4 years Experience in understanding Fusion ERP cloud, OTM cloud, WMS (Manhattan)2-4 years Experience in Oracle Hyperion/EPM2-4 years Experience in Oracle Analytics Cloud Services (OACS) or PowerBI0-2 year(s) Experience with MapViewer and geospatial analysis0-2 year(s) Experience using Oracle Data Mining to create predictive modelsCompetenciesStrong analytical and problem-solving skills with the ability to troubleshoot complex issuesExcellent communication and interpersonal skills to work with cross-functional teams and business stakeholdersAbility to manage multiple tasks and priorities in a fast-paced environmentAttention to detail and a commitment to delivering high-quality, error-free data solutionsA strong sense of ownership and accountability, promptly notifying management of any issues that affect his/her ability to accomplish planned goalsProven leadership qualitiesFosters a sense of pride within the team and encourages individuals to take pride in their accomplishmentsEducationMinimum Required:Bachelor's Degree in Computer Science or EngineeringPreferred:Master's Degree in Computer Science or EngineeringCertification/License:Required: None RequiredPreferred: Oracle Business Intelligence Foundation Suite 11g/12cTypical Compensation RangePay Rate Type: Salary$107,143.99 - $150,001.60 / YearlyBenefitshttps://careers.niagarawater.com/us/en/benefitsLos Angeles County applicants only * Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers, the California Fair Chance Act, and any other applicable local and state laws.Any employment agency, person or entity that submits a rsum into this career site or to a hiring manager does so with the understanding that the applicant's rsum will become the property of Niagara Bottling, LLC. Niagara Bottling, LLC will have the right to hire that applicant at its discretion without any fee owed to the submitting employment agency, person or entity.Employment agencies that have fee agreements with Niagara Bottling, LLC and have been engaged on a search shall submit rsum to the designated Niagara Bottling, LLC recruiter or, upon authorization, submit rsum into this career site to be eligible for placement fees.Niagara Bottling, LLC has been family owned and operated since 1963. Niagara is a leading bottled water manufacturer in the U.S., supplying major retailers across the nation. With incredible growth over the past several years, the career possibilities at Niagara are endless!Niagaras culture is fast-paced, innovative and intensely collaborative. Our Team Members are passionate, driven and always find a way to get the job done. We work hard and play hard while staying true to our family atmosphere.From competitive benefits and retirement options to educational reimbursements, ongoing training courses and exciting career advancement opportunities, at Niagara we truly take care of our Team Members.We hope that you consider joining our Niagara family!Niagara Bottling LLC is an Equal Opportunity Employer that does not discriminate on the basis of race, color, religion, sex, age, sexual orientation, gender identity and/or expression, national origin, veteran status or disability in relation to our recruiting, hiring, and promoting practices.

Niagara Bottling Business Intelligence Interview Guide

Overview

Niagara Bottling Business Intelligence Salary

Niagara Bottling Business Intelligence Interview Process

Niagara Bottling Business Intelligence Interview Questions

Niagara Bottling Business Intelligence Jobs