About the Position

Lead Data Architect - Snowflake

Full-time

Remote

United States

Engineering

Experienced and Senior

Job Id: 5991

About the Role

As a Lead Data Architect at Dynatrace, you will provide hands-on technical leadership in 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 Dynatrace office. Candidates are required to work EST hours for this position.

Key Responsibilities

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

Requirements

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

We Offer

Competitive compensation: salary $160K - $180K, plus Health, Dental, Life, STD, LTD, 401K, PTO
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.

Benefits and Work-Life Perks

Mental health support through our Employee Assistance Program, powered by Telus Health
Wellness Days: Four company-designated extra paid days off for you to recharge
Flexibility: Our hybrid working model and flexible working hours offer you the flexibility you need
AI-driven workflows to automate tasks and focus on what matters
Learn & develop: Company-wide learning perks, designated team's learning days, and more
Volunteering day: A day of paid volunteer time to support a community or cause you care about
Regular team events: Global Culture Parties, Family & Friends at Work Day, Global Breakfasts, Green Weeks, Pride Month, and beyond!
International vibe: Most of our offices and teams are proudly multicultural. English is our shared language, but we embrace and learn from each other's cultures

About Dynatrace

Dynatrace (NYSE: DT) is the leading AI-powered observability and security platform. We're advancing observability for today's digital businesses, helping transform modern digital ecosystems' complexity into powerful business assets.

Our AI-driven insights cut through the noise, allowing customers to focus on what truly matters by automating manual tasks and resolving issues with pinpoint accuracy. Dynatrace offers simplicity, clarity, and reliability at scale to ensure teams can make informed decisions, minimize downtime, and drive their business forward with confidence.

Great Place To Work®

We’re proud to be certified as a Great Place To Work® in 16 countries-an achievement made possible by feedback from our greatest asset: an incredible team. We couldn’t have done it without them.

Equal Employment Opportunity

All your information will be kept confidential according to EEO guidelines. 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.

Discover More

Let's Work Together

All jobs Being a Dynatracer

Lead Data Architect - Snowflake

Job description

About the Position