Overview
Responsibilities
T-A-S-K
Education
Income & Employability
Video Resources
Related Careers

Description

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

Interests

  • Conventional
  • Investigative

Learn More about Interests

Work Values

  • Achievement
  • Working Conditions
  • Independence

Learn More about Work Values

Work Styles

  • Analytical Thinking
  • Attention to Detail
  • Initiative
  • Persistence
  • Cooperation

Learn More about Work Styles

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.

Work Activities

  • Working with Computers
  • Analyzing Data or Information
  • Processing Information
  • Getting Information
  • Updating and Using Relevant Knowledge

Detailed Work Activities

  • Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
  • Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
  • Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
  • Observing, receiving, and otherwise obtaining information from all relevant sources.
  • Keeping up-to-date technically and applying new knowledge to your job.
  • Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
  • Analyzing information and evaluating results to choose the best solution and solve problems.
  • Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
  • Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
  • Translating or explaining what information means and how it can be used.

Technology Skills

  • Data base management system software
  • Presentation software
  • Metadata management software
  • Operating system software
  • Development environment software

Abilities

  • Information Ordering
  • Written Comprehension
  • Deductive Reasoning
  • Inductive Reasoning
  • Oral Comprehension

Skills

  • Critical Thinking
  • Reading Comprehension
  • Programming
  • Complex Problem Solving
  • Active Listening

Knowledge

  • Computers and Electronics
  • Mathematics
  • English Language
  • Design

Most Common Education Level

The “Most Common Education Level” refers to the level of education held by the majority of workers in a given occupation. For example, if the highest percentage of workers in a role have an Associate’s Degree, that suggests this is the typical educational requirement. Knowing this helps you plan how many years of education you may need to pursue that career.

Certificates

Certifying Organization

Oracle Corporation

Type

Product/Equipment

Certifying Organization

Hewlett Packard Certification and Learning

Type

Product/Equipment

Certificate name

VxBlock Deploy

Certifying Organization

Dell Corporation

Type

Product/Equipment

Certifying Organization

VMWare

Type

Advanced

Certificate name

Avamar Deploy

Certifying Organization

Dell Corporation

Type

Product/Equipment

Income Percentile

The income percentiles show how earnings are distributed within a profession. The 10th percentile means that 10% of workers earned less than that amount. The median (50th percentile) indicates that half of workers earned more, and half earned less. The 90th percentile reflects what the top 10% of earners in the field make.

Income PercentileAnnual Income
Low (10%)$59,697
Median (50%)$133,872
High (90%)$185,992

Income by Experience

This table shows how income typically grows with experience—from entry level (0–2 years), to mid-level (3–5 years), to senior level (6–8 years), to expert level (8+ years).

ExperienceIncome
Entry Level N/A
Mid Level N/A
Senior Level N/A
Expert Level N/A

Employability

There are currently 61,400 jobs in this career path. Over the next 10 years, that number is expected to increase to 68,000 positions, reflecting a projected growth of 11%.

The Projected Job Growth figure refers to the expected increase or decrease in employment within a specific career field over a certain period of time.

Projected Job Growth of 11%

Related Careers

The career information and data on this site incorporates information from O*NET Web Services, Lightcast, CareerOneStop, and the U.S. Bureau of Labor Statistics (BLS). For more details regarding the data sources and the specific information sourced, click here.

footer logo

Your One Stop Shop For All Career Resources

Whether you are exploring new career paths, building your resume, or preparing for your next opportunity, our tools, templates, and guidance are designed to help you navigate your career journey with clarity and confidence.

instagram
linkedin
tiktok
youtube