Senior AI Data Warehouse Architect — Snowflake & AI-Driven Platform

Madison-Davis; EE. UU.; A distancia; USD 170.000 - 230.000; Jornada completa

Descripción de la vacante

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.

Formación

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

Responsabilidades

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

Conocimientos

Snowflake architecture

SQL

Data modeling

Enterprise data integration

Hands-on implementation

Claude Code

Snowflake Cortex

Multi-agent AI

Technical delivery leadership

Collaboration

Herramientas

Snowflake

Claude Code

Snowflake Cortex

Descripción del empleo

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.