Prepare for and practice interview questions from Apixio.

Apixio Interview Questions

Apixio Interview Guides

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

Apixio Salaries by Position

<h3>Job Description</h3><div>Job Description<div><div><p><strong>Who We Are:</strong></p><p>At the intersection of health plans and providers, Apixio is creating a leading Connected Care platform to minimize reimbursement inaccuracies and high-quality patient care so they can thrive as the industry moves toward value-based reimbursement models. </p><p>The combination brings together healthcare expertise, AI/machine learning technology and data-driven analytics solutions to deliver innovative solutions and value to our customers and the healthcare ecosystem. We aim to accelerate the shift toward alternative payment models, while enhancing efficiency and supporting better patient outcomes.</p></div>Business AnalystAbout the role<p>Apixio is looking for a Business Analyst to join our analytics team who is curious about data, passionate about analyzing and deriving insights from it, and proficient in implementing the tools to do so. In this role, you will be working closely with our internal customers, helping them create reports and dashboards that help them understand metrics about their respective functional areas. The business analyst position is ideal for someone who has the right mix of data analysis and communication skills to collect requirements and analyze data to deliver the same.</p><span class="long-word">ResponsibilitiesGather</span> Business Requirements<ul><li>Understand Apixio's business, products and data stores</li><li>Gather requirements from internal customer teams (medical coding, customer success, product, marketing) around data analysis</li></ul>Data manipulation and analysis<ul><li>Identify the best sources of primary or secondary data to satisfy business requirements</li><li>Work with cross-functional teams (analytics, data integrations, engineering) to collect and transform data</li><li>Review metrics with customer teams to determine if forecasted outcomes and KPIs are in alignment with expectations</li></ul>Communicate Insights<ul><li>Use business intelligence tools to create reports and visualizations that communicate results of data analysis</li><li>Combine data from multiple sources and business logic to create reports and dashboards for delivery</li><li>Present and explain analytical problems, approaches, results, and recommendations</li></ul>Demonstrate Initiative and Focus<ul><li>Demonstrate ability to adapt in a rapidly changing environment with evolving product capabilities</li><li>Have a high degree of initiative and customer service focus</li><li>Be a results oriented team player</li></ul>Required Skills / Experience<ul><li>Bachelor's degree in Computer Science, Mathematics, Statistics, Health Services or Economics or equivalent field required.</li></ul><ul><li>1-3 years of hands-on work experience in business intelligence and analytics. Technical knowledge of BI techniques and tools like Tableau or Looker.</li></ul><ul><li>Experience conducting data analysis in Python, SQL and Excel</li></ul><ul><li>Strong communication skills necessary to relay complex data analysis requirements to team members and customers.</li></ul><ul><li>Strong organizational and planning skills are essential. </li></ul><ul><li>Ability to work independently when needed, applying critical thinking and problem solving to achieve a positive outcome.</li></ul><ul><li>Demonstrated expertise in data visualization and storytelling techniques, utilizing advanced tools and frameworks to create compelling and interactive data visualizations.</li><li>High agency, integrity, ownership, and curiosity.</li></ul>Preferred Skills / Experience<ul><li>Experience working in the healthcare industry</li><li>Experience with object oriented programming</li><li>Experience with statistics and data modeling concepts like multivariate regression, segmentation modeling, machine learning, data mining, simulation, optimization, forecasting</li><li>Experience with other business intelligence backend and analytics applications</li></ul><div><div>The salary range below is for Base Salary. Total compensation also includes benefits and variable compensation. Compensation will be determined based on several factors including, but not limited to, skill set, years of experience, and the employee's geographic location.</div><div>Base Compensation</div><div>$65,000—$95,000 USD</div></div><div><p><strong>We recognize that people come with experience and talent beyond just the technical requirements of a job. If your experience is close to what you see listed here, please consider applying. Diversity of experience and skills combined with passion is a key to innovation and excellence. Therefore, we encourage people from all backgrounds to apply to our positions. Your skills and background may be more translatable to this role than you initially thought. Allow us the opportunity to get to know you. Please let us know if you require accommodations during the interview process.</strong></p><p><strong>What Apixio can offer you:</strong></p><ul><li>Meaningful work to advance healthcare </li><li>Competitive compensation</li><li>Exceptional benefits, including medical, dental and vision, FSA/HSA</li><li>Generous vacation policy</li></ul><p>We take your privacy very seriously. Please review our privacy policy to see exactly how we protect your information here</p><p><em>We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.</em></p><p></p><p><strong>Notice to <span class="long-word">Recruiters/Staffing</span> Agencies</strong></p><ul><li>Recruiters and staffing agencies should not contact Apixio through this page. <em>All recruitment vendors (search firms, recruitment agencies, and staffing companies) are prohibited from contacting our hiring manager(s), executive team members, or employees</em></li><li>We require that all recruiters and staffing agencies have a fully executed, formal written agreement on file</li><li>Apixio receipt or acceptance of an unsolicited resume submitted by a vendor organization to this website or employee does not constitute an actual or implied contract between Apixio and such organization and will be considered unsolicited and Apixio will not be responsible for related fees</li></ul><p></p><p></p><p>LI-RB1</p></div></div></div>

Apixio Interview Questions

Apixio Interview Guides

Apixio Interview Questions

Apixio Salaries by Position

Apixio Opening Jobs