Data warehouse

Roles that need it

• Data Analyst (Banking)
• BI Analyst (Banking)
• Regulatory Reporting Analyst
• Data Governance Analyst
• Business Controller

Skills it belongs to

• Data modelling and schema design
• Querying data with SQL
• Data platforms (Snowflake, BigQuery)

Related concepts

• ETL (extract, transform, load)ETL is the process of extracting data from source systems, transforming it (cleaning, mapping, joining, aggregating) and loading it into a target such as a data warehouse. ELT is the variant where raw data is loaded first and transformed inside the target platform.
• Data lakeA data lake is a large store that keeps data in its raw form, structured or unstructured, until someone needs it. It is cheap and flexible, but without catalogue, ownership and quality controls it can become a "data swamp" that nobody trusts.
• Data lakehouseA data lakehouse is an architecture that combines the low-cost raw storage of a data lake with the table structure, transactions and governance of a data warehouse, so reporting and machine learning can work on the same platform.

Sources

• BIRD technical guidelines 4.1, ECB (external site) accessed 31 Oct 2026

Updated 31 Oct 2026.