Prepare for and practice interview questions from New York State Technology Enterprise Corporation (Nystec).

New York State Technology Enterprise Corporation (Nystec) Interview Questions

New York State Technology Enterprise Corporation (Nystec) 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

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

New York State Technology Enterprise Corporation (Nystec) Salaries by Position

About Us: NYSTEC is a nonprofit technology consulting company, advising agencies, organizations, institutions, and businesses since 1996. We're independent and vendor-neutral, so we have our clients' best interests at heart. At NYSTEC, we know that we succeed when individuals and teams flourish personally and professionally, so our benefits and perks support that mindset. About the role As a senior data analyst, you will be supporting healthcare technology initiatives for our clients, partners, and stakeholders by providing analytical expertise to evaluate clinical data across New York State. You should have a diversity of strengths, including experience with statistical analysis, query, or programming language/format (Structured Query Language [SQL], Python, R, etc.) and with analyzing large data sets within the healthcare industry. You should be passionate about research and learning and have exceptional written and verbal communications, excellent documentation, critical thinking, and analytical skills. The ideal candidate should have the ability to manage and develop key relationships with colleagues and clients through collaborative thinking and a solid customer focus. Serving as a senior data analyst, your day-to-day role as a NYSTEC consultant will be providing data analysis expertise to help to understand, improve, and measure the quality of healthcare data across various domains, systems, and client agencies. Key Responsibilities:<ul> <li>Experience writing ad hoc queries in SQL.</li> <li>Proficient with Microsoft Office Suite, particularly with Excel.</li> <li>Excellent critical thinking, problem solving, and analytical skills.</li> <li>Ability to work independently and to determine analytics next steps and plan analyses.</li> <li>Ability to develop relationships with stakeholders and to understand their needs through excellent listening and effective written and verbal communication.</li></ul>Preferred/Desired Qualifications:<ul> <li>Experience using R, SAS or Python.</li> <li>Experience with Clinical data, Medicaid data or Social Care data</li> <li>Experience using clinical data, provider data, and/or payer data to inform decision making.</li> <li>Knowledge of healthcare data standards and exchange protocols, such as Health Level 7 (HL7) or X12.</li> <li>Experience with data quality analysis, data cleansing, or data profiling.</li> <li>Master's degree in mathematics, data analysis, health informatics, statistics, computer science, or a related discipline.</li></ul>Education and Experience<ul> <li>Bachelor's degree in a technical, scientific, or related discipline, with of three to five years of relevant experience in data analysis, informatics, or data science or an equivalent combination of advanced education, training, and experience.</li></ul> The pay range for this position is $79,793.00 to $109,716.00 per year. It is NYSTEC's policy to provide equal employment opportunity (EEO) to all individuals, regardless of actual or perceived race, color, creed, religion, sex or gender (including pregnancy, childbirth, and related medical conditions), gender identity or gender expression (including transgender status), age, national origin, ancestry, citizenship status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, military service and veteran status, sexual orientation, marital status, or any other characteristic protected by local, state, or federal law and ordinances. NYSTEC is strongly committed to this policy and believes in the concept and spirit of the law. Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please contact recruitment@nystec.com if you require a reasonable accommodation to apply for or to perform this job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment. Applicants must be authorized to work in the United States without the need for visa sponsorship now or in the future. Learn more about NYSTEC by visiting www.nystec.com.

New York State Technology Enterprise Corporation (Nystec) Interview Questions

New York State Technology Enterprise Corporation (Nystec) Interview Guides

New York State Technology Enterprise Corporation (Nystec) Interview Questions

New York State Technology Enterprise Corporation (Nystec) Salaries by Position

New York State Technology Enterprise Corporation (Nystec) Opening Jobs