Prepare for and practice interview questions from Franciscan St. Francis Health.

Franciscan St. Francis Health Interview Questions

Franciscan St. Francis Health Interview Guides

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</code> table</p>

<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

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

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?

<p>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.</p>

<p>The company has been consistently growing new users in the city from January to March.</p>

<p>What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?</p>


<p>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?</p>

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?

Franciscan St. Francis Health Salaries by Position

<p>Flexible Work LocationFlexible Work Location Flexible Work Location, Indiana 46544Candidates need to live within one hour radius of a Franciscan Campus. Central and Western Indiana. NW Indiana. Southern Michigan. WHO WE AREWith 12 ministries and access points across Indiana and Illinois, Franciscan Health is one of the largest Catholic health care systems in the Midwest. Franciscan Health takes pride in hiring coworkers that provide compassionate, comprehensive care for our patients and the communities we serve.EpicCare Ambulatory Certified PreferredWHAT YOU CAN EXPECTProvide on-call support, including after-hours support, for team and customers following the Franciscan Alliance support model.Collect information regarding potential system enhancement needs.Troubleshoot and repair customer-reported application problems.Work with vendors in implementing, upgrading, supporting and troubleshooting applications.Follow organizational practices for incident, change and requests management.Act as a Franciscan Alliance applications expert to assist with the creation of training programs.Research, analyze, and present information regarding potential system enhancement needs.Document and build workflow, standards, and business processes to facilitate knowledge sharing within and across teams.Facilitate business user discussions to identify the requirements for Franciscan Alliance applications functionality and workflow.Maintain and configure the application parameters to ensure Franciscan Alliance applications function according to customers' specifications.QUALIFICATIONSRequired High School Diploma/GEDPreferred Associate's DegreePreferred Bachelor's Degree2 years Relevant Work Experience (unless promotional criteria can be met) Required3 years Relevant Work Experience PreferredEPIC Certified (if required by role) - EPICTRAVEL IS REQUIRED:Never or RarelyEQUAL OPPORTUNITY EMPLOYERIt is the policy of Franciscan Alliance to provide equal employment to its employees and qualified applicants for employment as otherwise required by an applicable local, state or Federal law.Franciscan Alliance reserves a Right of Conscience objection in the event local, state or Federal ordinances that violate its values and the free exercise of its religious rights.Franciscan Alliance is committed to equal employment opportunity.</p>

Franciscan St. Francis Health Interview Questions

Franciscan St. Francis Health Interview Guides

Franciscan St. Francis Health Interview Questions

Franciscan St. Francis Health Salaries by Position

Franciscan St. Francis Health Opening Jobs