Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
Also known as: Analytics Manager, Big Data Engineer, Data Integrity Specialist, Data Management Engineer, Data Management Manager, Data Management Specialist, Data Migration Specialist, Data Quality Analyst, ...
Annual Salary
Median annual wage (May 2024)
Job Outlook
Projected growth, 2024–2034 (Much faster than average)
What You'd Do
- Test software systems or applications for software enhancements or new products.
- Review designs, codes, test plans, or documentation to ensure quality.
- Provide or coordinate troubleshooting support for data warehouses.
- Prepare functional or technical documentation for data warehouses.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- Verify the structure, accuracy, or quality of warehouse data.
- Select methods, techniques, or criteria for data warehousing evaluative procedures.
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Map data between source systems, data warehouses, and data marts.
- Implement business rules via stored procedures, middleware, or other technologies.
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
- 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.
- Design and implement warehouse database structures.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
- Create or implement metadata processes and frameworks.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- 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.
Top Skills
Importance scale: 1 (low) – 5 (high)
Knowledge Areas
Importance scale: 1 (low) – 5 (high)
Education Level Distribution
Percentage of workers in this occupation by education level
Technology & Tools
Software and tools commonly used in this role
In-Demand Technologies
Work Styles
Personality traits and work styles important for this career
Key Abilities
Cognitive, physical, and sensory abilities important for this role
Importance scale: 1 (low) – 5 (high)
Work Activities
General types of job behaviors occurring on this job
Importance scale: 1 (low) – 5 (high)
Work Environment
Physical and social factors that influence the nature of work
Related Careers
Is Data Warehousing Specialists right for you?
Take our free career quiz to see how you match with this and 900+ other careers.
Salary data: BLS Occupational Employment and Wage Statistics, May 2024. Outlook data: BLS Employment Projections, 2024–2034.
This page includes information from the O*NET 30.2 Database by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license.