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

Wellpath Business Intelligence Interview Guide

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


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

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

Overview

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

Wellpath 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

Wellpath Business Intelligence Interview Questions

<br></br><strong>You Matter</strong>:<br/><p style="margin: 0px;"> Make a difference every day in the lives of the underserved<br /> Join a mission driven organization with a people first culture<br /> Excellent career growth opportunities</p><p style="margin: 0px;"><br /><strong>Join us and find a career that supports:</strong><br /> Caring for overlooked, underserved, and vulnerable patients<br /> Diversity, equity, inclusion, and belonging<br /> Autonomy in a warm team environment<br /> Growth and training</p><p style="margin: 0px;"> </p><p style="margin: 0px;"><strong>Perks and Benefits</strong> <br />In addition to comprehensive benefits including medical, dental, vision, paid time off, and 401k, we foster a work, life balance for team members and their family to support physical, mental, and financial wellbeing including: <br /> DailyPay, receive your money as you earn it! <br /> Tuition Assistance and dependent Scholarships<br /> Employee Assistance Program (EAP) including free counseling and health coaching<br /> Company paid life insurance<br /> Tax free Health Spending Accounts (HSA)<br /> Wellness program featuring fitness memberships and product discounts<br /> Preferred banking partnership and discounted rates for home and auto loans</p><p style="margin: 0px;"> </p><p style="margin: 0px;"><span style="font-size: 8pt;">*Eligibility for perks and benefits varies based on employee type and length of service. </span></p><br/><br/><br></br><strong>Why Us</strong>:<br/><p style="margin: 0px;"><strong><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;">Now is your moment to make a difference in the lives of the underserved.</span></strong></p><p style="margin: 0px;"><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;">If there is one unifying characteristic of everyone on our team, it is the deep desire to make a difference by helping society's most vulnerable and often overlooked individuals. Every day we have the distinct honor and responsibility to show up with non-judgmental compassion to provide hope and healing to those who need it most. For those whose calling it is to serve others, now is your moment to join our mission to provide quality care to every patient with compassion, collaboration, and innovation, to live our mantra to Always Do The Right Thing!, and to collectively do our part to heal the world, one patient at a time.</span></p><p style="margin: 0px;"><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;"> </span></p><p style="margin: 0px;"><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;">Wellpath sees hundreds of thousands of unique individuals in their facilities month over month and a very large percent of those individuals receive direct clinical care, which includes lives saved by Narcan.  </span></p><p style="margin: 0px;"><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;"> </span></p><p style="margin: 0px;"><span style="font-size: 9.0pt; font-family: 'Verdana',sans-serif;">We offer ongoing training and development opportunities for licensed and unlicensed healthcare team members, and have best in class clinical resources for training, education, and point of care support. </span></p><br/><br/><br></br><strong>How you make a difference</strong>:<br/><p style="margin: 0px;"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">The pricing analyst has the responsibility developing estimates of cost elements and pricing for contract proposals, contract amendments, contract renewals, and new business ventures.</span></p><br/><br/><br></br><strong>Key Responsibilities</strong>:<br/><ul><li>Prepare comprehensive cost estimates and pricing for contract proposals, renewals, and new business ventures.</li><li>Ensure adherence to cost and pricing standards across different business lines.</li><li>Analyze past performance through "look-back" analyses, identifying areas for improvement.</li><li>Foster a culture of critical thinking and challenge the status quo to enhance pricing strategies.</li><li>Manage projects independently, collaborating with various departments, and maintain accurate cost databases.</li></ul><br/><br/><br></br><strong>Qualifications & Requirements</strong>:<br/><p style="margin: 0px;">Education</p><ul><li>Accounting or Finance degree required</li></ul><p style="margin: 0px;">Experience</p><ul><li>Related costing experience in a healthcare or staffing setting preferred;</li><li>Experience in a correctional healthcare environment highly desirable</li></ul><p style="margin: 0px;">Licenses/Certifications</p><ul><li>None required</li></ul><br/><br/><br></br><strong>We are an Equal Employment Opportunity / Affirmative Action Employer</strong>:<br/><p style="margin: 0px;">We celebrate diversity and are committed to creating an inclusive environment for all employees.</p><p style="margin: 0px;"> </p><p style="margin: 0px;"><strong>We encourage you to apply!</strong> If you are excited about a role but your experience doesnt seem to align perfectly with every element of the job description, we encourage you to apply. You may be just the right candidate for this, or one of our many other roles.</p><p style="margin: 0px;"> </p><p style="margin: 0px;"> </p><p style="margin: 0px;"> </p><p style="margin: 0px;">Deadline to apply to this position is contingent upon applicant volume.  Those positions located in Colorado will have a specific deadline posted in the job description.</p>

Wellpath Business Intelligence Interview Guide

Overview

Wellpath Business Intelligence Salary

Wellpath Business Intelligence Interview Process

Wellpath Business Intelligence Interview Questions

Wellpath Business Intelligence Jobs