Statewide occupation search

Sort your search results or select and compare details of two occupations. Find out if an occupation is in demand or not in demand in your local area, at Learn about an occupation.

Statewide occupation search

Data Warehousing Specialists

It's a bright outlook for

This career will grow rapidly in the next few years.

Learn more about what they do.

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

Related: Computer Systems Analysts Computer Systems Engineers/Architects Database Administrators Database Architects Software Developers

Industries: Professional, Science, & Technical Finance & Insurance Media & Communication

Summary
Details

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.
Implement business rules via stored procedures, middleware, or other technologies.
Design and implement warehouse database structures.
Implement business rules via stored procedures, middleware, or other technologies.
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
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.
Provide or coordinate troubleshooting support for data warehouses.
Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
Select methods, techniques, or criteria for data warehousing evaluative procedures.
Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
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.
Verify the structure, accuracy, or quality of warehouse data.
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
Review designs, codes, test plans, or documentation to ensure quality.
Map data between source systems, data warehouses, and data marts.
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.
Test software systems or applications for software enhancements or new products.
Prepare functional or technical documentation for data warehouses.
Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
Create or implement metadata processes and frameworks.

Technology Design
- Making equipment and technology useful for customers.
Active Listening
- Listening to others, not interrupting, and asking good questions.
Equipment Selection
- Deciding what kind of tools and equipment are needed to do a job.
Speaking
- Talking to others.
Operations Monitoring
- Watching gauges, dials, or display screens to make sure a machine is working.
Service Orientation
- Looking for ways to help people.
Installation
- Installing equipment, machines, wiring, or computer programs.
Science
- Using scientific rules and strategies to solve problems.
Coordination
- Changing what is done based on other people's actions.
Operations Analysis
- Figuring out what a product or service needs to be able to do.
Operation and Control
- Using equipment or systems.
Equipment Maintenance
- Planning and doing the basic maintenance on equipment.
Monitoring
- Keeping track of how well people and/or groups are doing in order to make improvements.
Reading Comprehension
- Reading work-related information.
Critical Thinking
- Thinking about the pros and cons of different ways to solve a problem.
Mathematics
- Using math to solve problems.
Social Perceptiveness
- Understanding people's reactions.
Judgment and Decision Making
- Thinking about the pros and cons of different options and picking the best one.
Writing
- Writing things for co-workers or customers.
Learning Strategies
- Using the best training or teaching strategies for learning new things.
Repairing
- Repairing machines or systems using the right tools.
Systems Analysis
- Figuring out how a system should work and how changes in the future will affect it.
Management of Personnel Resources
- Selecting and managing the best workers for a job.
Management of Financial Resources
- Making spending decisions and keeping track of what is spent.
Active Learning
- Figuring out how to use new ideas or things.
Negotiation
- Bringing people together to solve differences.
Troubleshooting
- Figuring out what is causing equipment, machines, wiring, or computer programs to not work.
Time Management
- Managing your time and the time of other people.
Persuasion
- Talking people into changing their minds or their behavior.
Systems Evaluation
- Measuring how well a system is working and how to improve it.
Programming
- Writing computer programs.
Quality Control Analysis
- Testing how well a product or service works.
Instructing
- Teaching people how to do something.
Complex Problem Solving
- Noticing a problem and figuring out the best way to solve it.
Management of Material Resources
- Managing equipment and materials.

