Role roadmaps / Data Architect Role roadmap
Choose contracts: grain, ownership, lake vs warehouse, and what you will not build. You still need to have shipped.
Also called: Analytics Architect, Platform Architect
You ship: A platform sketch the org can fund, plus the standards that keep it from rotting.
Years of shipping first. This is not an entry role.
Roadmap Coding Interview Question bank Switch roleData Analyst BI Analyst Data Engineer Analytics Engineer Data Scientist ML Engineer MLOps Engineer AI Engineer Data Architect Nearby roles:Data Engineer , MLOps Engineer , Analytics Engineer
→
Skill check10 questions Already working in this role? Answer honestly and the roadmap ticks what you have done, then points you at the first gap.
Take the 2-minute skill check 1 of 10
Can you do this?
1 Yes, I have done this2 Partly3 Not yet
Back Keys 1, 2 and 3 answer while the check has focus.
Result
Ticks are only added, never removed. Partly and Not yet leave a skill unticked.
Checked skills
0% · pick any skill to see its syllabus, links and practice.
Journey Map List
− Fit + Print Clear checks
RTE
Stop 1 of 16
◀ Prev StopNext Stop ▶ Auto Cruise
Click any bus stop to drive there and inspect the complete syllabus, or scroll the highway to follow the bus.
Terminal Start · Station 1 of 16
Click to stop Start · Data Architect A platform sketch the org can fund, plus the standards that keep it from rotting. Inspect station brief →
Checkpoint · Station 2 of 16
Click to stop Foundations The tools you cannot fake in week one Inspect station brief →
Bus Stop · Station 3 of 16
Click to stop Enterprise modeling Domains, contracts, and why one big lake is not a model. Open Syllabus →
Bus Stop · Station 4 of 16
Click to stop Still SQL You cannot review a mart you cannot query. Open Syllabus →
Bus Stop · Station 5 of 16
Click to stop Unit economics of data Credits, slots, storage, and failed jobs as a line item. Open Syllabus →
Checkpoint · Station 6 of 16
Click to stop Daily craft What you actually do on a Tuesday Inspect station brief →
Bus Stop · Station 7 of 16
Click to stop Warehouse vs lakehouse Iceberg as a contract. When two engines are worth it. Open Syllabus →
Bus Stop · Station 8 of 16
Click to stop Governance that people use Catalog, lineage, and masking that does not block the analyst. Open Syllabus →
Bus Stop · Station 9 of 16
Click to stop SLAs and ownership Who pages, who pays, who may publish gold. Open Syllabus →
Checkpoint · Station 10 of 16
Click to stop How you ship Production habits, not extra courses Inspect station brief →
Bus Stop · Station 11 of 16
Click to stop Paved roads A default ingest, a default transform, a default BI path. Exceptions are written down. Open Syllabus →
Bus Stop · Station 12 of 16
Click to stop Migrations without heroics Hive to Iceberg, Synapse to Fabric — dual-run, then cut. Open Syllabus →
Checkpoint · Station 13 of 16
Click to stop Career moves How this role talks in interviews Inspect station brief →
Bus Stop · Station 14 of 16
Click to stop Architect interview A platform sketch, a cost story, and a time you said no. Open Syllabus →
Bus Stop · Station 15 of 16
Click to stop Stay sharp Keep a pipeline in production. Architecture without on-call rot. Open Syllabus →
Final Destination · Station 16 of 16
Click to stop Keep practicing SQL + Python for this role Inspect station brief →
Start · Data Architect Foundations Enterprise modeling Domains, contracts, and why one big lake is not a model. Still SQL You cannot review a mart you cannot query. Unit economics of data Credits, slots, storage, and failed jobs as a line item. Daily craft Warehouse vs lakehouse Iceberg as a contract. When two engines are worth it. Governance that people use Catalog, lineage, and masking that does not block the analyst. SLAs and ownership Who pages, who pays, who may publish gold. How you ship Paved roads A default ingest, a default transform, a default BI path. Exceptions are written down. Migrations without heroics Hive to Iceberg, Synapse to Fabric — dual-run, then cut. Career moves Architect interview A platform sketch, a cost story, and a time you said no. Stay sharp Keep a pipeline in production. Architecture without on-call rot. Keep practicing Phase 1: Foundations Enterprise modeling Domains, contracts, and why one big lake is not a model. Still SQL You cannot review a mart you cannot query. Unit economics of data Credits, slots, storage, and failed jobs as a line item. Phase 2: Daily craft Warehouse vs lakehouse Iceberg as a contract. When two engines are worth it. Governance that people use Catalog, lineage, and masking that does not block the analyst. SLAs and ownership Who pages, who pays, who may publish gold. Phase 3: How you ship Paved roads A default ingest, a default transform, a default BI path. Exceptions are written down. Migrations without heroics Hive to Iceberg, Synapse to Fabric — dual-run, then cut. Phase 4: Career moves Architect interview A platform sketch, a cost story, and a time you said no. Stay sharp Keep a pipeline in production. Architecture without on-call rot.
Enterprise modeling Domains, contracts, and why one big lake is not a model.
Checked automatically: you solved the linked practice problems.
Domains, contracts, and why one big lake is not a model.
Time to learn Domains, contracts, not one big lake.
What you need Contracts article Glossary A domain map Concepts to study Bounded contexts / data domains Contracts as the architectural primitive Canonical vs serving models Avoiding the “enterprise data model” that nobody ships Tech stacks dbt + catalogs — ImplementationData contracts article — The ideaHow to study Contracts article. Sketch three domains and the events between them. What to produce Three domains and the events between them Named contract owners Pitfalls One lake to rule them all with no owners A 400-entity ERD as the delivery plan Interview prompts What is a domain here, and who owns the contract? Links
Previous skill Next skill
Mark as done Search DataLane All Articles Stacks Practice Learn Pages
No results. Try analyst, numpy, snowflake, or roadmap.
↑↓ navigatealt ↑↓ jump group↵ openesc closeAliases: sf, numpy, analyst, mlops