Architecture · Growing
Data Architect: Skills, Projects & Interview Questions (2026)
Design enterprise data architecture, models and governance.
What a Data Architect actually does
Designing enterprise data architecture, models, governance and platforms.
Top hiring companies: Microsoft, Amazon, Databricks, Snowflake, Deloitte, Accenture.
Top industries: Finance, Retail, Healthcare, Consulting, Telecom.
Skills you need to become a Data Architect
| Skill | Importance | Learning hours | Interview weight |
|---|---|---|---|
| Data Modeling | 10/10 | ~60h | High |
| Data Warehousing | 10/10 | ~60h | High |
| Cloud Data Platforms | 10/10 | ~70h | High |
| SQL | 9/10 | ~40h | High |
| Data Governance | 9/10 | ~40h | High |
| Lakehouse Architecture | 9/10 | ~40h | High |
| ETL/ELT Design | 9/10 | ~50h | High |
| Big Data (Spark/Hadoop) | 8/10 | ~60h | High |
| Data Security & Compliance | 8/10 | ~40h | Medium |
| Stakeholder & Solutioning | 8/10 | ~30h | High |
Core tools: Snowflake / Databricks, ERwin / dbdiagram, Apache Spark, Collibra / Purview, Azure / AWS / GCP, dbt.
Data Architect learning roadmap
Beginner · 3-5 months
Foundations & core tooling
Build: Design a normalized + star-schema data model for a sample domain.
Intermediate · 5-6 months
Applied, real-world builds
Build: Architect a cloud warehouse/lakehouse with governance and ETL design.
Advanced · 6-8 months
Production, scale & specialization
Build: Deliver an enterprise data architecture with lakehouse, governance and compliance controls.
10 Data Architect portfolio projects
Normalized + Star Model
BeginnerDesign OLTP and star-schema models.
Skills: Data Modeling, SQL
Warehouse Design
BeginnerDesign a warehouse for a domain.
Skills: Data Warehousing, Data Modeling
Lakehouse Architecture
IntermediateBronze/silver/gold lakehouse design.
Skills: Lakehouse, Data Modeling, Cloud
Governance Framework
IntermediateCatalog, ownership and access design.
Skills: Data Governance, Data Modeling
ETL/ELT Design
IntermediateDesign ingestion and transformation.
Skills: ETL/ELT Design, Data Modeling
Cost & Performance Plan
IntermediatePartition/cluster and cost strategy.
Skills: Data Warehousing, Cloud
Enterprise Data Platform
AdvancedFull platform: ingest -> govern -> consume.
Skills: System Design, Lakehouse, Governance
Master Data Management
AdvancedMDM design for a key entity.
Skills: Data Modeling, Data Governance
Migration Architecture
AdvancedLegacy-to-cloud data migration design.
Skills: Cloud, Data Modeling, ETL
Data Mesh Design
AdvancedDomain-oriented data product design.
Skills: Data Modeling, Governance
Common Data Architect interview questions
What is a slowly changing dimension? Types?Hard
What they're testing: Track history; Type 1 overwrite, Type 2 versioned
ETL vs ELT — when to use each.Medium
What they're testing: Transform before vs in the warehouse
How do you manage and optimize cloud cost?Medium
What they're testing: Right-size, autoscale, reserved, monitoring
What is an index and what are its trade-offs?Medium
What they're testing: Speeds reads, slows writes, uses storage; B-tree on filter/join cols
How do you handle schema evolution in pipelines?Hard
What they're testing: Contracts, versioning, backward compatibility
When to use broadcast join vs shuffle join.Medium
What they're testing: Small table broadcast avoids shuffle
Fact vs dimension tables.Easy
What they're testing: Measures/events vs descriptive context
How do you ensure data quality in a warehouse?Medium
What they're testing: Tests, constraints, monitoring, contracts
Explain VPC/networking basics in the cloud.Medium
What they're testing: Subnets, routing, security groups
Explain a CTE vs a subquery vs a temp table.Medium
What they're testing: Readability, reuse, materialization and scope differences
Where do you put data-quality checks in a pipeline?Medium
What they're testing: At ingestion and post-transform with alerting
How does partitioning affect performance?Medium
What they're testing: Parallelism and shuffle volume
Certifications for Data Architects
- AWS Certified Solutions Architect - AssociateAmazon Web Services · Very High value
- Google Cloud Professional Data EngineerGoogle Cloud · Very High value
- SnowPro Core CertificationSnowflake · Very High value
- Microsoft Certified: Azure Solutions Architect Expert (AZ-305)Microsoft · Very High value
Data Architect career path
Data Architect -> Senior Data Architect -> Chief Data Architect
Related roles: Solution Architect, Data Engineer, Cloud Architect
Frequently asked questions
What skills do you need to become a Data Architect?
Core skills include Data Modeling, Data Warehousing, Cloud Data Platforms, SQL, Data Governance. Show a clear architecture with governance and trade-offs.
What projects should a Data Architect build for a portfolio?
Strong starter projects: Normalized + Star Model; Warehouse Design; Lakehouse Architecture; Governance Framework.
How long does it take to become job-ready as a Data Architect?
A focused plan runs roughly 3-5 months for fundamentals, then applied projects. Difficulty rating: 8/10.
What is the career path for a Data Architect?
Data Architect -> Senior Data Architect -> Chief Data Architect
Ready to become a Data Architect?
PrepNPlaced turns this guide into action — a day-by-day roadmap, ATS-ready resume, and real interview practice.
Start free →