Data & Research
 
* ELMI Occupation Profile - Data Warehousing Specialists *
 
Data Warehousing Specialists
(O*NET 15-1243.01, SOC 15-1243)
What they do
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
 
Also called:
Data Warehouse Analyst, Data Warehouse Solution Architect
 
 
Wages
Database Architects*
Vermont - 2023
Percentile1HourlyYearly
10% $ 46.18   $96,060  
25% $ 50.74   $105,550  
Median $ 62.48   $129,950  
75% $ 91.62   $190,560  
90% $ 91.73   $190,800  
 
Average $ 73.34   $152,540  
* You're seeing information for "Database Architects" because it includes "Data Warehousing Specialists" for which wage information is not available.
1 What are Percentile Wages?
More at CareerOneStop
 
Industries of Employment
Database Administrators and Architects*
United States - 2020
IndustryPercent of total
  • Professional, scientific, and technical services
22%
  • Self-employed workers
17%
  • Educational services; state, local, and private
6%
  • Management of companies and enterprises
6%
  • Insurance carriers and related activities
6%
* You're seeing information for "Database Administrators and Architects" because it includes "Data Warehousing Specialists" for which industries of employment information is not available.
More at BLS
 
Knowledge
People in this career often know a lot about:
  • 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.
More at O*NET
 
Skills
People in this career often have these skills:
  • Critical Thinking
    Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
  • Reading Comprehension
    Understanding written sentences and paragraphs in work-related documents.
  • 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.
  • 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.
More at O*NET
 
Interests
People in this career often prefer these work environments:
  • Investigative
    Work involves studying and researching non-living objects, living organisms, disease or other forms of impairment, or human behavior. Investigative occupations are often associated with physical, life, medical, or social sciences, and can be found in the fields of humanities, mathematics/statistics, information technology, or health care service.
  • Conventional
    Work involves following procedures and regulations to organize information or data, typically in a business setting. Conventional occupations are often associated with office work, accounting, mathematics/statistics, information technology, finance, or human resources.
What are your interests? Take the O*NET Interest Profiler
 
Work Styles
People in this career will do well at jobs that need:
  • Analytical Thinking
    Job requires analyzing information and using logic to address work-related issues and problems.
  • Attention to Detail
    Job requires being careful about detail and thorough in completing work tasks.
  • Initiative
    Job requires a willingness to take on responsibilities and challenges.
  • Persistence
    Job requires persistence in the face of obstacles.
  • Cooperation
    Job requires being pleasant with others on the job and displaying a good-natured, cooperative attitude.
More at O*NET
 
Tasks
On the job, you would:
  • 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.
More at O*NET
 
Related Occupations
More at O*NET
 
 
Career Video
Watch at CareerOneStop with transcript or at YouTube.
 
Projected Employment
Database Administrators and Architects*
 Vermont
2020 employment 320
2030 employment 358
Annual percent change
(compounded)
1.1%
Annual projected job openings
(due to change and separations)
29
* You're seeing information for "Database Administrators and Architects" because it includes "Data Warehousing Specialists" for which projected employment information is not available.
More at Occupational Projections
 
Education and Experience:
Database Administrators and Architects*
  • Typical education needed for entry
    Bachelor's degree
  • Work experience in a related occupation
    None
  • Typical on-the-job training needed to attain competency
    None
* You're seeing information for "Database Administrators and Architects" because it includes "Data Warehousing Specialists" for which education and experience information is not available.
Based on BLS Education and Training Classifications
 
Physical Work Activity
Performing physical activities that require considerable use of your arms and legs and moving your whole body, such as climbing, lifting, balancing, walking, stooping, and handling materials.
 
  • Physical activity is Seldom Important
  • Level of activity is Very Low
Importance
Low   High
Level
Compare Occupations at O*NET
 
Job Zone
Considerable Preparation Needed
  • Specific Vocational Preparation Range
    (7.0 to < 8.0) - A typical worker will require over 2 years up to and including 4 years of training to achieve average performance in this occupation.
Based on O*Net Job Zones and SVP
 
Education Level
How much education do most people in this career have?
Education level Percent of
U.S. Workers
Doctoral or professional degree
or post-MA certificate
  0%
Master's degree or
post-BA certificate
  4%
Bachelor's degree   78%
Associate's degree   4%
Certificate or some college,
no degree
  9%
High school diploma
or equivalent
  4%
Less than high school diploma   0%
More at O*NET
 
Abilities
People in this career often have talent in:
  • 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.
  • Deductive Reasoning
    The ability to apply general rules to specific problems to produce answers that make sense.
  • Inductive Reasoning
    The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
  • Oral Comprehension
    The ability to listen to and understand information and ideas presented through spoken words and sentences.
More at O*NET
 
Work Activities
In general, what you might do:
  • Working 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.
More at O*NET
 
Detailed Work Activities
What you might do in a day:
  • Develop models of information or communications systems.
  • Evaluate data quality.
  • Develop diagrams or flow charts of system operation.
  • Develop procedures for data management.
  • Create databases to store electronic data.
More at O*NET
 
Other Resources
  • CareerOneStop
    resource for job seekers, students, businessess and career professionals
  • O*NET Online
    nation's primary source of occupational information
 
O*NET in-it

This page includes information from the O*NET 28.0 Database by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license. O*NET® is a trademark of USDOL/ETA.

BLS

This page includes information produced in cooperation with the U.S. Bureau of Labor Statistics, Occupational Employment and Wage Statistics and State Occupational Projections programs.

 
 
 
 
Vermont.gov State of Vermont Department of Labor