Principal Data Architect (Snowflake)

TL;DR

Principal Data Architect (Snowflake): Leading the design and evolution of a cloud-native data platform with an accent on medallion/lakehouse patterns and robust data governance. Focus on architecting scalable Snowflake environments, integrating complex ingestion stacks, and translating technical trade-offs for executive stakeholders.

Location: Must be authorized to work in the U.S. without sponsorship. Remote or hybrid options available.

Company

A modern product engineering partner blending strategy, craftsmanship, and speed to help organizations modernize in the age of AI.

What you will do

• Design and evolve scalable Snowflake architectures incorporating medallion and lakehouse patterns with schema evolution strategies.
• Architect and implement data governance and security frameworks, including RBAC and dynamic data masking using Snowflake Horizon.
• Lead integration design across the ingestion stack, including Fivetran, CData, dbt, Snowpark, and Salesforce.
• Collaborate with Azure teams to design storage, networking, and private connectivity patterns for Azure SQL source systems.
• Build consumption and cost forecasting models and articulate architectural trade-offs to executive stakeholders.
• Define and enforce standards for data modeling, pipeline design, data quality, lineage, and observability.

Requirements

• Deep hands-on Snowflake architecture experience; SnowPro Advanced: Architect certification strongly preferred.
• Proven track record designing medallion/lakehouse patterns and managing schema evolution at enterprise scale.
• Strong Azure data-platform experience including storage, networking, and private connectivity.
• Expert-level understanding of data governance, classification, tagging, and Snowflake Horizon for PII.
• Hands-on familiarity with Fivetran, CData, dbt, and Snowpark.
• Must be authorized to work in the U.S. without sponsorship.

Nice to have

• Exposure to Snowflake Cortex AI, LLM-on-warehouse capabilities, semantic model design, RAG database table design, or Cortex Search.
• Experience in AI or a proven track record of rapidly learning and mentoring others on emerging tech.

Culture & Benefits

• Remote or hybrid work options.
• Competitive salary and bonus opportunities.
• Robust benefits package, including a matching 401(k) plan and substantial PTO.
• Ongoing investment in growth through training, mentorship, and industry certifications.
• Tuition reimbursement and recognition programs like the AI Innovators Program.