Lead Data Architect - Snowflake

As a Lead Data Architect you will provide hands-on technical leadership role defining how data is modeled, structured, and consumed across our enterprise data platform.

You will own the architectural standards that turn raw data into trusted, reusable, and AI-ready assets across our data warehouse, data lake, and the downstream applications and models that depend on them.

This is a remote eligible position. Candidates who live within a 45 mile radius of Boston, MA; Detroit, MI; and Denver, CO will be required to work hybrid (2 days per week) out of our Dyntrace office. Candidates are required to work EST hours for this position.

Key Responsibilies

• Design enterprise data models across core business domains using 3rd Normal Form and Dimensional Modeling knowing when each is the right tool and being able to defend the tradeoff
• Define and enforce the Medallion Architecture layering strategy — what belongs in Bronze, Silver, and Gold, when curation adds value vs. overhead, and how raw data can be responsibly exposed to downstream consumers
• Set guardrails for ELT pipeline architecture: source alignment, incremental load strategies, and failure handling expectations
• Architect and build the semantic layer for LLM-powered applications — ontology design, entity resolution, metadata enrichment, and how structured datasets are surfaced to AI agents and RAG pipelines
• Define interface standards between the data platform and analytics/application workloads — API source design patterns, latency SLAs, and the boundary between warehouse and operational data store.
• Design RBAC and RLS implementations that reflect how the business organizes around data, without making access a bottleneck
• Partner with business and BI teams to connect Snowflake data models to BI tool implementations, drive dataset adoption, and translate business questions into reusable modeled assets
• Author modeling standards, and platform guidelines; conduct architecture reviews; and mentor data and analytics engineers

Required

• 8+ years in data engineering, analytics engineering, or data architecture, with at least 3 years in an architecture or technical leadership capacity
• Deep hands-on experience with Snowflake — dynamic tables, RBAC/RLS, column masking, performance optimization
• Proven experience designing Medallion Architecture at enterprise scale
• Strong command of both 3NF and Dimensional Modeling in production environments
• Experience architecting a semantic layer — dbt Semantic Layer, Tableau / PowerBI, or equivalent
• Hands-on experience with Etl/ELT methods, dbt and the patterns that make pipelines maintainable, testable, and observable
• Track record of driving dataset adoption in partnership with business and BI stakeholders

Desirable

• Experience with Databricks, Delta Lake, or Snowflake Unity Catalog
• Exposure to LLM integration patterns — RAG, semantic search, structured data grounding, agentic data access
• Experience with data API design — REST or GraphQL over warehouse data, contract management, versioning
• Familiarity with domain-oriented data ownership models and what makes them succeed organizationally
• Working knowledge of cloud infrastructure (AWS, Azure, or GCP) and infrastructure-as-code practices
• Contributions to open-source tooling or published architectural thinking

• Dynatrace is a leader in unified observability and security.
• We provide a culture of excellence with competitive compensation packages designed to recognize and reward performance.
• Our employees work with the largest cloud providers, including AWS, Microsoft, and Google Cloud, and other leading partners worldwide to create strategic alliances.
• You'll get to work at the forefront of innovation with Dynatrace Intelligence—the industry's first agentic operations system. Bringing together deterministic and agentic AI, it helps teams understand what's happening, why it matters, and what to do next— automatically.
• Over 50% of the Fortune 100 companies are current customers of Dynatrace.

DOE, salary $160K - $180K, plus Health, Dental, Life, STD, LTD, 401K, PTO. Total compensation may vary depending on candidate experience/education and location.

All your information will be kept confidential according to EEO guidelines.

We offer competitive compensation, company-sponsored premium benefits, medical, dental, vacation/holidays, company matching 401(k) Plan, etc. Dynatrace is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, sex, color, gender identity, religion, national origin, ancestry, citizenship, physical abilities, age, sexual orientation, creed, disability status, veteran status, pregnancy, genetic status, or any other characteristic protected by law. If your disability makes it difficult for you to use this site, please contact [email protected]. Dynatrace participates in E-Verify, participant information in English and Spanish. Right to work information in English and Spanish. EEO is the Law. To be considered for this position, please upload your resume/CV.