Data warehouse designer
Also known as: data warehouse architect, data warehouse developer
About this occupation
Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.
Essential skills and knowledge
- query languages
- create database diagrams
- use markup languages
- ICT security legislation
- manage database
- operate relational database management system
- business process modelling
- assess ICT knowledge
- database
- database management systems
- analyse business requirements
- data warehouse
Typical tasks and preparation
From the related US occupation profile Data Warehousing Specialists (O*NET 15-1243.01). Linked by an official crosswalk: related, not identical; details vary by country.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- Verify the structure, accuracy, or quality of warehouse data.
- Map data between source systems, data warehouses, and data marts.
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
- Design and implement warehouse database structures.
- Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
- Typical education (US)
- Bachelor's Degree
- Preparation
- Job Zone 4 of 5
- Interests
- Conventional, Investigative, Enterprising
Top skills: Reading Comprehension, Critical Thinking, Programming, Complex Problem Solving, Active Listening, Systems Analysis
US median pay: US$139,500 a year (2025), 67,140 employed. Source: U.S. Bureau of Labor Statistics, Occupational Employment and Wage Statistics.
Subjects this work relies on
How important each subject's knowledge is in the job itself, rated by people doing it (1 to 5).
- Computer StudiesO*NET: Computers and ElectronicsVery important (4.3)
- Mathematics or StatisticsO*NET: MathematicsImportant (3.2)
- English or Literature in EnglishO*NET: English LanguageImportant (3.2)
- Technical DrawingO*NET: DesignImportant (3.0)
O*NET data describe work in the United States; requirements differ by country. This page includes information from the O*NET 31.0 Database by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license. O*NET is a trademark of USDOL/ETA. CareerProof Global has modified all or some of this information; USDOL/ETA has not approved, endorsed, or tested these modifications.
Preparation needed
Job Zone Four: Considerable Preparation Needed
- Most common education (US)
- Bachelor's Degree
- Education
- Most of these occupations require a four-year bachelor's degree, but some do not.
- Experience
- A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to be considered qualified.
- Training
- Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.
O*NET data describe work in the United States; requirements differ by country. This page includes information from the O*NET 31.0 Database by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license. O*NET is a trademark of USDOL/ETA. CareerProof Global has modified all or some of this information; USDOL/ETA has not approved, endorsed, or tested these modifications.
Related occupations
Occupations O*NET links to this one by similar work, skills and knowledge.
- Database Architects
- Database Administrators
- Software Developers
- Computer Systems Analysts
- Computer Systems Engineers/Architects
- Software Quality Assurance Analysts and Testers
- Data Scientists
- Blockchain Engineers
- Business Intelligence Analysts
- Computer Programmers
O*NET data describe work in the United States; requirements differ by country. This page includes information from the O*NET 31.0 Database by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license. O*NET is a trademark of USDOL/ETA. CareerProof Global has modified all or some of this information; USDOL/ETA has not approved, endorsed, or tested these modifications.