The relationship between healthcare providers and members has become more critical over time with the advancement of healthcare and the multiple types of coverage available to healthcare members. Currently, it is vital that healthcare providers reach out to members in an effective way throughout their engagement term. The stages of these engagement terms are before inpatient hospitalization, while inpatient hospitalization care and then outpatient care to be done later.

This tracking of member outreach is called Member Case outreach management. In the ever-changing world of healthcare data science, it’s important to track the data related to case management effectively. Clinically, this data supports claims, billing, policy development, cost of care calculation as well as key clinical insights. Key clinical insights like percentage of members engaged in each healthcare program are necessary to understand how well or not the program is faring. Modern cloud computing tools like Snowflake have been powerhouses of case management data over the years (Johnson & Lee, 2023). Snowflake is unique for its modern cloud - native architecture and more seamless integration. Healthcare professionals, doctors and data scientists alike, need to derive insights from previous or existing case management data to aid better future healthcare case management.

In this paper, we discuss the role of Snowflake ETL’s in managing healthcare case outreach data. We will discuss the various features of case outreach data that Snowflake can potentially store as well as track. Furthermore, we will be able to dive deep into how health case outreach data determines the cases open vs cases engaged rate and influences the overall behavioral health program management.