SOC 15-1243.01
Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
What the work involves
- Verify the structure, accuracy, or quality of warehouse data.Core
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.Core
- Map data between source systems, data warehouses, and data marts.Core
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.Core
- Design and implement warehouse database structures.Core
- 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.Core
- Provide or coordinate troubleshooting support for data warehouses.Core
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.Core
- Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.Core
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.Core
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.Core
- Create or implement metadata processes and frameworks.Core
Also called
- Data Warehouse Analyst
- Data Warehouse Solution Architect
- Analytics Manager
- Big Data Engineer
- Data Integrity Specialist
- Data Management Engineer
- Data Management Manager
- Data Management Specialist
- Data Migration Specialist
- Data Quality Analyst
- Data Specialist
- Data Storage Specialist
Preparation
Job Zone Four: Considerable Preparation Needed
Most of these occupations require a four-year bachelor's degree, but some do not.
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.
Published labor market figures
U.S.
- Employment · 64,770
- Median wage · $135,980
Skills in the source record
- Reading Comprehension · Common Skill
- Information Ordering · Specialized Skill
- Critical Thinking · Common Skill
- Inductive Reasoning · Common Skill
- Deductive Reasoning · Common Skill
- Complex Problem Solving · Common Skill
- Systems Analysis · Specialized Skill
- Speech Recognition · Specialized Skill
- Microsoft PowerPoint · Common Skill
- Microsoft Outlook · Common Skill
- Microsoft Excel · Common Skill
- Microsoft Access · Specialized Skill
- Active Listening · Common Skill
- Writing · Common Skill
- Mathematics · Common Skill
- English Language · Common Skill
- Unix Shell · Specialized Skill
- Unix · Specialized Skill
- Transact-SQL · Specialized Skill
- Social Perceptiveness · Common Skill
- Shell Script · Specialized Skill
- Red Hat Enterprise Linux · Specialized Skill
- PostgreSQL · Specialized Skill
- NoSQL · Specialized Skill
- MySQL · Specialized Skill
- MongoDB · Specialized Skill
- Microsoft Word · Common Skill
- Microsoft Windows · Common Skill
- Microsoft Visual Studio · Specialized Skill
- Microsoft Visio · Specialized Skill
- Microsoft SharePoint · Specialized Skill
- Microsoft Project · Specialized Skill
- Linux · Specialized Skill
- Apache Spark · Specialized Skill
- Apache Kafka · Specialized Skill
- Apache Hive · Specialized Skill
- Apache Hadoop · Specialized Skill
- Apache Cassandra · Specialized Skill
- Amazon Redshift · Specialized Skill
- Amazon DynamoDB · Specialized Skill
Related occupations
- 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
- Document Management Specialists
- Network and Computer Systems Administrators
Source version 30.3 · 2026-06-02T21:00:32.945303+00:00