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

Medica Business Intelligence Interview Guide

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


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

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

Overview

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

Medica 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 show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

Medica Business Intelligence Interview Questions

<p>Responsible for developing, implementing and managing a portfolio of Medicare Advantage products. Develops and manages competitive offerings by overseeing market research and regulatory requirements. Defines and implements product features with a member experience focus. Assists with managing and analyzing product performance. May have interaction with regulatory bodies.</p>

<p><strong>Key Accountabilities</strong></p>

<ul>
	<li>Maintains source of truth documents for Medicare Advantage (MA) plans which is crucial to maintain alignment between four areas: Product pricing, CMS bid submission, system configuration and legal/required member documents. </li>
	<li>Completes plan benefit package (PBP) software responses for annual CMS bid submission through its Health Plan Management System (HPMS) and has thorough understanding of the PBP category definitions.</li>
	<li>Bid subject matter expert (SME) and leader of the Bid Best Practices group to align the organization's bid submissions across product lines and support other bid submitters.</li>
	<li>Conducts deep competitor analysis, collects competitor materials and assembles competitive reports and analyses.</li>
	<li>Supports 1/1 readiness and vendor management activities.</li>
	<li>Resource to the enterprise to answer product intent questions for internal stakeholders such as Sales, Customer Services, Pharmacy and Configuration; MA product representative on internal workgroups.</li>
	<li>Assists with managing and analyzing product performance by reviewing reports and works to identify trend drivers and possible solutions in coordination with enterprise efforts.</li>
</ul>

<p><strong>Qualifications</strong></p>

<ul>
	<li>Bachelor's degree or equivalent experience in related field, plus 7 years of related work experience beyond degree</li>
	<li>Experience working with Medicare Advantage plans, the CMS bid cycle, and CMS's Health Plan Management System (HPMS) software</li>
	<li>Leadership experience preferred</li>
</ul>

<p><strong>Skills and Abilities</strong></p>

<ul>
	<li>Experience in conducting market research, competitive analysis, and the development of business cases</li>
	<li>Experience in the analysis, summary, and presentation of business reports to organizational leaders and regulatory officials</li>
	<li>Excellent organizational skills with proven ability to manage projects from kick-off to implementation</li>
	<li>Excellent interpersonal communication skills with proven ability to establish and maintain strong relationships at multiple levels of an organization</li>
	<li>Ability to quickly adapt to change and work independently</li>
	<li>Proficient in Microsoft office suite</li>
</ul>

<p>This position is a remote role. The employee must be located in any state in which Medica is an employer and will work remotely 100% of the time.</p>

<p>The full salary range for this position is $85,000 - $145,700. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data. In addition to compensation, Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.</p>

<p>The compensation and benefits information is provided as of the date of this posting. Medica's compensation and benefits are subject to change at any time, with or without notice, subject to applicable law.</p>

<p>Medica's commitment to diversity, equity and inclusion (DEI) includes unifying our workforce through learning and development, recruitment and retention. We consistently communicate the importance of DEI, celebrate achievements, and seek out community partnerships and diverse suppliers that are representative of everyone in our community. We are developing sustainable programs and investing time, talent and resources to ensure that we are living our values. We are an Equal Opportunity/Affirmative Action employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic. </p>

Medica Business Intelligence Interview Guide

Overview

Medica Business Intelligence Salary

Medica Business Intelligence Interview Process

Medica Business Intelligence Interview Questions

Medica Business Intelligence Jobs