> Markdown version of [/jobs/ext/4641077-lead-data-architect](https://www.wearedevelopers.com/jobs/ext/4641077-lead-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Data Architect

- **Company:** Dynatrace LLC
- **Location:** New York, NY, United States
- **Experience:** Expert
- **Salary:** $160,000.0 - $180,000.0
- **Contract:** Permanent contract
- **Skills:** Third Normal Form, Application Programming Interfaces (APIs), Artificial Intelligence, Amazon Web Services, Microsoft Azure, Cloud Computing, Data Architecture, Information Engineering, Data Infrastructure, Extract Transform Load (ETL), Data Security, Data Warehousing, Software Design Patterns, Dimensional Modeling, Operational Data Store, Open Source Technology, Performance Tuning, Raw Data, Role-Based Access Control, Power BI, Search Technologies, Tableau (Software), Management of Software Versions, Enterprise Data Management, Retrieval-Augmented Generation, Large Language Models, Snowflake, Agentic-AI, Data Lakes, Infrastructure Automation Frameworks, Graphql, Api Design, Entity Resolution, Databricks
- **Published:** November 8, 2026
- **Apply:** https://www.careerbuilder.com/job-details/lead-data-architect-new-york-ny--c2c66437-73e7-4cfb-9b34-a8854f54f029

## About the Role

DataArchitect Data Modeling Tool, DataArchitect Data Modeling Tool, Technical Leadership, Data Modeling, Architectural Services, Data Warehousing, Data Lake, Artificial Intelligence (AI), Dimensional Modeling, Business Model, * 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

## Description

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