Careers › Data & Analytics › Data Architect
For students and early-career professionals
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.
What's in the plan
Practice 14 practice tasks Tasks from the real work of the job, 10 to 45 minutes each
Projects 2 projects you keep Public dataset deep-dive with a one-page insight memo Mini data glossary plus access request workflow design
Interview 20 interview questions Practise your answers, with feedback
People 4 people to reach Who they are, with 4 messages ready to send
Also: choose your route in (5 credentials compared, none required) and 3 life skills courses.
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
Python Summarise a data file and write a small reusable function Ch 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 pipelines Describe a data source, then automate copying its data daily Ch 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 cleaning Clean a messy data set and note each fix Ch 7 What you'll learn
Tidy table shape First data profile Missing value choice Repeatable cleaning steps Communication Rewrite an update for two different readers, cutting extra lines Ch 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 others Contribute to group work, ask for help and credit teammates Ch 9 What you'll learn
Early team friction Clear ownership Challenge ideas, not people Lead or follow Documenting data work Write data field definitions that others can use unaided Ch 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 solving Test each possible cause of a problem instead of guessing Ch 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 change Try a new tool and describe how you handled change Ch 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 Start Free
2 ~1 wk Organise data so others can use it Skills
3 1–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
11 1–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
14 on 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 Meet with product and engineering to clarify data needs and constraints Review a proposed schema change and flag risks to reporting or privacy Update diagrams and write guidance for a new data domain Join a design review to align on integration and data ownership Tools Databases: PostgreSQL, MySQL, SQL Server Data modeling: ER diagrams, dimensional modeling Data integration: ETL, ELT, APIs Cloud data platforms: AWS, Azure, Google Cloud Catalog and governance: data dictionary, lineage mapping Diagramming: Lucidchart, draw.io Querying: SQL Version 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 Life skills in this plan: Networking · Job interviews · Job search
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.
Already have an account? Sign in