Deductive Reasoning
- Using rules to solve problems.
Flexibility of Closure
- Seeing hidden patterns.
Originality
- Creating new and original ideas.
Written Expression
- Communicating by writing.
Auditory Attention
- Paying attention to one sound while there are other distracting sounds.
Static Strength
- Lifting, pushing, pulling, or carrying.
Dynamic Flexibility
- Quickly and repeatedly bending, stretching, twisting, or reaching out with your body, arms, and/or legs.
Night Vision
- Seeing at night or under low light.
Sound Localization
- Noticing the direction that a sound came from.
Wrist-Finger Speed
- Making fast, simple, repeated movements of your fingers, hands, and wrists.
Oral Comprehension
- Listening and understanding what people say.
Multilimb Coordination
- Using your arms and/or legs together while sitting, standing, or lying down.
Gross Body Equilibrium
- Keeping your balance or staying upright.
Depth Perception
- Deciding which thing is closer or farther away from you, or deciding how far away it is from you.
Category Flexibility
- Grouping things in different ways.
Speed of Closure
- Quickly knowing what you are looking at.
Near Vision
- Seeing details up close.
Glare Sensitivity
- Seeing something even if there is a glare or very bright light.
Number Facility
- Adding, subtracting, multiplying, or dividing.
Reaction Time
- Quickly moving your hand, finger, or foot based on a sound, light, picture or other command.
Speed of Limb Movement
- Quickly moving your arms and legs.
Extent Flexibility
- Bending, stretching, twisting, or reaching with your body, arms, and/or legs.
Visual Color Discrimination
- Noticing the difference between colors, including shades and brightness.
Rate Control
- Changing when and how fast you move based on how something else is moving.
Control Precision
- Quickly changing the controls of a machine, car, truck or boat.
Trunk Strength
- Using your lower back and stomach.
Far Vision
- Seeing details that are far away.
Hearing Sensitivity
- Telling the difference between sounds.
Peripheral Vision
- Seeing something to your side when your are looking ahead.
Mathematical Reasoning
- Choosing the right type of math to solve a problem.
Selective Attention
- Paying attention to something without being distracted.
Perceptual Speed
- Quickly comparing groups of letters, numbers, pictures, or other things.
Memorization
- Remembering words, numbers, pictures, or steps.
Information Ordering
- Ordering or arranging things.
Visualization
- Imagining how something will look after it is moved around or changed.
Spatial Orientation
- Knowing where things are around you.
Time Sharing
- Doing two or more things at the same time.
Oral Expression
- Communicating by speaking.
Fluency of Ideas
- Coming up with lots of ideas.
Problem Sensitivity
- Noticing when problems happen.
Arm-Hand Steadiness
- Keeping your arm or hand steady.
Finger Dexterity
- Putting together small parts with your fingers.
Explosive Strength
- Jumping, sprinting, or throwing something.
Dynamic Strength
- Exercising for a long time without your muscles getting tired.
Written Comprehension
- Reading and understanding what is written.
Inductive Reasoning
- Making general rules or coming up with answers from lots of detailed information.
Manual Dexterity
- Holding or moving items with your hands.
Stamina
- Exercising for a long time without getting out of breath.
Gross Body Coordination
- Moving your arms, legs, and mid-section together while your whole body is moving.
Speech Recognition
- Recognizing spoken words.
Response Orientation
- Quickly deciding if you should move your hand, foot, or other body part.
Speech Clarity
- Speaking clearly.

