Prepare for and practice interview questions from Northwell Health.

Northwell Health Interview Questions

Northwell Health Interview Guides

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

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

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?

Northwell Health Salaries by Position

Team Overview: The HIE (Health Information Exchange) consists of different development teams working with InterSystems HealthShare as the core application. Our HIE development team is responsible for building custom solutions using the InterSystems stack of technologies, Cloud Services (Mainly focused on Microsoft Azure and GCP), Custom tools using Java/.Net/Python/JavaScript frameworks. Northwell HIE platform consists of 100s of applications feeding HL7/CCD/Flat File/XML/APIs etc. The goal of the team is to consolidate all the data and make it available for consumers while executing clinical workflows. Job Description Collaborates and coordinates with other departments. Provides leadership to team members and supervisors; reviews company and customer objectives; resolves issues regarding contract compliance. Job Responsibility <ul> <li>Provides leadership to Software Development, Engineering and Services team members and supervisors by communicating and guiding designing, building, testing, deploying, maintaining, and supporting applications or the health systems software, which may include web or mobile applications.</li> <li>Develops and builds consensus for goals in alignment with the health system.</li> <li>Establishes functional requirements and reviews solutions to ensure organizational needs are met. </li> <li>Works with the technical teams to analyze acquisition requirements.</li> <li>Advises all levels of staff and management regarding contract terms and conditions, applicable policies and procedures, and best practices to advance IT department business objectives.</li> <li>Oversees implementation of one or more software development methodologies.</li> <li>Responds to inquiries regarding contract obligations; advises project leaders regarding contractual issues; works with vendors and organization teams to understand and resolve contractual issues.</li> <li>Collaborates with stakeholder departments throughout negotiation to facilitate contract implementation.</li> <li>Monitors active contracts and helps IT staff with ensuring contractual commitments are understood and met.</li> <li>Performs related duties as required. All responsibilities noted here are considered essential functions of the job under the Americans with Disabilities Act. Duties not mentioned here, but considered related are not essential functions.</li> </ul> Job Qualification <ul> <li>Bachelor's Degree required, or equivalent combination of education and related experience.</li> <li>6-8 years of relevant experience and 2-5 years of leadership / management experience, required.</li> </ul> Highly Preferred: <ul> <li>Healthcare experience focusing on data mapping, translation, and normalization</li> <li>Strong knowledge of Healthcare interoperability standards: HL7, CDA, CCDA, CCD, FHIR</li> <li>Must be familiar with healthcare data structure, components and relationships</li> <li>Must be familiar with identity management, and merge/move workflows</li> <li>Must be well conversant with SDLC processes and methodologies</li> <li>Self-starter with strong communication, presentation, relationship building and strategic analytical skills</li> <li>Strong time management, goal setting and task prioritization abilities</li> </ul> *Additional Salary Detail The salary range and/or hourly rate listed is a good faith determination of potential base compensation that may be offered to a successful applicant for this position at the time of this job advertisement and may be modified in the future.When determining a team member's base salary and/or rate, several factors may be considered as applicable (e.g., location, specialty, service line, years of relevant experience, education, credentials, negotiated contracts, budget and internal equity). The salary range for this position is $130,300-$228,000/year Salary ranges shown on third-party job sites may not accurately reflect ranges provided by Northwell Health. Candidates should check Northwell Health Careers for accurate information and discuss salary/hourly details and our comprehensive benefits with a recruiter, if selected for an interview.

Job Description Job Description Leads team members to provide direct input to the overall engineering process and to team meetings. Coordinates within a team environment which is essential to work on various aspects of the platform and products, as is a devotion of collaboration to problem solve, design sophistically, and increase product quality. Job Responsibility <ul> <li>Leads the design and development of solutions to various problems either independently or in a team environment; designs and maintains efficient code that is reliable. </li> <li>Guides the creation of technical documents such as a design specification document. </li> <li>Ensures applications are performing at high capacity, responsiveness, and quality. </li> <li>Finds solutions to reduce issues and defects. </li> <li>Maintains that the platform's code and data are organized, automated, and of high quality. </li> <li>Guides junior team personnel by recommending software design and development opportunities/best practices. </li> <li>Employees use knowledge and skills to contribute to the development of functional objectives and principles to achieve goals in innovative ways. Problems addressed are of diverse scope and complexity ranging from moderate to substantial.</li> <li>Uses knowledge and skills to contribute to the development of functional objectives and principles to achieve goals in innovative ways. Problems addressed are of diverse scope and complexity ranging from moderate to substantial.</li> <li>Performs related duties as required. All responsibilities noted here are considered essential functions of the job under the Americans with Disabilities Act. Duties not mentioned here, but considered related are not essential functions.</li></ul> Job Qualification <ul> <li>Bachelor's Degree required, or equivalent combination of education and related experience.</li> <li>5-7 years of relevant experience and progressive experience where team leadership was demonstrated, required.</li></ul> Highly Preferred 7+ years experience with the Salesforce platform Experience in healthcare preferred Experience with Salesforce Marketing Cloud highly preferred. Experience with Salesforce Health Cloud, Mulesoft and/or Data Cloud preferred. Salesforce Certified Administrator Certificate required, Salesforce Certified Advanced Administrator Certificate and Salesforce Certified Platform App Builder Certificate preferred. *Additional Salary Detail The salary range and/or hourly rate listed is a good faith determination of potential base compensation that may be offered to a successful applicant for this position at the time of this job advertisement and may be modified in the future.When determining a team member's base salary and/or rate, several factors may be considered as applicable (e.g., location, specialty, service line, years of relevant experience, education, credentials, negotiated contracts, budget and internal equity).

Northwell Health Interview Questions

Northwell Health Interview Guides

Northwell Health Interview Questions

Northwell Health Salaries by Position

Northwell Health Opening Jobs