For students and early-career professionals

Data Architect

Designs how data is structured and governed across databases and platforms.

14 chapters · About 3 months · 15–30 min a day

Start this plan free →

Chapter 1 is free.

Skills

14 skills, and what you'll learn in each

Each skill is a few short lessons, then practice. You rate yourself at the start and again at the end.

Core to the job

Chapter 2

Data modeling

Organise data into linked tables and describe each column

What you'll learn

  • Table grain
  • Primary key
  • Table relationships
  • Normalised design
  • Star schema
  • Model levels
  • Transactional and analytical

Practice

  • Sketch a data model for a small app30 min
  • Draw the same model three ways25 min
  • Pick the storage shape for three workloads20 min

Chapter 5

SQL

Write queries that filter and summarise data and join tables

What you'll learn

  • Query output shape
  • Join logic
  • Grouping level
  • Query plan

Practice

  • Write Five Basic SQL Queries on a Real Dataset15 min

Chapter 6

Data architecture

Label a data system's parts and sketch how data flows

What you'll learn

  • Data warehouse
  • Lakehouse platforms
  • Data pipeline
  • Data catalog
  • Build versus buy
  • Storage shape choice
  • Current before target
  • Architecture trade-off

Practice

  • The decision record for a choice you already made45 min

Chapter 6

Cloud data platforms

Query a cloud database and check costs before adding data

What you'll learn

  • Cloud service choice
  • Object storage
  • Managed warehouse
  • Cloud costs
  • Permission basics
  • What a query costs
  • Reading less data

Practice

  • Run a SQL Query in a Free Cloud Sandbox20 min

Chapter 7

Data quality

Write checks for a table and run them before sharing

What you'll learn

  • Data checks
  • Plausible values
  • Root cause fix

Practice

  • Classify Eight Datasets and Defend the Two Hardest Calls25 min

Chapter 8

Data privacy

Spot privacy and bias risks, and drop needless data

What you'll learn

  • Data minimisation
  • Consent and access
  • Group performance gaps
  • Small group risk
  • Early risk escalation
  • Sensitive data inventory
  • Retention schedule
  • Subject access request

Practice

  • Decide what data to collect for one feature20 min

8 more in the plan

PythonSummarise a data file and write a small reusable functionCh 5

What you'll learn

  • Data frame basics
  • Function inputs and outputs
  • Read a traceback
  • Clear code names

Practice

  • Load a CSV and Summarise It in a Jupyter Notebook20 min
Data pipelinesDescribe a data source, then automate copying its data dailyCh 6

What you'll learn

  • ETL and ELT
  • Pipeline dependencies
  • Idempotent loads
  • Data quality checks
  • Safe backfills
  • Batch and streaming
  • Data contracts
  • Work across machines
Data cleaningClean a messy data set and note each fixCh 7

What you'll learn

  • Tidy table shape
  • First data profile
  • Missing value choice
  • Repeatable cleaning steps
CommunicationRewrite an update for two different readers, cutting extra linesCh 9

What you'll learn

  • Lead with the point
  • Match detail to the reader
  • Said versus heard
  • Specific feedback

Practice

  • Write a Six-Line Delay Message10 min
Working with othersContribute to group work, ask for help and credit teammatesCh 9

What you'll learn

  • Early team friction
  • Clear ownership
  • Challenge ideas, not people
  • Lead or follow
Documenting data workWrite data field definitions that others can use unaidedCh 9

What you'll learn

  • Metric definition
  • Data lineage
  • Assumptions and trade-offs
  • Documentation types

Practice

  • Design a simple data-issue tag taxonomy20 min
  • Write data dictionary entries for 5 fields25 min
Problem solvingTest each possible cause of a problem instead of guessingCh 10

What you'll learn

  • Problem vs symptom
  • Clean problem splits
  • Root cause
  • Deciding under uncertainty

Practice

  • Separate the Problem from the Symptom10 min
Adapting to changeTry a new tool and describe how you handled changeCh 10

What you'll learn

  • Change vs your response
  • The messy in-between
  • Not there yet
  • Real change vs a feeling

Practice

  • Rebuild a Plan After a Key Assumption Breaks20 min

