Data Warehousing Specialists
Program and design data warehouse systems.
Quick Facts
Wages: |
Median wages for the broader occupation, Computer Occupations, All Other, are
/ hour.
|
Education: |
|
On the Job: |
Typical Work Tasks
- Troubleshoot issues with computer applications or systems.
- Write computer programming code.
- Analyze data to identify trends or relationships among variables.
- Evaluate data quality.
Read more about the job
|
Job Title Examples: |
Data Storage Specialist
Data Warehousing Engineer
Data Warehousing Manager
See more job title examples
|
View All Career Information
This page includes information from the O*NET 24.2 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.
On the Job
Data Warehousing Specialists program and design systems that hold data for data analysis or reporting purposes. They provide support to people who use the system. They may test data warehouses for errors, or create documentation about how to use the system.
Typical Work Tasks
People who work in this career often:
- Troubleshoot issues with computer applications or systems.
- Write computer programming code.
- Analyze data to identify trends or relationships among variables.
- Evaluate data quality.
- Create databases to store electronic data.
- Design software applications.
- Develop diagrams or flow charts of system operation.
- Develop models of information or communications systems.
- Develop performance metrics or standards related to information technology.
- Modify software programs to improve performance.
Typical Working Conditions
- Using e-mail.
- Sitting.
- Working indoors in environmentally controlled conditions.
- The importance of being accurate or exact.
- Working with a group or team.
- Freedom to make decisions without supervision.
This page includes information from the O*NET 24.2 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.
Education & Credentials
This is a new or emerging specialty. The information on this page is based on the broader career that this specialty is part of,
Computer Occupations, All Other.
Educational Requirements
Not available
Education level attained (national data)
Education Level Attained (national data)Education Level Attained | Percentage of workers in this occupation |
Less than high school diploma | 0.7 |
High school diploma or equivalent | 8.4 |
Some college, no degree | 20.3 |
Associate degree | 14.4 |
Bachelors degree | 39.5 |
Masters degree | 15.6 |
Doctoral (Ph.D) or professional degree | 1.3 |
Work Experience and Training Requirements
Nationally, this career typically requires:
- No related work experience for entry.
- Little or no on-the-job training to become competent.
Current Training Opportunities
Related Programs
Majors
Click on any of the Majors listed below to find out more about preparing for this
career.
Transfer Options
Enrolling in a community college can be a great place to start your four-year degree. While all 31 Minnesota State community colleges,
technical colleges and universities offer all or part of the Minnesota Transfer Curriculum
(a 40-credit package of general education courses accepted for transfer to other state colleges and universities, the University of Minnesota,
and some private colleges and universities), not all two-year colleges offer degrees intended to transfer to a four-year bachelor's degree.
If you plan to transfer to obtain a four-year bachelor's degree, it is important to know which degree path is right for you:
- Associate of Arts (AA) degrees offered at community colleges are designed to transfer into liberal arts four-year majors.
- Associate of Science (AS) and Associate of Fine Arts (AFA) degrees offered at community and technical colleges transfer into specific four-year majors and will likely require completing additional general education courses at a university.
- Associate of Applied Science (AAS) degrees offered at technical and community colleges are not designed to transfer. They lead to immediate entry into the workplace.
- Diplomas and certificates offered at technical colleges are not designed to transfer. They lead to immediate entry into the workplace.
Talk to a transfer specialist as early as possible to determine the best associate degree for your goals. Be sure to review your Degree Audit Report (DARS) each semester to best prepare for transfer. Get more help understanding transfer using the tools below.
Helpful High School Courses
Examples of helpful classes that help you prepare for this career:
- Algebra I and II
- Analytic Geometry
- Electronics
- Graphic Arts
- Journalism
- Keyboarding
- Multimedia
- Network Systems
- Pre-Calculus
- Technical Writing
- Trigonometry
- Web Page Design
In Minnesota, your school may have developed a Program of Study in this career area.
A Program of Study is an academic and career plan developed by your high school to help move you towards a career
and college path. A Program of Study can help you:
- Select high school classes that prepare you for college and getting a job
- Understand how the classes you're taking in high school lead to a career
- Identify extra-curricular activities that are related to your career interest
- See what classes at your school offer early college credit that will save you time and money towards your college expenses
- Graduate from high school prepared for your next step toward the career you choose
This page includes information from the O*NET 24.2 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.
Skills & Knowledge
Most Important Skills for Data Warehousing Specialists
- Reading—Understanding written sentences and paragraphs in work related documents.
- Thinking Critically—Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
- Programming Computers —Writing computer programs for various purposes.
- 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.
- Making Decisions—Considering the relative costs and benefits of potential actions to choose the most appropriate one.
- Speaking—Talking to others to convey information effectively.
- Evaluating a System or Organization—Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
- Solving Complex Problems—Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
- Understanding a System or Organization—Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
- Coordinating with Others—Adjusting actions in relation to others' actions.
Most Important Knowledge Areas for Data Warehousing Specialists
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Economics and Accounting—Knowledge of economic and accounting principles and practices, the financial markets, banking and the analysis and reporting of financial data.
Interests
Different careers may be a good fit for your personality or interests. This career is:
- Investigative—Investigative occupations frequently involve working with ideas, and require an extensive amount of thinking. These occupations can involve searching for facts and figuring out problems mentally.
- Conventional—Conventional occupations frequently involve following set procedures and routines. These occupations can include working with data and details more than with ideas. Usually there is a clear line of authority to follow.
Learn more about your interests. Take the MnCareers Interest Assessment.
Describe Your Skills
This is a new or emerging career specialty. Skill statements are still under development.
Careers that Use Similar Skills
This is a new or emerging career specialty. Information on similar careers is still under development.
View more careers in the Information Technology cluster
View more careers in the Business Information Management pathway
This page includes information from the O*NET 24.2 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.
Please visit CareerOneStop to search Tools & Technology.
Jobs
Real-time job data provided by Gartner TalentNeuron
Job Title Examples
Data Storage Specialist,
Data Warehousing Engineer,
Data Warehousing Manager
Where Do Data Warehousing Specialists Work?
Data Warehousing Specialists often work in the following industries.
Source: You can learn about our data sources in the About Us section.