SQL query question
Budget: $30 – $250 USD
Logistics:
brief background to the case and outline an analytic task.
Things to note:
This case will primarily assess your analytic and coding skills, but it’s also designed to be fun and informative .
You will have a full day to complete the task at your own pace; however, the task is designed to be completed in ~1 hour. Please do not feel compelled to spend significantly more time.
We cannot guarantee real-time responses to content or analytics questions you may have about the case. We advise that you make reasonable assumptions and explain your assumptions to your interviewer.
Our Director wants to design an initiative to address the high inpatient spend we observe and close our medical expense deficit. She has come to you for more insight on our inpatient stays. Specifically, she has requested the following (your task):
Among the inpatient (IP) stays1, design and conduct an analysis specifically for members to:
Perform descriptive analysis of the inpatient stays for members and the members themselves
Identify the cost drivers2 of the inpatient stays for members
Calculate the readmission rate (readmission definition: an admission that occurs within a 30 day period after a prior inpatient discharge)
[Optional: identify any statistically significant disparities you observe in the data, if any]
For the descriptive analysis and cost drivers, she has left the choice of variables up to you to determine what is most important
Please choose a coding language (e.g. R, SAS, SQL, etc) and write down your code.
Note: you are free to use Excel to complete the analysis, but you must write up the code you would have used in your software of choice
Output your findings into tables or charts to present to your interviewer
brief background to the case and outline an analytic task.
Things to note:
This case will primarily assess your analytic and coding skills, but it’s also designed to be fun and informative .
You will have a full day to complete the task at your own pace; however, the task is designed to be completed in ~1 hour. Please do not feel compelled to spend significantly more time.
We cannot guarantee real-time responses to content or analytics questions you may have about the case. We advise that you make reasonable assumptions and explain your assumptions to your interviewer.
Our Director wants to design an initiative to address the high inpatient spend we observe and close our medical expense deficit. She has come to you for more insight on our inpatient stays. Specifically, she has requested the following (your task):
Among the inpatient (IP) stays1, design and conduct an analysis specifically for members to:
Perform descriptive analysis of the inpatient stays for members and the members themselves
Identify the cost drivers2 of the inpatient stays for members
Calculate the readmission rate (readmission definition: an admission that occurs within a 30 day period after a prior inpatient discharge)
[Optional: identify any statistically significant disparities you observe in the data, if any]
For the descriptive analysis and cost drivers, she has left the choice of variables up to you to determine what is most important
Please choose a coding language (e.g. R, SAS, SQL, etc) and write down your code.
Note: you are free to use Excel to complete the analysis, but you must write up the code you would have used in your software of choice
Output your findings into tables or charts to present to your interviewer