Principal AI & Data Architect: Snowflake, Semantic Modeling

Damco Solutions; United States; On-site; USD 180,000 - 280,000; Full time

Job summary

Damco Solutions is seeking a Principal AI & Data Architect to define and lead our enterprise data and AI architecture. You will design a Snowflake-centric data platform with a strong semantic layer and build foundations for agentic AI systems that reason over trusted data.

As a hands-on technical leader, you will partner with business, engineering, and security teams to turn data into reliable, AI-ready products, mentor engineers, and translate strategy into roadmaps.

Qualifications

• 12+ years in data engineering, data architecture, or analytics, with 5+ years in architect-level roles.
• 3+ years of hands-on Snowflake architecture at enterprise scale (SnowPro Advanced: Architect preferred).
• Deep expertise in data modeling (3NF, dimensional, Data Vault) and semantic layer design.
• Proven delivery of GenAI/agentic AI solutions in production (RAG, tool-calling agents, multi-agent workflows).
• Strong SQL and Python; experience with dbt, Airflow/Dagster, Kafka, and CI/CD (Git, Terraform).
• Experience on at least one major cloud (AWS, Azure, or GCP).
• Solid understanding of data governance, security, and privacy frameworks.
• Excellent communication, stakeholder management, and leadership skills.

Responsibilities

• Own the end-to-end architecture of the Snowflake Data Cloud: ingestion, storage, transformation, serving, and consumption.
• Design scalable, cost-efficient solutions using Snowflake features such as Snowpipe, Streams & Tasks, Dynamic Tables, Snowpark, Iceberg tables, Secure Data Sharing, and Marketplace.
• Define standards for performance tuning, warehouse sizing, clustering, and FinOps/cost governance.
• Lead modernization and migration from legacy platforms to Snowflake.
• Architect enterprise semantic layers, including business metrics, dimensions, hierarchies, and entity relationships.
• Own metadata, lineage, and data contracts across domains (data mesh / data product).

Skills

Snowflake architecture

Data modeling

GenAI / agentic AI

SQL

Python

dbt

Airflow

Kafka

CI/CD

Cloud platforms (AWS/Azure/GCP)

Tools

dbt

Airflow

Dagster

Kafka

Terraform

Git

Job description

Damco Solutions is seeking a Principal AI & Data Architect to define and lead our enterprise data and AI architecture. You will design a Snowflake-centric data platform with a strong semantic layer and build foundations for agentic AI systems that reason over trusted data.

As a hands-on technical leader, you will partner with business, engineering, and security teams to turn data into reliable, AI-ready products, mentor engineers, and translate strategy into roadmaps.