Designing A Data Warehouse for Healthcare Analytics Using Snowflake – To Store and Analyze Healthcare Analytics

Modern healthcare systems generate an overwhelming amount of data every day from electronic health records, billing systems, laboratory reports, and connected medical devices. Making sense of this data is essential for improving patient outcomes and supporting clinical and administrative decisions. However, many traditional on-premises data warehouses struggle to keep up due to limited scalability, high maintenance costs, and difficulties in managing data from multiple sources.
Cloud-based solutions such as Snowflake have emerged as practical alternatives, offering flexible storage, scalable computing power, and easy integration with analytics and reporting tools. This review looks at how these platforms are currently used in healthcare data warehousing and discusses common approaches to data integration, performance management, and data security. It also points out the lack of unbiased, side-by-side comparisons between platforms and highlights the growing need for standardized practices, automation, and thorough evaluation methods to ensure their effective adoption in healthcare settings.

Data warehousing, Snowflake

1. International Journal of Engineering Research And Development e- ISSN: 2278-067X, p-ISSN: 2278-800X, www.ijerd.com Volume 21, Issue 2 (February 2025), PP 175-190 [Google Scholar] [Crossref]

2. Hersh, W. R., Weiner, M. G., Embi, P. J., Logan, J. R., Payne, P. R., Bernstam, E. V., ... & Lehmann, H. P. (2013). Caveats for the use of operational electronic health record data in comparative effectiveness research. Medical Care, 51(8 Suppl 3), S30-S37. https://doi.org/10.1097/MLR.0b013e31829b1dbd [Google Scholar] [Crossref]

3. Hripcsak, G., Duke, J. D., Shah, N. H., Reich, C. G., Huser, V., Schuemie, M. J., ... & OHDSI community. (2015). Observational Health Data Sciences and Informatics (OHDSI): Opportunities for observational researchers. Studies in Health Technology and Informatics, 216, 574–578. https://doi.org/10.3233/978161499-559-1-574 [Google Scholar] [Crossref]

4. Klann, J. G., Szolovits, P., & Murphy, S. N. (2019). Data reuse and integration in clinical research. Journal of the American Medical Informatics Association, 26(8-9), 814-819. https://doi.org/10.1093/jamia/ocz075 [Google Scholar] [Crossref]

5. Kuo, M. H., Sahama, T., Kushniruk, A., Borycki, E., & Grunwell, D. (2022). Health data warehousing and analytics. Journal of Biomedical Informatics, 78, 34- 47. https://doi.org/10.1016/j.jbi.2022.103681 [Google Scholar] [Crossref]

6. Liao, K. P., Cai, T., Savova, G. K., Murphy, S. N., Karlson, E. W., & Ananthakrishnan, A. N. (2021). Development of phenotype algorithms using electronic medical records and incorporating natural language processing. BMJ, 372, m156. https://doi.org/10.1136/bmj.m156 [Google Scholar] [Crossref]

7. Weiskopf, N. G., & Weng, C. (2013). Methods and dimensions of electronic health record data quality assessment: enabling reuse for clinical re-search. Journal of the American Medical Informatics Association, 20(1), 144-151. https://doi.org/10.1136/amiajnl-2011-000681 [Google Scholar] [Crossref]

8. Inmon, W. H. (2002). Building the Data Warehouse. Wiley [Google Scholar] [Crossref]

9. Kimball, R., & Ross, M. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modelling. Wiley. [Google Scholar] [Crossref]

10. Raghupathi, W., & Raghupathi, V. (2014). Big data analytics in healthcare: promise and potential. Health Information Science and Systems, 2(1), 3. [Google Scholar] [Crossref]

11. Vimalananda, V. G., et al. (2017). Electronic health record-based interventions for improving quality of care: a systematic review. JAMA Internal Medicine, 177(9), 1393–1401. [Google Scholar] [Crossref]

12. Kuo, M.-H., et al. (2022). Health data warehousing and analytics. Journal of Biomedical Informatics, 78, 34–47. [Google Scholar] [Crossref]

13. Mandel, J. C., et al. (2016). SMART on FHIR: A standards-based, interoperable apps platform for electronic health records. Journal of the American Medical Informatics Association, 23(5), 899–908. [Google Scholar] [Crossref]

14. Li, X., et al. (2019). Privacy-preserving data sharing on cloud-based data warehouse platforms. IEEE Access, 7, 156001–156012. [Google Scholar] [Crossref]

15. Zhang, Y., et al. (2021). Security and privacy in smart healthcare: Challenges and opportunities. IEEE Communication Magazine, 59(12), 42–48. [Google Scholar] [Crossref]

16. Sadiku, M. N. O., Musa, S. M., & Momoh, O. D. (2020). Cloud Data Warehousing. International Journal of Engineering Research and Advanced Technology, 6(9), 1–3. [Google Scholar] [Crossref]

17. Ahuja, S., et al. (2021). Cloud computing for healthcare: A systematic literature review. IEEE Access, 9, 142907–142925. [Google Scholar] [Crossref]

18. Madiha, N. B, T. S, M. Aamir, and A. V, “Designing a data warehouse for healthcare analytics using Snowflake and BigQuery: A review,” International Journal for Research Trends and Innovation (IJRTI), vol. 10, no. 9, Paper ID: IJRTI2509102, Sep. 2025 [Google Scholar] [Crossref]

• LeafQuest: A Mobile-Based Augmented Reality for Plant Placement, Discovery, and Growth
• Participatory Ergonomic Intervention Approach on Musculoskeletal Disorder (MSD) in Construction Sectors: A Systematic Review
• Integrating GIS into Traffic Incident Management: A Web-Based System
• RideSmart: A Personalized Motorcycle Product Recommendation System Using TF-IDF and Descriptive Analytics for Javidson Motorshop
• Educational Technology Course Design in Pre-Service Teachers Education: A Bibliometric Review of the Research Landscape