Lead Data Architect

Dynatrace LLC; Northern (KY); Hybrid; USD 160,000 - 180,000; Full time

Benefits offered by this job

Health benefits

401K plan

Paid time off

Hybrid work model

Flexibility in hours

Job summary

Dynatrace is seeking a Lead Data Architect to shape how data is modeled, stored, and accessed across the enterprise data platform. You will own standards for Bronze/Silver/Gold data layers and enable AI-ready assets for downstream applications.

You will lead architecture discussions, mentor engineers, and partner with business/BI teams to connect Snowflake models to dashboards. This is a remote-eligible role with EST hours; candidates near Boston, MA; Detroit, MI; and Denver, CO may work hybrid

Qualifications

• 8+ years in data engineering, analytics, or data architecture with technical leadership.
• Deep Snowflake expertise including RBAC/RLS, dynamic tables and performance tuning.
• Experience implementing Medallion Architecture at scale.
• Strong 3NF and dimensional modeling in production environments.
• Hands-on semantic layer design and BI tool integration (dbt, Tableau, PowerBI).
• Elastic ETL/ELT patterns; maintainable, observable pipelines.
• Experience with data APIs (REST/GraphQL) and data ownership models.

Responsibilities

• Design enterprise data models across domains using 3NF and Dimensional Modeling.
• Enforce Medallion Architecture layers Bronze/Silver/Gold and curation rules.
• Set ELT guardrails: source alignment, incremental load, failure handling.
• Architect semantic layer for AI apps; ontology and entity resolution.
• Define APIs and interface standards between data platform and analytics workloads.
• Design RBAC/RLS reflecting business data ownership without bottlenecks.
• Collaborate with BI teams to map Snowflake models to dashboards and datasets.
• Coordinate architecture reviews and mentor engineers.

Skills

Snowflake RBAC/RLS

Medallion Architecture

3NF & Dimensional Modeling

Semantic Layer (dbt/Tableau/PowerBI)

ETL/ELT Patterns

Llama/AI integration patterns (RAG)

API design (REST/GraphQL)

Cloud infra (AWS/Azure/GCP)

RBAC & security design

Data modeling leadership

Tools

Snowflake

Databricks

Delta Lake

Unity Catalog

dbt

Tableau/PowerBI

Job description

# Lead Data Architect## **Your role at Dynatrace**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## **What will help you succeed****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## **Why you will love being a Dynatracer*** 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.## **Compensation and Rewards**DOE, salary $160K - $180K, plus Health, Dental, Life, STD, LTD, 401K, PTO. Total compensation may vary depending on candidate experience/education and location.## **Equal Employment Opportunity**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 [e-mail]. 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.**Note to Recruiters and Agencies**: Thank you for your interest in Dynatrace. Please note that **we do not accept unsolicited agency resumes**—do not forward them via our website or directly to Dynatrace employees. Dynatrace will not pay fees for unsolicited resumes, and any resumes received this way will be considered the property of Dynatrace.## Benefits and work-life perksWe offer best-in-class core rewards, including paid time off, financial security benefits, retirement savings plans, and health insurance. Beyond that, you’ll get other benefits and work-life perks designed to make your ride with us even more rewarding.#### Mental health supportOur Employee Assistance Program, powered by Telus Health, offers support for you and your family members.#### Wellness DaysFour company-designated extra paid days off for you to recharge batteries.#### FlexibilityOur hybrid working model and flexible working hours offer you the flexibility you need.#### AI-driven workflowsUse AI as your daily teammate to automate tasks and focus on what matters.#### Learn & developCompany-wide learning perks, designated team's learning days, and more.#### Volunteering dayA day of paid volunteer time to support a community or cause you care about.#### Regular team eventsWe host Global Culture Parties, Family & Friends at Work Day, Global Breakfasts, Green Weeks, Pride Month, and beyond!#### International vibeMost of our offices and teams are proudly multicultural. English is our shared language, but we embrace and learn from each other's cultures.Rewards vary depending on your employment type. Some benefits and perks also differ by location — explore your city to see what’s available there.