Prepare for and practice interview questions from Sutter Health.

Sutter Health Interview Questions

Sutter Health 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?

Sutter Health Salaries by Position

We are so glad you are interested in joining Sutter Health! Organization: S3-Sutter Shared Services-Valley Position Overview: *This is a hybrid position required to work at the office in Sacramento two days per week. Creates complex database reports based on the specifications and/or requirements of end-users. Provides analytical and technical support for complex requests, projects, or initiatives. Is also responsible for participating in risk assessment and work plan development processes. Lastly, performs data validation to ensure reports are pulling all correct data accurately while achieving client needs as well as determining if programming is created and creates specifications for developers. *Workday analytics and reporting experience preferred. *Workday Prism and Extend experience is highly desired. Job Description: EDUCATION: [Equivalent experience will be accepted in lieu of the required degree or diploma] Bachelor's: Applied Statistics, Computer Analytics, Computer Science, Information Technology, Management Information Systems, or related field TYPICAL EXPERIENCE: 5 years recent relevant experience. SKILLS AND KNOWLEDGE: Proficient at understanding, communicating, and specifying user requirements. Working knowledge of industry standards in order to properly support business requirements. Technical skills in report writing and reporting tools. Establish and maintain cooperative working relationships with clients, IS team members, management, and executive personnel/staff. Verbal and writing skills to effectively communicate with diverse groups such as: executives, managers, and subject matter experts. Set priorities which accurately reflect the relative importance of job responsibilities and prioritize assignments to complete work in a timely manner. Analyze information, problems, situations, practices, or procedures in order to identify relevant concerns and factors. Perform a variety of duties and often change from one task to another of a different nature with frequent interruptions and/or distractions. Skilled in developing documentation at a technical and user level. Job Shift: Days Schedule: Full Time Shift Hours: 8 Days of the Week: Monday - Friday Weekend Requirements: None Benefits: Yes Unions: No Position Status: Non-Exempt Weekly Hours: 40 Employee Status: Regular Sutter Health is an equal opportunity employer EOE/M/F/Disability/Veterans. Pay Range is $48.72 to $73.08 / hour 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 Interview Questions

Sutter Health Interview Guides

Sutter Health Interview Questions

Sutter Health Salaries by Position

Sutter Health Opening Jobs