Data Warehousing Specialists

What the job really is

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

At a glance

• Sector: Computer & Mathematical
• O*NET-SOC code: 15-1243
• O*NET job zone: 4 — considerable preparation
• Work sample tasks on file: 12
• Tools and technologies listed: 12

What you actually do

Work sample tasks recorded for this occupation:

• Design and implement warehouse database structures.
• 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.
• 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.

Tools and technology

Amazon DynamoDB, Amazon Elastic Compute Cloud EC2, Amazon Redshift, Amazon Web Services AWS software, Apache Cassandra, Apache Hadoop, Apache Hive, Apache Kafka, Apache Spark, Apache Subversion SVN, Apple macOS, Atlassian JIRA

What employers expect you to already be comfortable with.

Where this job leads

Related occupations — the usual moves up and sideways:

• Database Administrators
• Database Architects
• Software Developers
• Computer Systems Analysts
• Computer Systems Engineers/Architects
• Software Quality Assurance Analysts and Testers
• Data Scientists
• Blockchain Engineers

Getting in

O*NET assigns this occupation job zone 4 (considerable preparation). The related occupations above are the realistic routes in and out.

Find openings

Browse the verified job sources directory, or explore more occupations.

Check this against the source

O*NET OnLine: Data Warehousing Specialists — the authoritative public-domain profile this page is derived from, including the full task list, reported skills and the wage estimates for your region.

Derived and rewritten from the public-domain O*NET database (U.S. Department of Labor / Employment and Training Administration). Figures are observations, not promises — always confirm salary, licensing and visa requirements with the employer and the relevant authority.