The Bon Secours Mercy Health Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Bon Secours Mercy Health Business Intelligence Interview Guide

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


Getting ready for an Business Intelligence interview at Bon Secours Mercy Health? The Bon Secours Mercy Health Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

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

Overview

Bon Secours Mercy Health 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.

Bon Secours Mercy Health 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

Bon Secours Mercy Health Business Intelligence Interview Questions

At Bon Secours Mercy Health, we are dedicated to continually improving health care quality, safety and cost effectiveness. Our hospitals, care sites and clinicians are recognized for clinical and operational excellence.
**This is a** **remote/work from home** **opportunity. Remote work permitted anywhere in the U.S.**
**PRIMARY FUNCTION/GENERAL PURPOSE OF POSITION**
Bon Secours Mercy Health, Inc., headquartered in Cincinnati, OH, has an opening available for a Core Data Analyst. Residence & remote work permitted anywhere in the U.S. via telecommute. Report to HQ less than 25% to BSMH headquarter office.
The Core Data Analyst is responsible for translating and programming vast amounts of data into understandable, relevant, and actionable information. This role interfaces with business units across the ministry to provide business insights and design and deliver reports. This role is engaged in developing and promoting effective data governance through documentation and adherence of standards to ensure that the information produced is accurate and trusted as the source of truth.
**ESSENTIAL JOB FUNCTIONS**
+ Identify and understand, as well as acquire, merge, and transform data from a centralized data warehouse;
+ Translate data needs of the business to structure and provide recurring data extracts or develop custom solutions for a strategic problem;
+ Develop and document on-going maintenance of a data governance operation;
+ Develop effective auditing and validation processes between the source systems and the centralized data warehouse to ensure accurate and timely availability of data;
+ Develop, test, and deliver reports and extracts from the centralized data warehouse using appropriate Business Intelligence tools; and
+ Integrate data from multiple sources (e.g., public datasets, Excel reports, data warehouse) and work with cross-functional, agile teams to build and deliver solutions;
**EDUCATION**
Bachelors degree in Information Systems, Computer Science, Computer Engineering, or related field (foreign equivalent degree accepted).
**WORK EXPERIENCE**
+ 3 years of experience in a Business Analyst, Data Analyst, or closely related role
+ 3 years of experience in each of the following:
+ Delivering, testing and providing reports and extracts from data warehouse systems;
+ Utilizing power BI tools & tableau to develop data visualization and dashboards;
+ Data modeling concepts such as star-schema modeling, snowflake schema modeling, FACT and Dimension tables; and
+ Database platforms Oracle and SQL Server.
+ 1 year of experience designing and automating reports to aid in business decision making.
Experience may be gained concurrently.
#LI-DNI
Many of our opportunities reward* your hard work with:
Comprehensive, affordable medical, dental and vision plans
Prescription drug coverage
Flexible spending accounts
Life insurance w/AD&D
Employer contributions to retirement savings plan when eligible
Paid time off
Educational Assistance
And much more
*Benefits offerings vary according to employment status
All applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, sexual orientation, gender identity, age, genetic information, or protected veteran status, and will not be discriminated against on the basis of disability. If you'd like to view a copy of the affirmative action plan or policy statement for Mercy Health Youngstown, Ohio or Bon Secours Franklin, Virginia; Petersburg, Virginia; and Emporia, Virginia, which are Affirmative Action and Equal Opportunity Employers, please email recruitment@mercy.com . If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact The Talent Acquisition Team at recruitment@mercy.com

Bon Secours Mercy Health Business Intelligence Interview Guide

Overview

Bon Secours Mercy Health Business Intelligence Salary

Bon Secours Mercy Health Business Intelligence Interview Process

Bon Secours Mercy Health Business Intelligence Interview Questions

Bon Secours Mercy Health Business Intelligence Jobs