DatabasesData/ML/AI
Data Warehouse
Also written as EDW, Enterprise Data Warehouse
A large central database optimized for analytics and reporting across an entire company, separate from the databases that power live applications.
Think of it like
Like a company archive built purely for looking back at historical records and trends, kept separate from the live filing cabinet the front office uses every day.
Junior or senior?
Junior sounds like
Has only queried tables someone else built in the warehouse.
Senior sounds like
Has modeled data in it themselves — a star schema, a dbt model.
Ask them
“Have you modeled data in a warehouse yourself, or mainly queried tables someone else built?”