Seeking a highly experienced, hands-on Snowflake Subject Matter Expert (SME) to support a large hospital system implementing an enterprise Snowflake data platform.

We are specifically looking for someone who has personally implemented Snowflake within a hospital or large healthcare delivery system. This is not a general Snowflake development position or a role focused solely on maintaining an existing environment.

The ideal consultant has deep technical expertise in Snowflake architecture, administration, configuration, security, SQL performance optimization, and healthcare data integration. Experience integrating Epic Clarity data into Snowflake is especially important.

This is a technical, hands-on implementation role. We need someone who can configure, build, troubleshoot, optimize, and take ownership of the platform-not simply oversee the work.

What You Must Bring

• Hospital System Snowflake Implementation: Direct, hands-on experience implementing or standing up Snowflake within a hospital, health system, or large healthcare delivery organization. Must be able to explain personal technical responsibilities throughout the implementation.
• Advanced Snowflake Administration: 3+ years of hands-on Snowflake administration, including virtual warehouses, databases, schemas, configurations, access management, resource monitoring, and production support.
• Snowflake Certification: SnowPro Advanced: Administrator certification required.
• Expert-Level SQL: Advanced SQL development, complex query troubleshooting, execution-plan analysis, workload optimization, and performance tuning.
• Epic Healthcare Data: Experience working with Epic Clarity, Caboodle, or other Epic clinical, financial, and operational data sources, preferably integrating this data into Snowflake.
• Informatica: Hands-on experience supporting Informatica ETL/ELT integrations, ingestion pipelines, and data movement into Snowflake.
• Security & Governance: Strong knowledge of Snowflake RBAC, data protection, auditing, HIPAA requirements, and healthcare data governance.
• Implementation Ownership: Demonstrated ability to independently configure, troubleshoot, optimize, and support enterprise Snowflake environments through implementation and production transition.

What You'll Be Doing

• Take a hands-on technical role in implementing and configuring an enterprise Snowflake platform for a large hospital system.
• Configure Snowflake environments, databases, schemas, virtual warehouses, security roles, permissions, and platform settings.
• Support integration and ingestion of Epic Clarity and other hospital data into Snowflake.
• Work directly with Informatica pipelines, data engineering teams, and healthcare data sources to resolve integration issues.
• Troubleshoot complex SQL queries, optimize workloads, improve performance, and manage Snowflake compute consumption.
• Implement security, governance, monitoring, and access controls appropriate for sensitive healthcare data.
• Resolve technical challenges throughout implementation, testing, deployment, and production stabilization.
• Provide technical guidance, document configurations, and establish best practices for long-term platform administration.

The Background We're Looking For

We are especially interested in consultants who can demonstrate:

• A Snowflake implementation completed within a hospital or large health system.
• Direct involvement in the technical configuration and deployment-not just project management or architectural oversight.
• Experience moving Epic Clarity or other hospital operational and clinical data into Snowflake.
• The ability to independently troubleshoot and resolve complex Snowflake performance, security, and integration issues.
• Experience taking a Snowflake platform from implementation through production readiness and ongoing administration.

Candidates whose experience is limited to Snowflake reporting, SQL development, or routine administration without healthcare implementation experience will not be the right fit.