Data Warehousing Specialists
Tasks Include:
- Test software systems or applications for software enhancements or new products.
- Review designs, codes, test plans, or documentation to ensure quality.
- Provide or coordinate troubleshooting support for data warehouses.
- Prepare functional or technical documentation for data warehouses.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- Verify the structure, accuracy, or quality of warehouse data.
- Select methods, techniques, or criteria for data warehousing evaluative procedures.
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Map data between source systems, data warehouses, and data marts.
- Implement business rules via stored procedures, middleware, or other technologies.
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
more »
The data sources for the information displayed here include: O*NET™; US Department of Labor (BLS); Virginia Workforce Connection. (Using onet28)
Projections Quick View:
Virginia: No Data
National: +10.2%
Education
Bachelor's Degree
Job Zone:
Four: Considerable Preparation Needed
Income Range:
Highest ($50,000 and up)
Median Earnings:
National
$134,870.00
State
No Data
Regional
Data Warehousing Specialists
Description
Career Cluster: | Information Technology |
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Education
Required Level of Education
- Bachelor's Degree = 78.26%
- High School Diploma - or the equivalent (for example, GED) = 4.35%
- Post-Secondary Certificate - awarded for training completed after high school (for example, in agriculture or natural resources, computer services, personal or culinary services, engineering technologies, healthcare, construction trades, mechanic and repair technologies, or precision production) = 4.35%
- Some College Courses = 4.35%
- Associate's Degree (or other 2-year degree) = 4.35%
- Master's Degree = 4.35%
Related Work Experience
- Over 2 years, up to and including 4 years = 43.48%
- Over 4 years, up to and including 6 years = 26.09%
- Over 6 years, up to and including 8 years = 17.39%
- Over 1 year, up to and including 2 years = 4.35%
- Over 8 years, up to and including 10 years = 4.35%
- Over 10 years = 4.35%
On-Site or In-Plant Training
- None = 26.09%
- Up to and including 1 month = 21.74%
- Over 1 month, up to and including 3 months = 17.39%
- Over 3 months, up to and including 6 months = 17.39%
- Over 6 months, up to and including 1 year = 8.70%
- Over 1 year, up to and including 2 years = 4.35%
- Over 4 years, up to and including 10 years = 4.35%
On-the-Job Training
- Over 1 month, up to and including 3 months = 21.74%
- Over 3 months, up to and including 6 months = 21.74%
- None or short demonstration = 17.39%
- Over 6 months, up to and including 1 year = 13.04%
- Anything beyond short demonstration, up to and including 1 month = 8.70%
- Over 2 years, up to and including 4 years = 8.70%
- Over 4 years, up to and including 10 years = 8.70%
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Tasks
Core Tasks Include:
- Test software systems or applications for software enhancements or new products.
- Review designs, codes, test plans, or documentation to ensure quality.
- Provide or coordinate troubleshooting support for data warehouses.
- Prepare functional or technical documentation for data warehouses.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- Verify the structure, accuracy, or quality of warehouse data.
- Select methods, techniques, or criteria for data warehousing evaluative procedures.
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Map data between source systems, data warehouses, and data marts.
- Implement business rules via stored procedures, middleware, or other technologies.
- 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.
- Design and implement warehouse database structures.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
- Create or implement metadata processes and frameworks.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- 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.
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Knowledge
% | Subject | Description |
---|---|---|
81.50 | Computers and Electronics | Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming. |
55.75 | Mathematics | Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications. |
54.50 | English Language | Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar. |
51.00 | Design | Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models. |
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Skills
% | Subject | Description |
---|---|---|
72.00 | Reading Comprehension | Understanding written sentences and paragraphs in work-related documents. |
72.00 | Critical Thinking | Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems. |
68.75 | Programming | Writing computer programs for various purposes. |
65.50 | Complex Problem Solving | Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions. |
62.50 | Active Listening | Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times. |
62.50 | Systems Analysis | Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes. |
59.50 | Speaking | Talking to others to convey information effectively. |
59.50 | Judgment and Decision Making | Considering the relative costs and benefits of potential actions to choose the most appropriate one. |
56.25 | Writing | Communicating effectively in writing as appropriate for the needs of the audience. |
56.25 | Systems Evaluation | Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system. |
53.00 | Coordination | Adjusting actions in relation to others' actions. |
50.00 | Mathematics | Using mathematics to solve problems. |
50.00 | Active Learning | Understanding the implications of new information for both current and future problem-solving and decision-making. |
50.00 | Social Perceptiveness | Being aware of others' reactions and understanding why they react as they do. |
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Abilities
% | Subject | Description |
---|---|---|
72.00 | Written Comprehension | The ability to read and understand information and ideas presented in writing. |
72.00 | 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). |
68.75 | Oral Comprehension | The ability to listen to and understand information and ideas presented through spoken words and sentences. |
68.75 | Deductive Reasoning | The ability to apply general rules to specific problems to produce answers that make sense. |
68.75 | Inductive Reasoning | The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events). |
65.50 | Near Vision | The ability to see details at close range (within a few feet of the observer). |
62.50 | Oral Expression | The ability to communicate information and ideas in speaking so others will understand. |
62.50 | Written Expression | The ability to communicate information and ideas in writing so others will understand. |
62.50 | Category Flexibility | The ability to generate or use different sets of rules for combining or grouping things in different ways. |
62.50 | Speech Recognition | The ability to identify and understand the speech of another person. |
59.50 | 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 that there is a problem. |
59.50 | Speech Clarity | The ability to speak clearly so others can understand you. |
53.00 | 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). |
53.00 | Mathematical Reasoning | The ability to choose the right mathematical methods or formulas to solve a problem. |
50.00 | 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. |
50.00 | Number Facility | The ability to add, subtract, multiply, or divide quickly and correctly. |
50.00 | 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. |
50.00 | Selective Attention | The ability to concentrate on a task over a period of time without being distracted. |
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Work Activities
% | Subject | Description |
---|---|---|
99.00 | Working with Computers | Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information. |
88.75 | Analyzing Data or Information | Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts. |
87.00 | Processing Information | Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data. |
85.75 | Getting Information | Observing, receiving, and otherwise obtaining information from all relevant sources. |
80.50 | Updating and Using Relevant Knowledge | Keeping up-to-date technically and applying new knowledge to your job. |
76.25 | Identifying Objects, Actions, and Events | Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events. |
74.00 | Thinking Creatively | Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions. |
73.75 | Making Decisions and Solving Problems | Analyzing information and evaluating results to choose the best solution and solve problems. |
72.75 | Communicating with Supervisors, Peers, or Subordinates | Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person. |
69.25 | Interpreting the Meaning of Information for Others | Translating or explaining what information means and how it can be used. |
67.50 | Organizing, Planning, and Prioritizing Work | Developing specific goals and plans to prioritize, organize, and accomplish your work. |
63.00 | Establishing and Maintaining Interpersonal Relationships | Developing constructive and cooperative working relationships with others, and maintaining them over time. |
60.75 | Providing Consultation and Advice to Others | Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics. |
58.75 | Evaluating Information to Determine Compliance with Standards | Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards. |
56.50 | Developing Objectives and Strategies | Establishing long-range objectives and specifying the strategies and actions to achieve them. |
53.25 | Developing and Building Teams | Encouraging and building mutual trust, respect, and cooperation among team members. |
50.00 | Scheduling Work and Activities | Scheduling events, programs, and activities, as well as the work of others. |
50.00 | Documenting/Recording Information | Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form. |
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Work Styles
% | Subject | Description |
---|---|---|
97.75 | Analytical Thinking | Job requires analyzing information and using logic to address work-related issues and problems. |
88.00 | Attention to Detail | Job requires being careful about detail and thorough in completing work tasks. |
84.00 | Initiative | Job requires a willingness to take on responsibilities and challenges. |
81.75 | Persistence | Job requires persistence in the face of obstacles. |
79.25 | Cooperation | Job requires being pleasant with others on the job and displaying a good-natured, cooperative attitude. |
79.25 | Dependability | Job requires being reliable, responsible, and dependable, and fulfilling obligations. |
78.25 | Adaptability/Flexibility | Job requires being open to change (positive or negative) and to considerable variety in the workplace. |
76.25 | Achievement/Effort | Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks. |
76.00 | Integrity | Job requires being honest and ethical. |
74.00 | Innovation | Job requires creativity and alternative thinking to develop new ideas for and answers to work-related problems. |
70.75 | Stress Tolerance | Job requires accepting criticism and dealing calmly and effectively with high-stress situations. |
65.25 | Independence | Job requires developing one's own ways of doing things, guiding oneself with little or no supervision, and depending on oneself to get things done. |
61.25 | Leadership | Job requires a willingness to lead, take charge, and offer opinions and direction. |
56.50 | Self-Control | Job requires maintaining composure, keeping emotions in check, controlling anger, and avoiding aggressive behavior, even in very difficult situations. |
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Work Values
% | Subject | Description |
---|---|---|
83.33 | Achievement | Occupations that satisfy this work value are results oriented and allow employees to use their strongest abilities, giving them a feeling of accomplishment. Corresponding needs are Ability Utilization and Achievement. |
72.17 | Working Conditions | Occupations that satisfy this work value offer job security and good working conditions. Corresponding needs are Activity, Compensation, Independence, Security, Variety and Working Conditions. |
66.67 | Independence | Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy. |
50.00 | Recognition | Occupations that satisfy this work value offer advancement, potential for leadership, and are often considered prestigious. Corresponding needs are Advancement, Authority, Recognition and Social Status. |
50.00 | Support | Occupations that satisfy this work value offer supportive management that stands behind employees. Corresponding needs are Company Policies, Supervision: Human Relations and Supervision: Technical. |
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Work Context
% | Subject | Description |
---|---|---|
100.00 | Electronic Mail | How often do you use electronic mail in this job? |
97.20 | Spend Time Sitting | How much does this job require sitting? |
96.60 | Indoors, Environmentally Controlled | How often does this job require working indoors in environmentally controlled conditions? |
89.00 | Face-to-Face Discussions | How often do you have to have face-to-face discussions with individuals or teams in this job? |
88.60 | Importance of Being Exact or Accurate | How important is being very exact or highly accurate in performing this job? |
86.40 | Telephone | How often do you have telephone conversations in this job? |
86.00 | Work With Work Group or Team | How important is it to work with others in a group or team in this job? |
81.80 | Freedom to Make Decisions | How much decision making freedom, without supervision, does the job offer? |
78.20 | Structured versus Unstructured Work | To what extent is this job structured for the worker, rather than allowing the worker to determine tasks, priorities, and goals? |
68.60 | Contact With Others | How much does this job require the worker to be in contact with others (face-to-face, by telephone, or otherwise) in order to perform it? |
67.80 | Importance of Repeating Same Tasks | How important is repeating the same physical activities (e.g., key entry) or mental activities (e.g., checking entries in a ledger) over and over, without stopping, to performing this job? |
66.00 | Time Pressure | How often does this job require the worker to meet strict deadlines? |
65.20 | Impact of Decisions on Co-workers or Company Results | What results do your decisions usually have on other people or the image or reputation or financial resources of your employer? |
61.80 | Spend Time Making Repetitive Motions | How much does this job require making repetitive motions? |
60.80 | Coordinate or Lead Others | How important is it to coordinate or lead others in accomplishing work activities in this job? |
60.00 | Level of Competition | To what extent does this job require the worker to compete or to be aware of competitive pressures? |
57.40 | Frequency of Decision Making | How frequently is the worker required to make decisions that affect other people, the financial resources, and/or the image and reputation of the organization? |
55.60 | Physical Proximity | To what extent does this job require the worker to perform job tasks in close physical proximity to other people? |
55.40 | Letters and Memos | How often does the job require written letters and memos? |
53.00 | Responsibility for Outcomes and Results | How responsible is the worker for work outcomes and results of other workers? |
52.20 | Frequency of Conflict Situations | How often are there conflict situations the employee has to face in this job? |
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Job Zone Four: Considerable Preparation Needed
- Overall Experience
- A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to be considered qualified.
- Job Training
- Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.
- Examples
- Many of these occupations involve coordinating, supervising, managing, or training others. Examples include real estate brokers, sales managers, database administrators, graphic designers, conservation scientists, art directors, and cost estimators.
- Education
- Most of these occupations require a four-year bachelor's degree, but some do not.
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Earnings Benefits*
Region | Entry Level | Median | Experienced |
---|---|---|---|
United States | $74,980.00 | $134,870.00 | $168,360.00 |
Virginia | No Data | No Data | No Data |
Region | Entry Level | Median | Experienced |
Alexandria/Arlington | No Data | No Data | No Data |
Bay Consortium | No Data | No Data | No Data |
Capital Region Workforce Partnership | No Data | No Data | No Data |
Central VA/Region2000 | No Data | No Data | No Data |
Crater Area | No Data | No Data | No Data |
Greater Peninsula | No Data | No Data | No Data |
Hampton Roads | No Data | No Data | No Data |
New River/Mt. Rogers | No Data | No Data | No Data |
Northern Virginia | No Data | No Data | No Data |
Piedmont Workforce | No Data | No Data | No Data |
Shenandoah Valley | No Data | No Data | No Data |
South Central | No Data | No Data | No Data |
Southwestern Virginia | No Data | No Data | No Data |
West Piedmont | No Data | No Data | No Data |
Western Virginia | No Data | No Data | No Data |
* Earnings Calculations:
Regional Earnings:
Entry = Annual mean of the lower 1/3 wage distribution;
Experienced = Annual mean of the upper 2/3 wage distribution.
National and State Earnings:
Entry = Annual 10th percentile wage;
Experienced = Annual 75th percentile wage.
The data sources for the information displayed here include: US Department of Labor (BLS); Virginia Workforce Connection. (Using onet28)
Data Warehousing Specialists
Employment Projections
Current | Projected | % Change | |
---|---|---|---|
United States | 52,700 | 58,100 | +10.2% |
Virginia | No Data | No Data | No Data |
Region | Current* | Projected | % Change |
Alexandria/Arlington | No Data | No Data | No Data |
Bay Consortium | No Data | No Data | No Data |
Capital Region Workforce Partnership | No Data | No Data | No Data |
Central VA/Region2000 | No Data | No Data | No Data |
Crater Area | No Data | No Data | No Data |
Greater Peninsula | No Data | No Data | No Data |
Hampton Roads | No Data | No Data | No Data |
New River/Mt. Rogers | No Data | No Data | No Data |
Northern Virginia | No Data | No Data | No Data |
Piedmont Workforce | No Data | No Data | No Data |
Shenandoah Valley | No Data | No Data | No Data |
South Central | No Data | No Data | No Data |
Southwestern Virginia | No Data | No Data | No Data |
West Piedmont | No Data | No Data | No Data |
Western Virginia | No Data | No Data | No Data |
The data sources for the information displayed here include: US Department of Labor (BLS); Virginia Workforce Connection. (Using onet28)
Data Warehousing Specialists
Related Occupations
Related Occupations
The related occupations here have similar general capabilities and interests; career explorers may also be interested in the related occupations:- Database Architects
- Software Developers
- Computer Systems Engineers/Architects
- Computer Systems Analysts
- Database Administrators
- Software Quality Assurance Analysts and Testers
- Blockchain Engineers
- Data Scientists
- Document Management Specialists
- Computer Programmers
- Computer Hardware Engineers
- Operations Research Analysts
- Logistics Engineers
- Industrial Engineers
- Logistics Analysts
- Business Intelligence Analysts
- Network and Computer Systems Administrators
- Computer Network Architects
- Geographic Information Systems Technologists and Technicians
- Validation Engineers
Careers in Information Support and Services Pathway:
- Business Intelligence Analysts
- Computer Occupations, All Other
- Computer Systems Engineers/Architects
- Computer User Support Specialists
- Data Warehousing Specialists
- Document Management Specialists
- Geographic Information Systems Technologists and Technicians
- Information Technology Project Managers
- Project Management Specialists
- Search Marketing Strategists
- Video Game Designers
- Web Administrators
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
View Videos
CareerOneStop Video
View Video & Transcript on CareerOneStop
CareerOneStop Information Technology Videos
Overview
Occupations
The data sources for the information displayed here include: New York State Department of Labor; New Jersey Department of Labor; California Occupational Information Coordinating Committee; CareerOneStop. (Using onet28)
Data Warehousing Specialists
Military Training
The following military job classifications are available for this occupation:
- Analysis
The data sources for the information displayed here include: Defense Manpower Data Center. (Using onet28)
Data Warehousing Specialists
Proficiency Ratings
These proficiencies are scored on a scale from 1 to 5 with 1 being not
important to the job and 5 being extremely important to the job.
The data sources for the information displayed here include: O*NET™. (Using onet28)
Data Warehousing Specialists
Related Schools
- American National University
- Averett University
- Blue Ridge Community College
- Bluefield University
- Bridgewater College
- Brightpoint Community College
- Central Virginia Community College
- Christopher Newport University
- Columbia College
- Dabney S Lancaster Community College
- Danville Community College
- DeVry University-Virginia
- Eastern Mennonite University
- Eastern Shore Community College
- ECPI University
- Fairfax University of America
- Ferrum College
- George Mason University
- Germanna Community College
- Hampden-Sydney College
- Hampton University
- IGlobal University
- J Sargeant Reynolds Community College
- James Madison University
- Laurel Ridge Community College
- Liberty University
- Longwood University
- Marymount University
- Mountain Empire Community College
- New River Community College
- Norfolk State University
- Northern Virginia Community College
- Old Dominion University
- Patrick Henry Community College
- Paul D Camp Community College
- Piedmont Virginia Community College
- Radford University
- Randolph-Macon College
- Rappahannock Community College
- Regent University
- Roanoke College
- Shenandoah University
- South University-Richmond
- South University-Virginia Beach
- Southern Virginia University
- Southside Virginia Community College
- Southwest Virginia Community College
- Stratford University
- Strayer University-Virginia
- Tidewater Community College
- University of Lynchburg
- University of Management and Technology
- University of Mary Washington
- University of Richmond
- University of the Potomac-VA Campus
- University of Virginia's College at Wise
- University of Virginia-Main Campus
- Virginia Commonwealth University
- Virginia Highlands Community College
- Virginia Military Institute
- Virginia Peninsula Community College
- Virginia Polytechnic Institute and State University
- Virginia State University
- Virginia Union University
- Virginia Western Community College
- Washington and Lee University
- William & Mary
- Wytheville Community College
The data sources for the information displayed here include: O*NET™. (Using onet28)