Law and Government
- Knowledge of laws, legal codes, court procedures, precedents, government regulations, executive orders, agency rules, and the democratic political process.
Therapy and Counseling
- Knowledge of principles, methods, and procedures for diagnosis, treatment, and rehabilitation of physical and mental dysfunctions, and for career counseling and guidance.
Administration and Management
- Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
Sales and Marketing
- Knowledge of principles and methods for showing, promoting, and selling products or services. This includes marketing strategy and tactics, product demonstration, sales techniques, and sales control systems.
Engineering and Technology
- Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.
Biology
- Knowledge of plant and animal organisms, their tissues, cells, functions, interdependencies, and interactions with each other and the environment.
Psychology
- Knowledge of human behavior and performance; individual differences in ability, personality, and interests; learning and motivation; psychological research methods; and the assessment and treatment of behavioral and affective disorders.
Medicine and Dentistry
- Knowledge of the information and techniques needed to diagnose and treat human injuries, diseases, and deformities. This includes symptoms, treatment alternatives, drug properties and interactions, and preventive health-care measures.
Building and Construction
- Knowledge of materials, methods, and the tools involved in the construction or repair of houses, buildings, or other structures such as highways and roads.
Mathematics
- Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
History and Archeology
- Knowledge of historical events and their causes, indicators, and effects on civilizations and cultures.
Philosophy and Theology
- Knowledge of different philosophical systems and religions. This includes their basic principles, values, ethics, ways of thinking, customs, practices, and their impact on human culture.
Computers and Electronics
- Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
Economics and Accounting
- Knowledge of economic and accounting principles and practices, the financial markets, banking, and the analysis and reporting of financial data.
Fine Arts
- Knowledge of the theory and techniques required to compose, produce, and perform works of music, dance, visual arts, drama, and sculpture.
Customer and Personal Service
- Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
Food Production
- Knowledge of techniques and equipment for planting, growing, and harvesting food products (both plant and animal) for consumption, including storage/handling techniques.
Personnel and Human Resources
- Knowledge of principles and procedures for personnel recruitment, selection, training, compensation and benefits, labor relations and negotiation, and personnel information systems.
Design
- Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
Administrative
- Knowledge of administrative and office procedures and systems such as word processing, managing files and records, stenography and transcription, designing forms, and workplace terminology.
Transportation
- Knowledge of principles and methods for moving people or goods by air, rail, sea, or road, including the relative costs and benefits.
Public Safety and Security
- Knowledge of relevant equipment, policies, procedures, and strategies to promote effective local, state, or national security operations for the protection of people, data, property, and institutions.
Mechanical
- Knowledge of machines and tools, including their designs, uses, repair, and maintenance.
Physics
- Knowledge and prediction of physical principles, laws, their interrelationships, and applications to understanding fluid, material, and atmospheric dynamics, and mechanical, electrical, atomic and sub-atomic structures and processes.
Chemistry
- Knowledge of the chemical composition, structure, and properties of substances and of the chemical processes and transformations that they undergo. This includes uses of chemicals and their interactions, danger signs, production techniques, and disposal methods.
Sociology and Anthropology
- Knowledge of group behavior and dynamics, societal trends and influences, human migrations, ethnicity, cultures, and their history and origins.
Geography
- Knowledge of principles and methods for describing the features of land, sea, and air masses, including their physical characteristics, locations, interrelationships, and distribution of plant, animal, and human life.
Education and Training
- Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.
English Language
- Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
Telecommunications
- Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.
Foreign Language
- Knowledge of the structure and content of a foreign (non-English) language including the meaning and spelling of words, rules of composition and grammar, and pronunciation.
Communications and Media
- Knowledge of media production, communication, and dissemination techniques and methods. This includes alternative ways to inform and entertain via written, oral, and visual media.
Production and Processing
- Knowledge of raw materials, production processes, quality control, costs, and other techniques for maximizing the effective manufacture and distribution of goods.

Education

Bachelor's degree

Work Experience

Less than 5 years work experience

Training

No on-the-job training

Education and Training Opportunities

Washington Annual Salary

144050/yr

Washington Hourly Wage

69.26/hr

Currently Employed

68,000

Yearly Projected Openings

4200

Conventional: People interested in this work like activities that include data, detail, and regular routines. They do well at jobs that need:

Analytical Thinking
Attention to Detail
Initiative
Persistence
Cooperation
Dependability

Computer servers
Desktop computers
High end computer servers
Mainframe computers
Notebook computers
Personal computers
Special purpose telephones

Analytical or scientific software
Application server software
Backup or archival software
Business intelligence and data analysis software
Cloud-based data access and sharing software
Cloud-based management software
Clustering software
Communications server software
Configuration management software
Content workflow software
Customer relationship management CRM software
Data base management system software
Data base reporting software
Data base user interface and query software
Data mining software
Desktop publishing software
Development environment software
Document management software
Electronic mail software
Enterprise application integration software
Enterprise resource planning ERP software
File versioning software
Financial analysis software
Geographic information system
Human resources software
Information retrieval or search software
Metadata management software
Network monitoring software
Object or component oriented development software
Object oriented data base management software
Office suite software
Operating system software
Portal server software
Presentation software
Process mapping and design software
Project management software
Requirements analysis and system architecture software
Spreadsheet software
Storage networking software
Transaction security and virus protection software
Transaction server software
Web platform development software
Word processing software

ADDITIONAL RESOURCES

Find Data Warehousing Specialists jobs Education and Training for Data Warehousing Specialists

Statewide occupation search

Statewide occupation search

Data Warehousing Specialists

Work Activities

Skills

Abilities

Knowledge

Education

Pay

Washington Employment Trends

Personality

Tools

Technology

ADDITIONAL RESOURCES