Data Warehousing Specialists

Also called: Data Management Specialist, Data Storage Specialist, Data Warehouse Analyst, Data Warehouse Developer, Data Warehouse Engineer

jobs advertised

courses available

Varies

estimated salary

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

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.

Work Context

Electronic Mail — 100% responded "Every day".
Spend Time Sitting — 87% responded "Continually or almost continually".
Indoors, Environmentally Controlled — 96% responded "Every day".
Face-to-Face Discussions — 55% responded "Every day".
Importance of Being Exact or Accurate — 57% responded "Extremely important".
Telephone — 50% responded "Every day".
Work With Work Group or Team — 53% responded "Very important".

Work Activities

Interacting With Computers — Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
Analyzing Data or Information — Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
Processing Information — Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
Getting Information — Observing, receiving, and otherwise obtaining information from all relevant sources.
Updating and Using Relevant Knowledge — Keeping up-to-date technically and applying new knowledge to your job.
Identifying Objects, Actions, and Events — Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
Thinking Creatively — Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
Making Decisions and Solving Problems — Analyzing information and evaluating results to choose the best solution and solve problems.

Detailed Work Activities

Test software performance.
Evaluate project designs to determine adequacy or feasibility.
Troubleshoot issues with computer applications or systems.
Document operational procedures.
Modify software programs to improve performance.
Design software applications.

Computers and Electronics

Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.

Mathematics

Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.

English Language

Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.

Design

Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.

Reading Comprehension

Understanding written sentences and paragraphs in work related documents.

Critical Thinking

Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.

Programming

Writing computer programs for various purposes.

Complex Problem Solving

Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.

Written Comprehension

The ability to read and understand information and ideas presented in writing.

Information Ordering

The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).

Written Comprehension

The ability to read and understand information and ideas presented in writing.

Information Ordering

The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).

Oral Comprehension

The ability to listen to and understand information and ideas presented through spoken words and sentences.

Inductive Reasoning

The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).

Deductive Reasoning

The ability to apply general rules to specific problems to produce answers that make sense.

Oral Comprehension

The ability to listen to and understand information and ideas presented through spoken words and sentences.

Inductive Reasoning

The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).

Deductive Reasoning

The ability to apply general rules to specific problems to produce answers that make sense.

Near Vision

The ability to see details at close range (within a few feet of the observer).

Near Vision

The ability to see details at close range (within a few feet of the observer).

Speech Recognition

The ability to identify and understand the speech of another person.

Oral Expression

The ability to communicate information and ideas in speaking so others will understand.

Written Expression

The ability to communicate information and ideas in writing so others will understand.

Speech Recognition

The ability to identify and understand the speech of another person.

Category Flexibility

The ability to generate or use different sets of rules for combining or grouping things in different ways.

Oral Expression

The ability to communicate information and ideas in speaking so others will understand.

Category Flexibility

The ability to generate or use different sets of rules for combining or grouping things in different ways.

Written Expression

The ability to communicate information and ideas in writing so others will understand.

Problem Sensitivity

The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem.

Speech Clarity

The ability to speak clearly so others can understand you.

Problem Sensitivity

The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem.

Speech Clarity

The ability to speak clearly so others can understand you.

Fluency of Ideas

The ability to come up with a number of ideas about a topic (the number of ideas is important, not their quality, correctness, or creativity).

Mathematical Reasoning

The ability to choose the right mathematical methods or formulas to solve a problem.

Mathematical Reasoning

The ability to choose the right mathematical methods or formulas to solve a problem.

Fluency of Ideas

The ability to come up with a number of ideas about a topic (the number of ideas is important, not their quality, correctness, or creativity).

Selective Attention

The ability to concentrate on a task over a period of time without being distracted.

Flexibility of Closure

The ability to identify or detect a known pattern (a figure, object, word, or sound) that is hidden in other distracting material.

Number Facility

The ability to add, subtract, multiply, or divide quickly and correctly.

Flexibility of Closure

The ability to identify or detect a known pattern (a figure, object, word, or sound) that is hidden in other distracting material.

Selective Attention

The ability to concentrate on a task over a period of time without being distracted.

Number Facility

The ability to add, subtract, multiply, or divide quickly and correctly.

Originality

The ability to come up with unusual or clever ideas about a given topic or situation, or to develop creative ways to solve a problem.

Originality

The ability to come up with unusual or clever ideas about a given topic or situation, or to develop creative ways to solve a problem.

People interested in this work like activities that include ideas, thinking, and figuring things out.

They do well at jobs that need:

Achievement/Effort

Persistence

Initiative

Leadership

Cooperation

Concern for Others

Social Orientation

Self Control

You might use software like this on the job:

Analytical or scientific software

IBM SPSS Statistics
SAS
The MathWorks MATLAB
StataCorp Stata

Electronic mail software

Microsoft Outlook

Presentation software

Microsoft PowerPoint

Get started on your career:

New job opportunities are very likely in the future.

Find a job

Data Warehousing Specialists

Explore CalifjoSearch

Find a job

Explore CalifjoSearch

Modal Window