Your plan

Chapter by chapter.

14 chapters, in this order. Chapter 1 is free.

1~1 wk

See what data architect work involves

StartFree
2~1 wk

Organise data so others can use it

Skills
31–2 wks

Write a one-page insight memo

Project
4~1 wk

Talk to a working data architect

People
5~1 wk

Query and analyse data with code

Skills
6~1 wk

Design and build a cloud data platform

Skills
7~1 wk

Get messy data ready to trust

Skills
8~1 wk

Spot privacy, bias and risk problems early

Skills
9~1 wk

Document your data work for reuse

Skills
10~1 wk

Solve problems when plans change

Skills
111–2 wks

Capstone: build a data glossary and access workflow

Project
12~1 wk

Answer the questions interviewers ask

Interview
13~1 wk

Decide how you will get in

Decide
14on your timeline

Send your first applications

Apply

The job

What a Data Architect does

Designs the blueprint for how an organization stores, connects, and protects data so teams can use it reliably in products and decisions.

The work

  • Design data models and standards for key business areas
  • Map data flows between apps, databases, and analytics tools
  • Define data rules like naming, ownership, and access levels
  • Review new projects to ensure they fit the data architecture
  • Partner with engineers to choose storage and integration patterns
  • Diagnose data issues caused by poor structure or unclear definitions
  • Document architecture decisions and keep diagrams up to date
  • Teach teams how to use shared data definitions and patterns

A typical day

  1. Meet with product and engineering to clarify data needs and constraints
  2. Review a proposed schema change and flag risks to reporting or privacy
  3. Update diagrams and write guidance for a new data domain
  4. Join a design review to align on integration and data ownership

Tools

Databases: PostgreSQL, MySQL, SQL ServerData modeling: ER diagrams, dimensional modelingData integration: ETL, ELT, APIsCloud data platforms: AWS, Azure, Google CloudCatalog and governance: data dictionary, lineage mappingDiagramming: Lucidchart, draw.ioQuerying: SQLVersion control: Git

Ways in

There is more than one route.

Ways to study

  • Bachelors degree in computer science, information systems, or data engineering
  • Diploma or certificate in databases, cloud computing, or data management
  • Bootcamp plus strong portfolio in data modeling and SQL
  • Workplace training through IT rotations or internal architecture programs

How people get their first job

  • Start in roles like data analyst, database administrator, or data engineer
  • Get an internship in data engineering, analytics engineering, or platform teams
  • Build a portfolio with data models, diagrams, and a documented schema design
  • Earn a database or cloud fundamentals certification and practice with projects
  • Volunteer to document data definitions and ownership for a small team

How the work is changing

What AI is doing to this role

How AI is changing this role · one of 5 tasks we track

Design data models and warehouse schemas

Sped up a lot

What AI does

ChatGPT and dbt Copilot generate ERDs and schema drafts from descriptions.

Still yours

You decide how to model for future use cases and growth.

Reviewed September 2026

In the app · Premium

The rest is in the app

  • How AI affects the other 4 tasks
  • Whether this job is growing or shrinking
  • How hard the first job is to get
  • Similar roles that are easier to get into
  • Updated every month, with sources
See it in the app →

How we rate a job →

Already working

Already a Data Architect?

Plan your move to Senior Data Architect: 10 chapters that end with a strong case for your next review.

Grow in the role →

Other roles in Data & Analytics

Questions

Questions about this plan

How long does it take to become a data architect with Welica?

The plan is 14 chapters, 3 months at 15 to 30 minutes a day. You can go faster or slower; the plan moves with you.

Do I need a degree?

Not always. Common routes are bachelors degree in computer science, information systems, or data engineering, diploma or certificate in databases, cloud computing, or data management, bootcamp plus strong portfolio in data modeling and SQL, or workplace training through IT rotations or internal architecture programs.

What is free?

Chapter 1, See what data architect work involves, is free for good. Premium unlocks the rest of the plan.

Start the Data Architect plan.

Chapter 1 free. About 15 to 30 minutes a day.

Start on web Continue your session Download for MacMac Get the iPhone appiPhone Get it on Google PlayAndroid