US Healthcare Analytics Data Warehouse -- 2

I need a complete data-warehouse solution for Dual Specialist Hospital (Medicare) in the United States. The core objective is to pull our patient health records into a single, well-structured repository and make that information immediately useful for data analytics and reporting. Clinical staff, quality-improvement teams, and executives all expect fast insight without wading through multiple systems or static spreadsheets.

The build must support:
• Real-time data analysis so new encounters, labs, and vitals are visible in minutes, not days.
• Customizable reporting templates our analysts can adjust without developer help.
• Data visualization tools that present trends clearly for non-technical decision-makers.

I’m open to the platform you recommend—whether that’s Snowflake, SQL Server, BigQuery, Redshift, or a comparable HIPAA-compliant stack—as long as you outline why it fits our scale and security needs. Please plan for typical healthcare data standards (HL7 v2, FHIR, or CCD) and include an ETL/ELT pipeline that cleans, normalizes, and de-identifies data where required for compliance.

Deliverables expected:
1. Dimensional warehouse schema and data-dictionary documentation.
2. Automated ingestion scripts/workflows and orchestration setup.
3. Interactive dashboards plus a library of reusable report templates.
4. Deployment guide and knowledge-transfer session for our internal IT team.

Proposals that highlight prior work with patient-record data, HIPAA safeguards, and real-time analytics will stand out. Let me know which toolset you feel is best and the milestones you suggest to get us live.