Title: Senior Data & AI Lakehouse Architect
Overview: Healthcare organization is investing in Data and Analytics at the Enterprise level and looking to hire a fully hands-on Senior Data Architect to own the architecture and data models for the enterprise Snowflake lakehouse, supporting both structured analytics and unstructured AI/ML use cases across the organization.
This is a highly visible, business facing individual contributor role. You’ll work closely with a dedicated data engineering team, architecting and proving out solutions hands-on, while engineering owns production build-out at scale. You’ll also work directly with business leaders, explaining and defending design decisions, and onboarding new use cases as the business needs them. There’s an opportunity to grow into leadership roles based on performance.
What You’ll Do
- Own the reference architecture for the enterprise Snowflake lakehouse, and own and evolve its data models, validating approaches hands-on with SQL and Python before handing designs to the data engineering team
- Manage several business cases and data models in parallel, and document models for business users using modern tools
- Apply strong data modeling judgment for structured analytics (star schema, Kimball, Data Vault), using modern, cloud-based, collaborative modeling and diagramming tools (e.g., SqlDBM, Lucidchart, Miro, Gliffy)
- Apply modeling approaches for semi-structured and unstructured AI/ML data: schema-on-read, Data Vault satellites, JSON/variant storage, medallion pipelines, and chunking/embedding for RAG, using GUI tools for design and code-based tools (dbt, Python) for building pipelines
- Compare and validate technical alternatives, including federated query engines (Trino/Starburst), data virtualization, data mesh, and data fabric, and prove approaches out with hands-on POCs before they scale
- Determine the right data integration pattern for each use case: batch, streaming, CDC, or ELT
- Drive the data governance platform launch (lineage, metadata, data quality, security), rolled out in iterations and applied practically, not just conceptually
- Collaborate closely with the data engineering team, data scientists, and business stakeholders to translate requirements into working solutions
More Info
- 1000% hands-on role
- Full-time, mostly remote role with minimal travel to HQ
Responsibilities/Experience
- Hands-on, current experience in cloud data architecture, data modeling, and data integration, not just theoretical or dated knowledge
- Strong SQL and Python skills
- Real experience with Snowflake, ideally including migration work
- Strong data modeling background, both structured (star schema, Kimball, Data Vault) and unstructured/AI-ready approaches
- Ability to explain architecture decisions clearly to technical and business audiences
- Healthcare industry experience, ideally within a health system