Prepare for and practice interview questions from The university of kansas health system.

The university of kansas health system Interview Questions

The university of kansas health system Interview Guides

<p>Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.</p>

<p>What factors could have biased this result, and what would you look into?</p>


<p>What could potentially bias the average boarding time in favor of an airline that only flies domestically?</p>

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Statistics

<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>The schema below is for a retail online shopping company consisting of two tables, <code>attribution</code> and <code>user_sessions</code>.</p>

<ul>
<li><p>The attribution table logs a session visit for each row.</p></li>

<li><p>If <code>conversion</code> is <code>true</code>, then the user converted to buying on that session.</p></li>

<li><p>The <code>channel</code> column represents which advertising platform the user was attributed to for that specific session.</p></li>

<li><p>Lastly the <code>user_sessions</code> table maps many to one session visits back to one user.</p></li>
</ul>

<p>First touch attribution is defined as the channel with which the converted user was associated when they first discovered the website.</p>

<p>Calculate the first touch attribution for each <code>user_id</code> that converted. </p>

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

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

<p><code>attribution</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>session_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>channel</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>conversion</code></td>
<td>BOOLEAN</td>
</tr>
</tbody>
</table>
<p><code>user_sessions</code> table</p>

<table>
<thead>
<tr>
<th>column</th>
<th>type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>session_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Example output:</strong></p>

<table>
<thead>
<tr>
<th><code>user_id</code></th>
<th><code>channel</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>123</td>
<td>facebook</td>
</tr>

<tr>
<td>145</td>
<td>google</td>
</tr>

<tr>
<td>153</td>
<td>facebook</td>
</tr>

<tr>
<td>172</td>
<td>organic</td>
</tr>

<tr>
<td>173</td>
<td>email</td>
</tr>
</tbody>
</table>


First Touch Attribution

<div><h2>Organ Transplant Business Analyst Bell Hospital</h2><p>The Business Analyst is a professional with knowledge in transplant or Medicare reimbursement. Able to work independently, applying specialized business acumen to perform functions or oversee charging, collections and administration of pre transplant accounts and department budgets. Understands and reviews all process for charging, billing and getting paid for transplant services.</p><p><strong>Responsibilities and Essential Job Functions</strong></p><ul><li>Accounting and Payment of Organ Acquisition Expenses. Enters charges or assures charging to the patient account for organ acquisition fee at the time of transplant. Review of the pre transplant hospital services bulk account that accumulates organ acquisition facility charges to assure these are organ acquisition expenses. Move out and get sent for billing any expenses in the bulk account in error.</li><li>Continuous oversight of billing and collections for process improvement opportunities.</li><li>Keeps current on reimbursement changes. Reconciles month end financial reports. Reconciles clinic charges daily in SMS and Epic.</li><li>Manages calls and questions related to outstanding invoices and payment amounts. Monthly review of all transplant department cost center accounts to assure appropriate allocation of pre transplant, post transplant and non transplant expenses.</li><li>Manages fiscal variables and investigates status of billing and collections of transplant patient accounts</li><li>Monitors monthly department reports on payments received on transplant patient accounts and works with patient financial services on any denials, lack of payment or limited payment problems. Serves as contact point to resolve account errors with the financial coordinator and patient financial services.</li><li>Pays invoices for medical specialists and outside hospital facility fees based on negotiated rates from the acquisition cost centers after validating these expenses are related to the evaluation and part of the evaluation protocol.</li><li>Tracking of number and type of organs donated and provided to the organ procurement organization. Keeps and provides records to cost accounting for annual filing of Medicare report.</li><li>Works with clinical staff and other managers to understand and explain variances from budget. Completes monthly variance analysis on continuous financial planning reports. Provides monthly accruals to finance in a timely manner.</li><li>Must be able to perform the professional, clinical and or technical competencies of the assigned unit or department.</li><li>These statements are intended to describe the essential functions of the job and are not intended to be an exhaustive list of all responsibilities. Skills and duties may vary dependent upon your department or unit. Other duties may be assigned as required.</li></ul><p><strong>Required Education and Experience</strong></p><ul><li>Associates Degree or above</li></ul><p><strong>Preferred Education and Experience</strong></p><ul><li>Bachelors Degree in Business or Accounting</li></ul><p>We are an equal employment opportunity employer without regard to a person's race, color, religion, sex (including pregnancy, gender identity and sexual orientation), national origin, ancestry, age (40 or older), disability, veteran status or genetic information.</p></div>

Question	Topic	Difficulty	Ask Chance
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High
First Touch Attribution	SQL	Hard	Very High

The university of kansas health system Interview Questions

The university of kansas health system Interview Guides

The university of kansas health system Interview Questions

The university of kansas health system Opening Jobs