Designs how all the data pieces fit together before anyone builds them.
How to get here
Salary (US) as of 2026-11
Median$140K
Typical range$113K–$204K
Sources:
- BLS OES, Database Architects (15-1243), May 2025median $139,500; 10th $86,240, 90th $204,000
- Glassdoor, Data Architect, US, 2026total pay median $181K; base $113K-181K; likely range $141K-234K
- PayScale, Data Architect, US, Jun 2026base median $137K; 10th-90th $86K-181K (543 profiles)
- KORE1, Data Architect job description template, 2026mid $115K-145K, senior $150K-185K, principal $185K-220K base
Enterprise/contract architect roles (12+ yrs) are quoted hourly, e.g. $54-68/hr in Houston.
Experience to get here
Entry level7-8 years total (3+ in architecture)
Typical title8-15 years
Bachelor's in CS or IT typical; BLS notes employers may prefer a master's in data management. Current postings list no degree and screen on years and tooling instead.
Typical prior roles
Senior Data EngineerDatabase AdministratorAnalytics Engineer / Data ModelerBI ArchitectEnterprise Architect
Must have
- Data modeling: Kimball dimensional, Data Vault; ERwin or PowerDesigner
- Expert SQL and Python; can read Spark
- One major cloud warehouse (Snowflake, BigQuery, Redshift, Synapse) plus dbt/Airflow and Iceberg or Delta
- Governance frameworks and a catalog (Collibra, Alation, Atlan)
- Explaining architecture decisions to executives
Milestones people hit first
- Wrote the target-state architecture (medallion layers, domains) a company then built
- Set naming, schema and modeling standards and ran design reviews
- Led a vendor evaluation and the migration that followed
- Designed the star schema a BI team still relies on
Certifications
Preferredin postings: sometimes
| Exam fee | $595 |
| Training | accredited course $1,000-3,000 optional; self-study with the standard |
| Renewal | no renewal stated on vendor page |
| Typical total | $595 combined exam (Pearson VUE); $395 per part |
Time: 6-10 weeks of study
Prerequisites: none for Foundation; Foundation (or combined exam) before Practitioner
Listed as a 'must' in the Insight Global enterprise data architect posting; common where architecture sits inside IT.
Preferredin postings: sometimes
| Exam fee | $311 |
| Training | DAMA-DMBOK book (price not published by the vendor); self-study |
| Renewal | annual maintenance fee (amount not published) + activity attestation; initial validity 3 years |
| Typical total | $311 per exam; Associate to Practitioner adds electives |
Time: 2-4 months reading DMBOK
Prerequisites: Associate <2 yrs; Practitioner 2-10 yrs; Master 10+ yrs and CV review
Preferred 'or equivalent governance cert' in the KORE1 template; DAMA-DMBOK preferred in the Insight Global posting.
Preferredin postings: sometimes
| Exam fee | $150 |
| Training | AWS Skill Builder free tier; paid practice exams optional |
| Renewal | pass latest exam every 3 years |
| Typical total | $150-300 |
Time: 130-minute exam, 65 questions; 2-3 months prep
Prerequisites: 2-3 yrs data engineering and 1-2 yrs hands-on AWS recommended
One of three cloud DE certs the KORE1 template lists as preferred for architects.
Nice to havein postings: sometimes
| Exam fee | $200 |
| Training | Google Cloud Skills Boost paths (some labs need credits) |
| Renewal | retake every 2 years |
| Typical total | $200-400 |
Time: 2-hour exam; ~8 weeks prep
Prerequisites: 3+ yrs industry incl. 1+ yr designing on Google Cloud recommended
Preferred in the KORE1 template for BigQuery-based shops.
Nice to havein postings: sometimes
| Exam fee | not published |
| Training | free Microsoft Learn modules |
| Renewal | $0; free online renewal assessment |
| Typical total | exam fee varies by country (pricing on request) |
Time: 100-minute exam; 6-8 weeks prep
Prerequisites: SQL, PySpark and KQL familiarity expected; replaces the retired DP-203
The Azure-side credential; the template still cites Azure Data Engineer Associate, which Microsoft retired for DP-700.
Nice to havein postings: rarely
| Exam fee | $175 |
| Training | free Snowflake Hands-On Essentials badges |
| Renewal | validity period not stated on vendor page |
| Typical total | $175 (third-party figure; vendor page does not list fees) |
Time: 115-minute exam, 100 questions; 4-6 weeks of prep
Prerequisites: 6+ months of Snowflake use (candidate profile)
Useful in Snowflake-centric architectures; an Architect-level SnowPro tier exists.
Training & learning
- The Data Warehouse Toolkit, 3rd ed.
Kimball Group · book · book purchase (price not shown) · a few weeks, then referenceDimensional modeling (grain, facts, dimensions, SCDs) is the design vocabulary behind most marts and BI models.
- DAMA-DMBOK, 2nd ed.
DAMA International · book · book purchase (price not published by the vendor) · ongoing referenceThe vendor-neutral framework for governance, modeling and architecture; the knowledge base behind CDMP.
- Fundamentals of Data Engineering
O'Reilly (Reis & Housley) · book · book purchase (price not shown) · 2-4 weeksThe standard overview of the data engineering lifecycle, from ingestion to serving; widely cited by practitioners.
- dbt Fundamentals FREE
dbt Labs (dbt Learn) · course · free · about 5 hoursVendor's free on-ramp to models, tests and docs; follow with the free Jinja, materializations and refactoring courses.
- Snowflake Hands-On Essentials badges FREE
Snowflake · learning path · free · 6 workshops (hours per badge not listed)Free hands-on badges (warehousing, data lake, data engineering) that prove Snowflake skills before paying for SnowPro.
- Upskill on Databricks in 1 hour (lakehouse fundamentals) FREE
Databricks · course · free · about 1 hourFree intro to lakehouse concepts with a badge; the cheapest way to speak Databricks before interviews.
Sources & notes
- BLS OOH, Database Administrators and Architects (15-1243), May 2025 wages
- Glassdoor, Data Architect salaries, US, Pay Trends 2026
- PayScale, Data Architect salary (updated Jun 9, 2026)
- Insight Global, Enterprise Data Architect posting, Houston (TOGAF required, DAMA-DMBOK preferred)
- KORE1, Data Architect job description template 2026 (CDMP and cloud DE certs preferred; salary bands)
- The Open Group, TOGAF certification portfolio
- The Open Group, certification examination fees
- DAMA International, CDMP information
- AWS Certified Data Engineer - Associate
- Google Cloud Professional Data Engineer
- Microsoft Learn, Fabric Data Engineer Associate (DP-700)
- Microsoft Learn, Azure Data Engineer Associate (DP-203) - retired 03/31/2025
- Snowflake, SnowPro Core Certification
- The Data School, How to pass SnowPro Core ($175, 115 min, 100 questions)
- Kimball Group, The Data Warehouse Toolkit, 3rd ed.
- DAMA-DMBOK (Data Management Body of Knowledge), 2nd ed.
- O'Reilly, Fundamentals of Data Engineering (Reis & Housley, 2022)
- dbt Learn, dbt Fundamentals
- dbt Labs blog, new dbt Learn courses (five free courses, durations)
- Snowflake Hands-On Essentials track (free badges)
- Databricks free training: lakehouse fundamentals
TOGAF validity/renewal is not stated on The Open Group's page. CDMP passing scores and DMBOK price are not on DAMA's pages. The two sources split: TOGAF required in one posting, absent from the template; CDMP the reverse, so both are 'sometimes'.
Figures are US, from the sources listed, and change often; verify before deciding.