The Sutter Health Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Sutter Health Business Intelligence Interview Guide

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


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

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

Overview

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

Sutter 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 the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

<p><code>employees</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>

<tr>
<td><code>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Manager Team Sizes

<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

Sutter Health Business Intelligence Interview Questions

We are so glad you are interested in joining Sutter Health! <br><br><b>Organization:</b><br>SHSO-Sutter Health System Office-Valley<br><br><b>Position Overview:</b><br>This is a hybrid position and is required to work onsite in Sacramento Tuesday and Wednesday.<br><br>Provides support in making strategic data-related decisions by analyzing, manipulating, tracking, internally managing and reporting data from diverse internal and external sources. Requires collaboration with cross-functional teams to perform exploration and experimentation, designing and building prototypes and best practices for our applications. Brings insight and change to how we approach customers, patients, business leaders and partners to solve the most complex problems with analytics. Provides a wide-range of analytical results and have the ability to communicate these informed conclusions and recommendations across an organization's leadership structure.<br><br>•Develop and implement Data Science / AI solutions.<br>•Set enterprise-wide standards and processes for DS / Applied AI.<br>•Create and maintain end-to-end applied data science / artificial intelligence (including GenAI) solution architectures, tools, and infrastructure, to improve healthcare delivery and patient care outcomes.<br>•Use advanced mathematical, linguistic, geographic information systems and machine learning techniques to create and test DS models.<br>•Fine tune, validate, test, and apply foundational GenAI models. <br>•Developing distribution and integration mechanisms for model insights and outputs (APIs, reports, and dashboards) for stakeholders and downstream software applications.<br>•Mentor and develop other data scientists across the organization.<br><br><b>Job Description</b>:<br><br><b>EDUCATION:</b><br>Equivalent experience will be accepted in lieu of the required degree or diploma.<br><br>Master's: Computer Science, Statistics, Medical Informatics, Mathematics, or related field<br><br><b>TYPICAL EXPERIENCE:</b><br><br>8 years recent relevant experience.<br><br><b>SKILLS AND KNOWLEDGE:</b><br><br>Experience designing, implementing, and testing automated data analysis systems.<br><br>Proven ability to rationalize disparate data sources and the ability to intuit the insight from within a dataset.<br><br>Understanding and implementation of predictive / analytical / statistical modeling techniques, theories, principles, and practices.<br><br>Familiarity and experience with data preparation and processing - such as assessment of data quality, new variable creation/selection, etc.<br>able to interact with technical experts and leaders at all levels within the organization.<br><br>Self-starter, able to independently identify and complete critical tasks with minimal supervision, complex data, and dynamic goals.<br><br>Verbal and written communication skills are an absolute requirement.<br><br>Demonstrated ability to multitask and deliver on multiple projects concurrently.<br><br>Experience working in a team-oriented, collaborative environment.<br><br>Ability to mentor other data scientists working on common projects.<br><br>Knowledge of healthcare clinical care and business processes.<br><br><b>Job Shift</b>:<br>Days<br><br><b>Schedule:</b><br>Full Time<br><br><b>Shift Hours:</b><br>8<br><br><b>Days of the Week:</b><br>Monday - Friday<br><br><b>Weekend Requirements:</b><br>As Needed<br><br><b>Benefits:</b><br>Yes<br><br><b>Unions:</b><br>No<br><br>This position is work from home eligible.<br><br><b>Position Status: </b><br>Exempt<br><br><b>Weekly Hours:</b><br>40<br><br><b>Employee Status:</b><br>Regular<br><br><b>Number of Openings:</b><br>1<br><br>Sutter Health is an equal opportunity employer EOE/M/F/Disability/Veterans.<br><br>Pay Range is $64.84 to $97.26 / hour<br><br>The salary range for this role may vary above or below the posted range as determined by location. This range has not been adjusted for any specific geographic differential applicable by area where the position may be filled. Compensation takes into account several factors including but not limited to a candidate's experience, education, skills, licensure and certifications, department equity, training and organizational needs. Base pay is just one piece of the total rewards program offered by Sutter Health. Eligible roles also qualify for a comprehensive benefits package.

Sutter Health Business Intelligence Interview Guide

Overview

Sutter Health Business Intelligence Salary

Sutter Health Business Intelligence Interview Process

Sutter Health Business Intelligence Interview Questions

Sutter Health Business Intelligence Jobs