Program Codes: 
32807,33864
Employment Percentage: 
11.902117719144
SOC ID: 
15-1299
SOC Title: 
Computer Occupations, All Other
ONET ID: 
15-1199.07
ONET Concat ID: 
15119907
Median Salary: 
78382.29
Interest Area Term: 
Ed Level High School: 
4.35
Ed Level Certificate: 
4.35
Ed Level Some College: 
4.35
Ed Level Associates: 
4.35
Ed Level Bachelors: 
78.260002
Ed Level Masters: 
4.35
Ed Level Doctor: 
0
Typical Ed Level: 
a Bachelor's degree
Description: 

Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

Core Tasks: 

<ul><li>Develop data warehouse process models, including sourcing, loading, transformation, and extraction.</li><li>Verify the structure, accuracy, or quality of warehouse data.</li><li>Map data between source systems, data warehouses, and data marts.</li><li>Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.</li><li>Design and implement warehouse database structures.</li><li>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.</li><li>Provide or coordinate troubleshooting support for data warehouses.</li><li>Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.</li><li>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.</li><li>Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.</li><li>Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.</li><li>Create or implement metadata processes and frameworks.</li><li>Review designs, codes, test plans, or documentation to ensure quality.</li><li>Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.</li><li>Select methods, techniques, or criteria for data warehousing evaluative procedures.</li><li>Implement business rules via stored procedures, middleware, or other technologies.</li><li>Prepare functional or technical documentation for data warehouses.</li><li>Test software systems or applications for software enhancements or new products.</li></ul>

Start Annual Earnings: 
41475.85
Top Annual Earnings: 
143845.36
Title Slug: 
data-warehousing-specialist