Lead Data Architect

Estuate Inc.
Milpitas, United States
14 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
2 years minimum
Working hours
Regular working hours
Job source

Tech stack

Airflow Amazon Web Services Audit Trail BigQuery Software Quality Continuous Integration Data Architecture Information Engineering Data Governance Data Infrastructure Data Integration Extract Transform Load (ETL)
+23 more
Data Security Dimensional Modeling Monitoring of Systems Identity and Access Management Key Management Meta-Data Management Performance Tuning Role-Based Access Control Power BI SQL Databases SQL Server Integration Services Data Streaming Tokenization Enterprise Data Management Google Cloud Azure Data Factory Snowflake Togaf Apache Kafka Data Management Stream Analytics Amazon Redshift Databricks

Job description

lake/warehouse solutions (e.g., AWS Redshift/Snowflake/Databricks/BigQuery/Synapse), including performance, partitioning, and cost optimization. Ā· Lead data integration and ETL/ELT architecture using tools like SSIS/Informatica/dbt/ADF/Glue/Airflow. Ā· Own data modeling strategy: conceptual/logical/physical models, dimensional modeling, and canonical models for key domains. Governance, Quality, and Security Ā· Define and enforce data governance: classification, retention, access controls, and stewardship models. Ā· Establish data quality frameworks (rules, controls, monitoring), ensuring trusted datasets and consistent KPIs. Ā·Ensure compliance with security and regulatory requirements (PII/PHI/PCI/SOX/GDPR), including encryption, tokenization, and least privilege access. Stakeholder & Program Leadership Ā· Partner with Product Owners, Engineering, Security, and business leaders to align architecture with strategic outcomes. Ā· Lead architecture reviews, design approvals, and technical

Requirements

decision forums; document ADRs (Architecture Decision Records). Ā· Mentor data engineers/analysts; set engineering standards for code quality, CI/CD, and operational excellence. Ā· Drive vendor evaluation and selection; support contracting, SOW reviews, and implementation oversight. Required Qualifications Ā· 8-12+ years in data architecture / data engineering / enterprise data platform roles, with 2-5+ years leading architecture. Ā· Strong experience designing cloud-scale data platforms (lake/warehouse/lakehouse) and data integration patterns. Ā· Proven expertise in: o Data modeling (dimensional, normalized, semantic models) o ETL/ELT and pipeline orchestration o SQL and performance tuning o Data governance, lineage, and metadata management concepts Ā· Strong understanding of modern data security patterns: IAM/RBAC/ABAC, encryption, key management, and audit logging. Ā· Experience communicating architecture to both technical and non-technical stakeholders; ability to drive consensus. Preferred Qualifications (Nice to Have) Ā· Experience with Amazon Redshift, Power BI, and enterprise semantic modeling (tabular models, star schemas, DAX optimization). Ā· Exposure to data mesh, domain-based ownership, and data product operating models. Ā· Experience with streaming/event platforms (Kafka/Kinesis) and real-time analytics patterns. Ā· Familiarity with ML/AI enablement (feature stores, model monitoring, governance). Ā· Certifications: AWS/Google Cloud Platform/Azure data certs, TOGAF (optional), DAMA/CDMP (optional). Key Deliverables Ā· Enterprise data architecture target state and roadmap Ā· Reference architectures, patterns, standards, and ADRs Ā· Data platform designs (ingestion * processing * storage * serving) Ā·Data models and semantic layer strategy (BI-ready, governed KPIs) Ā· Governance artifacts: classification, lineage, stewardship, access model Ā· Performance/cost optimization recommendations and runbooks Success Metrics Ā· Reduced time to deliver trusted datasets / analytics products Ā· Improved data quality scores and reduction in recurring data defects Ā·Increased adoption of governed datasets and standardized KPIs Ā· Platform performance and cost eAiciency (SLA attainment, optimized spend) Ā· Audit readiness and reduction in compliance findings

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:15 min

Empowering domain teams with an open data platform

Sandhya Menon Sandhya Menon Ā· World Congress 2026 Europe

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou Ā· Coffee With Developers

2:30 min

Leveraging BigQuery ML for scalable SQL-based segmentation experiments

Julian Joseph Ā· LIVE

3:05 min

Audience questions on AI agents and pipeline vectorization

Joy Joy Ā· World Congress 2024

3:27 min

Explaining query execution overhead and caching limitations in BigQuery

Adnan Rahic Ā· JS Congress

1:42 min

System architecture for ingesting and processing enterprise data

Sandeep Kusuma Sandeep Kusuma Ā· World Congress 2026 Europe

Videos

See all

Related articles

See all