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

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?

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

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.

What factors could have biased this result, and what would you look into?

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

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?

Horizon Blue Cross Blue Shield Of New Jersey Salaries by Position

Horizon BCBSNJ employees must live in New Jersey, New York, Pennsylvania, Connecticut or Delaware Job Summary: This position is responsible for focusing stop loss risk management activities on the centralized stop loss team and coordinating risk oversight with care delivery related areas of the company. Assures care is coordinated across the company and throughout the care delivery system for high risk members of groups with stop loss coverage underwritten by the company. Uses established guidelines to ensure appropriate levels of care and to plan transitions of care. <ul> <li>Works with care management and delivery functions of the company to identify potential high risk patients in new business and renewal groups, and to assess patient's clinical need against established guidelines, ensuring care levels are medically necessary and appropriate. </li> <li>Insures potential high risk claimants are engaged in care management protocols. </li> <li>Elicits support from sales and account management, brokers, consultants and group customers to insure care management engagement with high risk members. </li> <li>Provides special coordination for supporters of high risk patients, including immediate and extended family, employers, etc., as appropriate. </li> <li>Uses reporting and risk identification tools on medical and pharmacy claims to assess risk. </li> <li>Assists in assuring care management protocols are maintained for members receiving care outside Horizon BCBSNJ's service area, and that special resources (transplant centers, centers of excellence) outside of Horizon BCBSNJ are utilized where possible and appropriate to deliver care. </li> <li>Assists UW in evaluating risks in existing and potential stop loss groups. </li> <li>Works proactively with pharmacy management to insure efficient and appropriate specialty drug usage and site of service delivery. </li> <li>Evaluates care by problem solving, analyzing variances and participating in the quality improvement program to enhance member outcomes. </li> <li>Assists in responding to inquiries from preferred partners for additional information on large claimants. </li> <li>Acts as a resource to sales and account management teams in communicating case management services interaction with stop loss management. </li> <li>Performs other duties as may be assigned by management. </li> <li>Identify high risk claimants within established stop loss customers. </li> <li>Manage high risk claimants within established stop loss customers. </li> <li>Identify high risk claimants within prospective stop loss customers. </li> <li>Insure appropriate and necessary care levels are adhered to for managed patients. </li> <li>Insure functional areas of the company and care delivery systems are engaged in high risk claimant management. </li></ul> Education/Experience: <ul> <li>Minimum high school diploma or GED </li> <li>Prefer an associate's or bachelor's degree (or higher) in nursing and/or a health related field OR accredited diploma nursing school. </li> <li>Requires a minimum of two (2) years of clinical experience. </li> <li>Requires minimum of three (3) years of experience in the health care delivery system/industry. </li> <li>Requires minimum of two (2) years of experience with health care payer experience. </li> <li>Prefer advanced Excel, SQL or Tableau. </li> <li>Experience creating dashboards and reports. </li></ul> Additional licensing, certifications, registrations: <ul> <li>Requires an active NJ Registered Nurse License. </li> <li>Prefers pending or obtained certification in case management or other applicable clinical specialties. </li></ul> Knowledge: <ul> <li>Requires understanding of health and prescription insurance products, contracts and benefits eligibility </li> <li>Requires understanding of health delivery systems and professionals </li> <li>Requires understanding of case/care/disease management principles </li> <li>Understanding of stop loss reporting tools and requirements preferred. </li> <li>Understanding of risk mitigation, high claimant detection, engagement and management preferred. </li> <li>Requires strong inter-personal skills with a demonstrated ability to work across divisions and with external stakeholders </li> <li>Requires proficiency in the use of personal computers and in supporting software in a Windows based environment, including MS Office products (Word, Excel, PowerPoint, MS Project) and Lotus Notes </li></ul> Salary Range: $76,800 - $102,795 This compensation range is specific to the job level and takes into account the wide range of factors that are considered in making compensation decisions, including but not limited to: education, experience, licensure, certifications, geographic location, and internal equity. This range has been created in good faith based on information known to Horizon at the time of posting. Compensation decisions are dependent on the circumstances of each case. Horizon also provides a comprehensive compensation and benefits package which includes: <ul> <li> Comprehensive health benefits (Medical/Dental/Vision) </li> <li> Retirement Plans </li> <li> Generous PTO </li> <li> Incentive Plans </li> <li> Wellness Programs </li> <li> Paid Volunteer Time Off </li> <li> Tuition Reimbursement </li> </ul> Horizon Blue Cross Blue Shield of New Jersey is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran status or status as an individual with a disability and any other protected class as required by federal, state or local law. Horizon will consider reasonable accommodation requests as part of the recruiting and hiring process.

<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 BCBSNJ employees must live in New Jersey, New York, Pennsylvania, Connecticut or Delaware Job Summary: Under general supervision, responsible for producing reports from various sources to provide the department /division with actionable information or business intelligence. This is an intermediate level position performing basic assignments, and may require guidance. Responsibilities: Evaluate, write, and present utilization and cost containment reports. Determine or agree upon deliverables with customer, as well as determining the resources necessary to meet those deliverables. May need to be a liaison with IT /vendor and customer. May perform appropriate analysis on data: forecasting, modeling, regression. Mine data from appropriate system and perform appropriate analysis on data. May present data and provide feedback to client and customer; making necessary recommendations where appropriate. Develop relationships with subject matter experts (SME). Seek and adopt best practices in data reporting. Perform other relevant tasks as assigned by Management.
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: High School Diploma/GED required. Minimum 4 years experience in health insurance. 2 years data reporting experience preferred. Knowledge: Exposure to SAS and SQL systems preferred. Strong PC skills Prefer intermediate database management skills. Understanding interdependencies among data
Skills and Abilities: Organizational, Multitasking, Analytical Thinking and strong Interpersonal Skills Travel: Some travel may be required. Salary Range: $61,200 - $81,900 This compensation range is specific to the job level and takes into account the wide range of factors that are considered in making compensation decisions, including but not limited to: education, experience, licensure, certifications, geographic location, and internal equity. This range has been created in good faith based on information known to Horizon at the time of posting. Compensation decisions are dependent on the circumstances of each case. Horizon also provides a comprehensive compensation and benefits package which includes: Comprehensive health benefits (Medical/Dental/Vision) Retirement Plans Generous PTO Incentive Plans Wellness Programs Paid Volunteer Time Off Tuition Reimbursement Horizon Blue Cross Blue Shield of New Jersey is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran status or status as an individual with a disability and any other protected class as required by federal, state or local law. Horizon will consider reasonable accommodation requests as part of the recruiting and hiring process.
#J-18808-Ljbffr

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