Lead AI Data Implementation Architect

Madison-Davis; USA; Remote; USD 170.000 - 230.000; Vollzeit

Zusammenfassung

Madison-Davis, LLC is seeking a senior, hands-on Lead AI Data Implementation Architect to design and deliver a Greenfield Snowflake data warehouse. Lead architecture, data modeling, and secure, scalable integration across systems while remaining hands-on with engineering.

This healthcare technology environment requires Claude Code, Snowflake Cortex, and multi-agent AI workflows, ensuring performance, governance, and reliability. You will guide delivery from design through expansion.

Qualifikationen

• 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.

Aufgaben

• 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.

Kenntnisse

Snowflake architecture

SQL

Data modeling

Enterprise data integration

Hands-on implementation

Claude Code

Snowflake Cortex

Multi-agent AI

Technical delivery leadership

Collaboration

Tools

Snowflake

Claude Code

Snowflake Cortex

Jobbeschreibung

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.