Lead Data Architect

About the role

Your role at Dynatrace As a Lead Data Architect you will provide hands-on technical leadership 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.

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

• 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 ELT/ETL 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

Skills

• 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

Pay

Salary range: $160K - $180K (DOE). Total compensation may vary depending on candidate experience/education and location.

Benefits

• Health
• Dental
• Life
• STD
• LTD
• 401K
• PTO

Schedule

Remote eligible. Candidates within a 45‑mile radius of Boston, MA; Detroit, MI; or Denver, CO are required to work hybrid (2 days per week) in the office. All candidates must work EST hours.