Apply
Program Codes
32807
33864
Employment Percentage
12.72144742
SOC ID
15-1245
SOC Title
Database Administrators and Architects
ONET ID
15-1243.01
ONET Concat ID
15124301
Median Salary
98217.04
EMSI Interest Area Term
Mathematics and Computer Science
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 Doctors
0
Typical Ed Level
a Bachelor's degree
Career Description
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
Core Tasks
  • 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.
  • Provide or coordinate troubleshooting support for data warehouses.
  • Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
  • 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.
  • Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
  • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
  • Create or implement metadata processes and frameworks.
  • Review designs, codes, test plans, or documentation to ensure quality.
  • Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
  • Select methods, techniques, or criteria for data warehousing evaluative procedures.
  • Implement business rules via stored procedures, middleware, or other technologies.
  • Prepare functional or technical documentation for data warehouses.
  • Test software systems or applications for software enhancements or new products.
Start Annual Earnings
54314.45
Top Annual Earnings
168351.69
EMSI Career Title Slug
data-warehousing-specialist