ESCO occupation
Data warehouse designer
Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems.
- U.S. median pay for the matching O*NET occupation
- $135,980 a year
- Projected U.S. jobs
- +9.4% by 2035
For Data Warehousing Specialists (15-1243.01), from the ESCO–O*NET crosswalk. BLS, May 2024 national estimates. Details and sources
Top skills: ICT security legislation, analyse business requirements, apply ICT systems theory, assess ICT knowledge, business process modelling
Hiring for this role? Map this role in your org chart, free →
Compare with another occupationCompare with Database designer
Duties and responsibilities
From the occupation's description in ESCO, the European classification:
- They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.
Tasks O*NET records for Data Warehousing Specialists (15-1243.01), this occupation's exact match in the official ESCO–O*NET crosswalk:
- Verify the structure, accuracy, or quality of warehouse data.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- 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.
U.S. pay and outlook for the matching O*NET occupation
ESCO publishes no pay. These are U.S. figures for Data Warehousing Specialists (15-1243.01), this occupation's exact or close match in the official ESCO–O*NET crosswalk. Pay in Europe differs.
- Median annual wage (U.S.)
- $135,980
- Employment (U.S.)
- 64,770
- Projected employment change, 2025–2035
- +9.4%, faster than the 3.5% for all occupations
Source: U.S. Bureau of Labor Statistics, Occupational Employment and Wage Statistics, May 2024 national estimates and Employment Projections 2025–2035, for SOC 15-1243 (Database Architects), the broader SOC occupation this O*NET occupation belongs to. Pay varies by location, employer and experience.
Job Zone
- 1
- 2
- 3
- 4
- 5
Zone 4: Considerable Preparation Needed
Considerable preparation. Usually a bachelor's degree plus several years of work-related experience, knowledge, or training.
Job Zone is O*NET's rating of how much education, experience and training an occupation typically needs — a property of the work, not of anyone doing it.
Occupational interest profile
CIEConventional · Investigative · Enterprising — the three strongest interests, in order
- C Conventional6.38
- I Investigative4.79
- E Enterprising3.05
- R Realistic2.93
- S Social2.03
- A Artistic1.62
RIASEC (Holland) interests on O*NET's 0–7 scale: what the work draws on, not what any individual prefers. Hover a row for what each dimension means.
Job Zone and interest data are borrowed from Data Warehousing Specialists (15-1243.01): in the official ESCO–O*NET crosswalk, its exact O*NET match, and the best-ranked match that has them. ESCO doesn't publish them directly.
Typically associated skills
Essential (28)
ESCO's essential and optional tags describe how its taxonomy relates a skill to this occupation. They are not the essential functions of a job under the ADA, which an employer determines for its own role.
- ICT security legislation
- analyse business requirements
- apply ICT systems theory
- assess ICT knowledge
- business process modelling
- create data sets
- create database diagrams
- create software design
- data warehouse
- database
Show all 28 essential skills
- database development tools
- database management systems
- define technical requirements
- design database scheme
- develop automated migration methods
- identify software for warehouse management
- information structure
- manage database
- manage standards for data exchange
- migrate existing data
- operate relational database management system
- query languages
- resource description framework query language
- systems theory
- use databases
- use markup languages
- web programming
- write database documentation
Optional (82)
- ABAP
- AJAX
- APL
- ASP.NET
- Agile project management
- Assembly (computer programming)
- C#
- C++
- CA Datacom/DB
- COBOL
- CoffeeScript
- Common Lisp
- DB2
- Erlang
- Filemaker (database management systems)
- Groovy
- Haskell
- IBM Informix
- ICT project management methodologies
- Java (computer programming)
- JavaScript
- LDAP
- LINQ
- Lisp
- MATLAB
- MDX
- ML (computer programming)
- MarkLogic
- Microsoft Access
- Microsoft Visual C++
- MySQL
- N1QL
- ObjectStore
- Objective-C
- OpenEdge Advanced Business Language
- OpenEdge Database
- Oracle Relational Database
- PHP
- Pascal (computer programming)
- Perl
- PostgreSQL
- Process-based management
- Prolog (computer programming)
- Python (computer programming)
- R
- Ruby (computer programming)
- SAP R3
- SAS language
- SPARQL
- SQL Server
- Scala
- Scratch (computer programming)
- Smalltalk (computer programming)
- Swift (computer programming)
- Teradata Database
- TripleStore
- TypeScript
- VBScript
- Visual Basic
- XQuery
- apply technical communication skills
- build business relationships
- computer programming
- data models
- data science
- data visualisation software
- define database physical structure
- design database backup specifications
- design database in the cloud
- design user interface
- develop reporting software
- lean project management
- manage cloud data and storage
- perform data analysis
- perform resource planning
- product data management
- respond to customers' inquiries
- store digital data and systems
- unstructured data
- use access control software
- use back-up and recovery tools
- use query languages
Related ASVAB line scores
The work leans most on the content of the Army GT (General Technical), CL (Clerical) line scores.
Based on the O*NET profile of Data Warehousing Specialists, this occupation's O*NET match.
| Line score | ASVAB areas | Relevance (1–5) |
|---|---|---|
| GT (General Technical) | VE + AR | 3.4 |
| CL (Clerical) | VE + AR + MK | 3.3 |
| FA (Field Artillery) | AR + MK + MC | 2.6 |
| EL (Electronics) | GS + AR + MK + EI | 2.6 |
| SC (Surveillance and Communications) | VE + AR + AS + MC | 2.4 |
How this is worked out: Each ASVAB area the Army composites add up is tied to the O*NET abilities and knowledge areas that cover the same content. An area scores the average O*NET importance (1 to 5) of those ratings for this occupation, and a line score scores the average of its areas. Line scores at O*NET’s “important” level (3) or higher, at most three, are listed as related.
This shows which tested content the civilian work draws on. It is not a qualification standard and implies no score requirement; military jobs set their own, and they change. Confirm with a recruiter.
2030 skills profile
What this isHow much this occupation leans on each of the 13 core skills the World Economic Forum's Future of Jobs Report 2025 expects to grow by 2030, from 0 to 100, read from its O*NET ratings (through its closest O*NET occupation, Data Warehousing Specialists). It describes the occupation, not any person in it.
| Skill | Bar | Score |
|---|---|---|
| AI and big data | 69 | |
| Analytical thinking | 68 | |
| Systems thinking | 62 | |
| Motivation and self-awareness (proxy) | 61 | |
| Creative thinking | 59 | |
| Technological literacy | 59 | |
| Curiosity and lifelong learning | 57 | |
| Resilience, flexibility and agility (proxy) | 46 | |
| Empathy and active listening | 44 | |
| Leadership and social influence | 43 | |
| Talent management | 35 | |
| Resource management and operations | 29 | |
| Service orientation and customer service | 26 |
Data and analytics technologies O*NET lists as in demand here: Amazon DynamoDB, Amazon Elastic Compute Cloud EC2, Amazon Redshift, Amazon Web Services AWS software, Apache Cassandra, Apache Hadoop, Apache Hive, IBM SPSS Statistics, and 14 more.
How each score is built
- AI and big data: Programming 3.8, Mathematics 3.0, Mathematical Reasoning 3.1, Analyzing Data or Information 4.6, Computers and Electronics 4.3
- Technological literacy: Working with Computers 5.0, Computers and Electronics 4.3, Technology Design 2.6, Troubleshooting 1.6
- Curiosity and lifelong learning: Active Learning 3.0, Learning Strategies 2.6, Updating and Using Relevant Knowledge 4.2
- Creative thinking: Originality 3.0, Fluency of Ideas 3.1, Thinking Creatively 4.0
- Talent management: Management of Personnel Resources 2.1, Coaching and Developing Others 2.7, Staffing Organizational Units 2.1, Developing and Building Teams 3.1, Personnel and Human Resources 2.0
- Systems thinking: Systems Analysis 3.5, Systems Evaluation 3.3, Complex Problem Solving 3.6
- Motivation and self-awareness: Monitoring 2.9, Time Management 2.9, Determine Tasks, Priorities and Goals 3.9, Freedom to Make Decisions 4.1
- Resilience, flexibility and agility: Category Flexibility 3.5, Time Pressure 3.3, Conflict Situations 2.6, Dealing With Unpleasant, Angry, or Discourteous People 2.0
- Leadership and social influence: Persuasion 2.8, Coordination 3.1, Guiding, Directing, and Motivating Subordinates 2.4, Selling or Influencing Others 2.3, Coordinate or Lead Others in Accomplishing Work Activities 3.0
- Analytical thinking: Critical Thinking 3.9, Judgment and Decision Making 3.4, Deductive Reasoning 3.8, Inductive Reasoning 3.8
- Empathy and active listening: Active Listening 3.5, Social Perceptiveness 3.0, Assisting and Caring for Others 1.8
- Service orientation and customer service: Service Orientation 2.6, Customer and Personal Service 2.4, Performing for or Working Directly with the Public 1.2, Deal With External Customers or the Public in General 1.9
- Resource management and operations: Management of Financial Resources 1.8, Management of Material Resources 1.9, Operations Analysis 2.8, Monitoring and Controlling Resources 2.2
Each rating is O*NET's 1 to 5 importance or work context value, put on 0 to 100 and averaged. Read the method and its limits, or profile a whole team.
O*NET equivalents
From the official ESCO–O*NET crosswalk, strongest match first. A broader occupation takes in this one; a narrower one is a part of it.
Closest occupations
Compare any occupation →ESCO occupations that share the most of this occupation's 28 essential skills. A plain count, not a hidden score.
Database designer
25 shared · 2 more of its ownmanage standards for data exchange, operate relational database management system, create data sets, create database diagrams
ESCO · Compare
Knowledge engineer
13 shared · 12 more of its ownsystems theory, apply ICT systems theory, assess ICT knowledge, database development tools
ESCO · Compare
ICT system architect
10 shared · 13 more of its ownsystems theory, apply ICT systems theory, assess ICT knowledge, database development tools
ESCO · Compare
Database administrator
9 shared · 19 more of its ownoperate relational database management system, database development tools, design database scheme, database management systems
ESCO · Compare
Data quality specialist
7 shared · 13 more of its ownmanage standards for data exchange, design database scheme, database, manage database
ESCO · Compare
Big data archive librarian
7 shared · 16 more of its ownwrite database documentation, database development tools, database management systems, database
ESCO · Compare
Artificial intelligence engineer
7 shared · 24 more of its owncreate data sets, apply ICT systems theory, analyse business requirements, business process modelling
ESCO · Compare
Database developer
6 shared · 14 more of its ownwrite database documentation, database development tools, database management systems, query languages
ESCO · Compare
Use this in your own job architecture
BlissPoint Organization Viewer can link a role directly to this occupation and suggest these skills as that role's starting requirements.
Questions
- What does a data warehouse designer do?
- Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. Top skills: ICT security legislation, analyse business requirements, apply ICT systems theory, assess ICT knowledge, business process modelling.
- How much does a data warehouse designer make?
- In the U.S., the closest U.S. occupation, Data Warehousing Specialists, pays a median of $135,980 a year (BLS, May 2024 national estimates). Projected jobs: +9.4% by 2035.
- How do you become a data warehouse designer?
- Considerable preparation. Usually a bachelor's degree plus several years of work-related experience, knowledge, or training.
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. ESCO occupations and skills are from the European Commission's ESCO classification, and the occupation crosswalk is the official ESCO–O*NET mapping by the ESCO Secretariat with USDOL/ETA. This service uses the ESCO classification of the European Commission. BlissPoint Analytics has modified all or some of this information: skill, task and descriptor ratings are rounded to one decimal, and ESCO occupations show Job Zone and interests copied from a crosswalked O*NET occupation. USDOL/ETA has not approved, endorsed, or tested these modifications.