A healthcare technology organization is seeking a senior, hands-on Lead AI Data Implementation Architect to lead the architecture and implementation of a new enterprise data warehouse ecosystem.
This greenfield opportunity requires deep Snowflake architecture and engineering experience, prior ownership of end-to-end data warehouse implementations, and practical experience using AI-native development tools.
The ideal candidate will combine technical architecture leadership with direct implementation responsibilities while helping establish a scalable, reliable, and secure enterprise data platform.
RESPONSIBILITIES- Lead end-to-end design and implementation of a greenfield Snowflake data warehouse.
- Define scalable data models, ingestion patterns, transformations, and platform architecture.
- Remain hands-on with Snowflake engineering, SQL, and solution implementation.
- Incorporate Claude Code, Snowflake Cortex, and multi-agent AI into engineering workflows.
- Establish appropriate performance, security, governance, and reliability practices.
- Partner with data engineers throughout design, development, and implementation.
- Resolve complex technical and architectural challenges.
- Help guide the platform through delivery and future expansion.
Role Requirements- Deep Snowflake architecture and engineering expertise.
- Proven experience delivering a new enterprise data warehouse from initial design through implementation.
- Strong SQL, data modeling, and enterprise data integration experience.
- Ability to move between architecture decisions and hands-on technical execution.
- Experience with Claude Code and Snowflake Cortex.
- Practical experience applying multi-agent AI approaches.
- Strong technical delivery leadership and collaboration skills.
- Ability to work during EST hours.
PREFERRED EXPERIENCE- Healthcare or medical claims data experience.
- Microsoft Azure experience.
- Background with regulated or sensitive data.
- Advanced Snowflake ingestion, governance, and optimization experience.