Please describe your experience working with health care provider organizations, specifically as it relates to health informatics, data exchange or analytics.

Describe any work projects or experience you have in value-based care or payment.

What standards are used in the exchange of electronic health information? what state and national resources might you use to stay informed of the latest developments in e-health?

Do you have experience writing SAS code, extracting data from a data warehouse, and working with relational data tables? if you have not used SAS please describe the analytical software with which you are experienced (SPSS, Stata, R etc.)?

How do you go about solving problems at work?

Describe the best manager, supervisor, or project lead that you have ever had? Describe the worse?

What do you think is the most important skill needed to be successful in this position? What would you need from leadership and/or your team to be successful in this position?

If you are selected as the final candidate, when would you be available to start at DHS?

Do you have any questions for us?

To aid in evaluating performance within their system, an IHP has asked DHS to prepare a report that would illustrate the relative efficiency of their clinics on cost and utlization metrics. Knowing you are working with an enrollment and insurance claims database and have access to Johns Hopkins AVG risk grouper how might you conduct this project? What measures would you develop and how would you visualize it? What additional analysis might you include in the report to help inform the IHP?

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);

What is the following SAS code trying to do? Please explain Proc sort data = SpecCodes; By TreatingProvider SpecifaltyCodes; Run; Data SpecsCode2; Set SpecCodes; By TreatingProvider SpecialtyCode; If first.TreatingProvider then Counter = 0; Counter +1; Run; Proc freq data = SpecCodes 2; Tables Counter; Run; Data SpecCodes 3 (drop = SpecialityCode Counter i); Set SpecCodes 2; By TreatingProvider SpecialtyCode; Array Spec_Code{6} $ 2 Code1-Code6; Retain Code1-Code6; If first.TreatingProvider then do i = 1 to 6; Spec_code{1} = "; End; Spec_Code{Counter} = SpecialtyCode; If last.TreatingProvider then output; Run;