Health Analyst Interview Questions

645 health analyst interview questions shared by candidates

What is the following SQL code trying to do? Please explain (select A.RecipientID B.BeginDate, B.EndDate, B.CountyOfResidence, B.MajorProgram, B.EligibilityType, A.Birthdate, (Case When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 21 then 'Ages 0 through 21' When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 65 then 'Ages 22 through 65' When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 65 then 'Ages 66 and Over' Else 'error' end_ as Age_Category from dhsviews.Recipients V as A, DHSViews.RecipientElibgibility V as B Where A.RecipientID = B.RecipientID and B.MajorProgram IN ('MA', 'NM', 'IM', 'EH') and B.EligibilityStatus IN('A', 'C') and B.BeginDate <= date '2010-12-31' and B.EndDate >= date '2010-01-01' Order by 1,2);
avatar

Health Data Analyst

Interviewed at State of Minnesota

3.9
Apr 15, 2020

What is the following SQL code trying to do? Please explain (select A.RecipientID B.BeginDate, B.EndDate, B.CountyOfResidence, B.MajorProgram, B.EligibilityType, A.Birthdate, (Case When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 21 then 'Ages 0 through 21' When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 65 then 'Ages 22 through 65' When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 65 then 'Ages 66 and Over' Else 'error' end_ as Age_Category from dhsviews.Recipients V as A, DHSViews.RecipientElibgibility V as B Where A.RecipientID = B.RecipientID and B.MajorProgram IN ('MA', 'NM', 'IM', 'EH') and B.EligibilityStatus IN('A', 'C') and B.BeginDate <= date '2010-12-31' and B.EndDate >= date '2010-01-01' Order by 1,2);

Calculate crude prevalence rate, confidence intervals, and explain the results you got in the paper in 20 minutes. Calculator provided. Please explain how you arrived at the answers in your statistical test. Have you analysed a large dataset, please provide examples. How would you clean your data and how would you deal with data errors or missing data. Tell me about data protection and how you would apply it in an analytical environment. Have you had experience with aggregate and/or record level data. Can you explain standardized rates, what about direct and indirect methods. What confidence intervals would you use (visit the 'Fingertips' profile to see which ones they use) Explain how you would carry out a project (project management approach) What are your aspirations. What do you think are the key components of a quality report and how would you produce one for senior management. How would you present complex statistical information to various senior stakeholders. What does 'intelligence' mean within public health.
avatar

Public Health Analyst

Interviewed at Public Health England

3.7
Jun 1, 2017

Calculate crude prevalence rate, confidence intervals, and explain the results you got in the paper in 20 minutes. Calculator provided. Please explain how you arrived at the answers in your statistical test. Have you analysed a large dataset, please provide examples. How would you clean your data and how would you deal with data errors or missing data. Tell me about data protection and how you would apply it in an analytical environment. Have you had experience with aggregate and/or record level data. Can you explain standardized rates, what about direct and indirect methods. What confidence intervals would you use (visit the 'Fingertips' profile to see which ones they use) Explain how you would carry out a project (project management approach) What are your aspirations. What do you think are the key components of a quality report and how would you produce one for senior management. How would you present complex statistical information to various senior stakeholders. What does 'intelligence' mean within public health.

Viewing 21 - 30 interview questions

Glassdoor has 645 interview questions and reports from Health analyst interviews. Prepare for your interview. Get hired. Love your job.