Get a jump start on what you want do in college or test your interest before you get there by taking a class in person or online in computer science! 

Take a computer science class.

Stand out and get your skills in programming, analytics, data science, administration, data management and more certified!

Get SAS certified.

Prepare to take on that leadership role by gaining valuable management tools and techniques that help improve processes within an organization.

Get Lean Six Sigma certified.

Explore some of the most valuable skills a data analyst can contribute to the workplace. Start out by picking one or two from this list to improve on and round out your skills!

Improve your skills in data analytics.

Create your own game by completing an Hour of Code challenge. Learn step-by-step how to code through activities that will teach you the basic building blocks.

Take on an Hour of Code challenge!

Data Warehousing Specialists

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

Second Interest High-Point

Investigative occupations frequently involve working with ideas, and require an extensive amount of thinking. These occupations can involve searching for facts and figuring out problems mentally.

Investigative

Conventional occupations frequently involve following set procedures and routines. These occupations can include working with data and details more than with ideas. Usually there is a clear line of authority to follow.

Conventional

Enterprising occupations frequently involve starting up and carrying out projects. These occupations can involve leading people and making many decisions. Sometimes they require risk taking and often deal with business.

Enterprising

Artistic occupations frequently involve working with forms, designs and patterns. They often require self-expression and the work can be done without following a clear set of rules.

Artistic

First Interest High-Point

Realistic occupations frequently involve work activities that include practical, hands-on problems and solutions. They often deal with plants, animals, and real-world materials like wood, tools, and machinery. Many of the occupations require working outside, and do not involve a lot of paperwork or working closely with others.

Realistic

Social occupations frequently involve working with, communicating with, and teaching people. These occupations often involve helping or providing service to others.

Social

Third Interest High-Point

Job Zone Four: Considerable Preparation Needed

Miscellaneous Computer Occupations

Computer Occupations, All Other

Computer and Mathematical Occupations

Computer Occupations

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.

Computer servers

Data warehouse appliances

Desktop computers

Laptop computers

Mainframe computers

Multi-line telephone systems

Personal computers

Storage servers

Adaptive Metadata Manager

Adeptia ETL Suite

Advanced business application programming ABAP

Altova MapForce

Apache Avro

Apache Cassandra

Apache Flume

Apache Hadoop

Apache Hbase

Apache Hive

Apache HTTP Server

Apache Kafka

Apache Oozie

Apache Pig

Apache Solr

Apache Spark

Data Warehousing Specialists

Overview

Career

What Data Warehousing Specialists Do

Other Job Titles Data Warehousing Specialists May Have

Tasks & Responsibilities May Include

Data Warehousing Specialists

Overview

Career

What Data Warehousing Specialists Do

Other Job Titles Data Warehousing Specialists May Have

Tasks & Responsibilities May Include

Education

Level of Education Attained by Data Warehousing Specialists

Majors Related to Career