Prepare for and practice interview questions from Horizon Blue Cross Blue Shield Of New Jersey.

Horizon Blue Cross Blue Shield Of New Jersey Interview Questions

Horizon Blue Cross Blue Shield Of New Jersey Interview Guides

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.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<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

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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

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?

Horizon Blue Cross Blue Shield Of New Jersey Salaries by Position

<h3>Job Description</h3><div>Job Description<div>Job Title: Business Analyst IIIJob Description SummaryResponsible for conducting research and root cause analysis for customers with the goal of recommending and implementing new processes and solutions to operational deficiencies. Resolves issues and improves operational performance on a cross-functional/departmental basis. This is a senior level position working independently with guidance only in the most complex situations.Responsibilities:<ul><li>Investigate service related issues to identify root cause of issues; identify and communicate business needs assessments as necessary.</li><li>Develop forecasting tools using current technology/systems (Access, Excel, Monarch, etc.)</li><li>Translate business requirements and assist IT with the development of technical specifications.</li><li>Develop solutions based on data analysis to increase business efficiency.</li><li>Lead or participate in internal and external project workgroup(s) and presentations.</li><li>Conduct User Acceptance Testing (UAT) for projects, implementations, system fixes and enhancements, etc.</li><li>Prepare materials for internal and external audit activities; review audit findings/reports for accuracy and completeness. If appropriate, formulate rebuttal and/or corrective action steps.</li><li>May coach/mentor less experienced staff, assist in on-boarding of new staff and/or distribute and follow-up on work assignments.</li><li>Perform other relevant tasks as assigned by management.</li></ul> ADDENDUM FOR QUALITY AUDIT MEASUREMENT TEAM ANALYSTS:<ul><li>Identifies process improvement opportunities for platform work as an example, review SQM and QA reports, review trends to identify process improvement and automation)</li><li>Gather, process FCR and QA performance data and conduct trending and root cause analyses</li><li>Design and develop standard reports for metrics reporting and analysis. Document call center processes using standard techniques.</li></ul> ADDENDUM FOR MEDICAL POLICY TEAM ANALYSTS:<ul><li>Apply professional and facility billing procedural (CPT/HCPCS) and diagnostic (ICD10) knowledge to support new cost savings opportunities.</li><li>Apply vendor clinical coding rule knowledge to support reimbursement and medical policy criteria and claims processing.</li></ul>Disclaimer:This job summary has been designed to indicate the general nature and level of work performed by colleagues within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of colleagues assigned to this job. Education/Experience:<ul><li>High School Diploma/GED required.</li><li>Bachelor degree preferred or relevant experience in lieu of degree.</li><li>Minimum of seven (7) years' experience in an operational role, or analytical role.</li><li>Experience with relational databases. SQL experience HIGHLY preferred which includes writing and analyzing SQL queries.</li><li>Experience with backend/frontend technologies preferred (JAVA, J2EE, UNIX, EJB, JavaScript, CSS, etc.)</li></ul>Knowledge:<ul><li>Knowledge of Healthcare industry required.</li><li>Knowledge of Project Management methodologies.</li><li>May require knowledge of Horizon Blue Cross Blue Shields products and services.</li><li>May require working knowledge of division operating plan and Horizon operating model.</li></ul></div>Company Description<div>Horizon BCBS NJ is New Jersey's largest and #1 Rated Healthcare Managed Care Company. We are a not for profit company that is highly rated (Forbes List 2024-One of the Best employers in the US).</div></div><h3>Company Description</h3><div>Horizon BCBS NJ is New Jersey's largest and #1 Rated Healthcare Managed Care Company.\r\nWe are a not for profit company that is highly rated (Forbes List 2024-One of the Best employers in the US).</div>

Horizon Blue Cross Blue Shield Of New Jersey Interview Questions

Horizon Blue Cross Blue Shield Of New Jersey Interview Guides

Horizon Blue Cross Blue Shield Of New Jersey Interview Questions

Horizon Blue Cross Blue Shield Of New Jersey Salaries by Position

Horizon Blue Cross Blue Shield Of New Jersey Opening Jobs