Skip navigation

Summary Report for:
15-1199.07 - Data Warehousing Specialists

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

Sample of reported job titles: Data Warehouse Analyst, Data Warehouse Manager, Data Warehouse Solution Architect

View report: Summary  Details  Custom

Tasks  |  Technology Skills  |  Tools Used  |  Knowledge  |  Skills  |  Abilities  |  Work Activities  |  Detailed Work Activities  |  Work Context  |  Job Zone  |  Education  |  Credentials  |  Interests  |  Work Styles  |  Work Values  |  Wages & Employment  |  Job Openings

Tasks

  • 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.

Find occupations related to multiple tasks

back to top

Technology Skills

  • Analytical or scientific software — IBM SPSS Statistics Hot technology ; SAS Hot technology ; StataCorp Stata Hot technology ; The MathWorks MATLAB Hot technology
  • Application server software — Oracle WebLogic Server Hot technology
  • Backup or archival software — Veritas NetBackup Hot technology
  • Business intelligence and data analysis software — IBM Cognos Impromptu Hot technology ; Oracle Business Intelligence Enterprise Edition Hot technology ; Qlik Tech QlikView Hot technology ; TIBCO Spotfire (see all 6 examples)
  • Clustering software — Aster Data nCluster
  • Communications server software — IBM Domino Hot technology
  • Configuration management software — Perforce Helix software Hot technology
  • Content workflow software — Atlassian JIRA Hot technology
  • Customer relationship management CRM software — Blackbaud The Raiser's Edge Hot technology
  • Data base management system software — Apache Hadoop Hot technology ; MongoDB Hot technology ; Oracle PL/SQL Hot technology ; Teradata Database Hot technology (see all 24 examples)
  • Data base reporting software — IBM Netezza TwinFin; Microsoft SQL Server Reporting Services Hot technology ; Oracle SQL Loader; SAP Crystal Reports Hot technology (see all 5 examples)
  • Data base user interface and query software — Apache Hive Hot technology ; Microsoft Access Hot technology ; Structured query language SQL Hot technology ; Teradata BTEQ (see all 8 examples)
  • Data mining software — Rapid-I RapidMiner; SAP NetWeaver Business Warehouse; Teradata Parallel Transporter; Teradata Tpump (see all 5 examples)
  • Desktop publishing software — Microsoft Publisher Hot technology
  • Development environment software — C Hot technology ; Common business oriented language COBOL Hot technology ; Eclipse IDE Hot technology ; Microsoft .NET Framework Hot technology (see all 10 examples)
  • Document management software — Teradata FastExport
  • Electronic mail software — Microsoft Outlook Hot technology
  • Enterprise application integration software — Extensible markup language XML Hot technology ; IBM WebSphere Hot technology ; SMSi Twister Data Integrator; Talend Open Studio (see all 6 examples)
  • Enterprise resource planning ERP software Hot technology — IBM Clarity Systems Clarity; NetSuite ERP Hot technology ; Oracle PeopleSoft Hot technology ; SAP Hot technology (see all 7 examples)
  • Enterprise system management software — Splunk Enterprise Hot technology
  • File versioning software — Apache Subversion SVN Hot technology
  • Graphics or photo imaging software — Microsoft Visio Hot technology
  • Information retrieval or search software — Apache Avro
  • Map creation software — ESRI ArcGIS software Hot technology
  • Metadata management software — CA Erwin Data Modeler Hot technology ; Oracle Warehouse Builder; Pentaho Kettle; SAS Data Integration Server (see all 16 examples)
  • Network monitoring software — Nagios Hot technology
  • Object or component oriented development software — Advanced business application programming ABAP Hot technology ; Objective C Hot technology ; Oracle Java Hot technology ; Python Hot technology (see all 9 examples)
  • Object oriented data base management software — PostgreSQL Hot technology
  • Office suite software — Microsoft Office
  • Operating system software — Bash Hot technology ; Hewlett Packard HP-UX Hot technology ; Linux Hot technology ; Oracle Solaris Hot technology (see all 11 examples)
  • Portal server software — Apache HTTP Server Hot technology
  • Presentation software — Microsoft PowerPoint Hot technology
  • Project management software — Microsoft Project Hot technology ; Microsoft SharePoint Hot technology
  • Requirements analysis and system architecture software — Unified modeling language UML Hot technology
  • Spreadsheet software — Microsoft Excel Hot technology
  • Transaction security and virus protection software — McAfee Hot technology ; Symantec Hot technology
  • Transaction server software — Customer information control system CICS Hot technology
  • Web platform development software — Ruby on Rails Hot technology
  • Word processing software — Microsoft Word Hot technology

Hot technology Hot Technology — a technology requirement frequently included in employer job postings.

back to top

Tools Used

  • Computer servers — Storage servers
  • Desktop computers
  • High end computer servers — Data warehouse appliances
  • Mainframe computers
  • Notebook computers — Laptop computers
  • Personal computers
  • Special purpose telephones — Multi-line telephone systems

back to top

Knowledge

  • 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.

back to top

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.
  • Systems Analysis — Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
  • Judgment and Decision Making — Considering the relative costs and benefits of potential actions to choose the most appropriate one.
  • Speaking — Talking to others to convey information effectively.
  • 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.
  • Writing — Communicating effectively in writing as appropriate for the needs of the audience.
  • Coordination — Adjusting actions in relation to others' actions.
  • Active Learning — Understanding the implications of new information for both current and future problem-solving and decision-making.
  • Mathematics — Using mathematics to solve problems.
  • Social Perceptiveness — Being aware of others' reactions and understanding why they react as they do.

back to top

Abilities

  • 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.
  • Near Vision — The ability to see details at close range (within a few feet of the observer).
  • 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.
  • Speech Recognition — The ability to identify and understand the speech of another person.
  • 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.
  • 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.
  • 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.
  • 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.
  • Selective Attention — The ability to concentrate on a task over a period of time without being distracted.

back to top

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.
  • Making Decisions and Solving Problems — Analyzing information and evaluating results to choose the best solution and solve problems.
  • Thinking Creatively — Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
  • Communicating with Supervisors, Peers, or Subordinates — Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
  • Interpreting the Meaning of Information for Others — Translating or explaining what information means and how it can be used.
  • Organizing, Planning, and Prioritizing Work — Developing specific goals and plans to prioritize, organize, and accomplish your work.
  • Establishing and Maintaining Interpersonal Relationships — Developing constructive and cooperative working relationships with others, and maintaining them over time.
  • Provide Consultation and Advice to Others — Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.
  • 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.
  • Developing Objectives and Strategies — Establishing long-range objectives and specifying the strategies and actions to achieve them.
  • Developing and Building Teams — Encouraging and building mutual trust, respect, and cooperation among team members.
  • Documenting/Recording Information — Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form.
  • Scheduling Work and Activities — Scheduling events, programs, and activities, as well as the work of others.

back to top

Detailed Work Activities

  • 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.
  • Design software applications.
  • Write computer programming code.
  • Modify software programs to improve performance.
  • Troubleshoot issues with computer applications or systems.
  • Analyze data to identify trends or relationships among variables.
  • Document operational procedures.
  • Evaluate project designs to determine adequacy or feasibility.
  • Develop performance metrics or standards related to information technology.
  • Develop testing routines or procedures.
  • Test software performance.

Find occupations related to multiple detailed work activities

back to top

Work Context

  • Electronic Mail — 100% responded “Every day.”
  • Spend Time Sitting — 86% 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 — 52% responded “Very important.”
  • Freedom to Make Decisions — 65% responded “Some freedom.”
  • Duration of Typical Work Week — 52% responded “40 hours.”
  • Structured versus Unstructured Work — 57% responded “Some freedom.”
  • Contact With Others — 39% responded “Contact with others most of the time.”
  • Importance of Repeating Same Tasks — 39% responded “Very important.”
  • Time Pressure — 48% responded “Once a month or more but not every week.”
  • Impact of Decisions on Co-workers or Company Results — 48% responded “Important results.”
  • Spend Time Making Repetitive Motions — 26% responded “Continually or almost continually.”
  • Coordinate or Lead Others — 35% responded “Important.”
  • Level of Competition — 43% responded “Moderately competitive.”

back to top

Job Zone

Title Job Zone Four: Considerable Preparation Needed
Education Most of these occupations require a four-year bachelor's degree, but some do not.
Related 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.
Job Zone Examples Many of these occupations involve coordinating, supervising, managing, or training others. Examples include accountants, sales managers, database administrators, graphic designers, chemists, art directors, and cost estimators.
SVP Range (7.0 to < 8.0)

back to top

Education


Percentage of Respondents
Education Level Required
78   Bachelor's degree
4   High school diploma or equivalent Help
4   Post-secondary certificate Help

back to top

Credentials

Find Training Find Certifications

back to top

Interests

Interest code: IC   Want to discover your interests? Take the O*NET Interest Profiler at My Next Move.

  • 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.

back to top

Work Styles

  • 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.
  • Dependability — Job requires being reliable, responsible, and dependable, and fulfilling obligations.
  • Adaptability/Flexibility — Job requires being open to change (positive or negative) and to considerable variety in the workplace.
  • Achievement/Effort — Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.
  • Integrity — Job requires being honest and ethical.
  • Innovation — Job requires creativity and alternative thinking to develop new ideas for and answers to work-related problems.
  • Stress Tolerance — Job requires accepting criticism and dealing calmly and effectively with high stress situations.
  • 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.
  • Leadership — Job requires a willingness to lead, take charge, and offer opinions and direction.
  • Self Control — Job requires maintaining composure, keeping emotions in check, controlling anger, and avoiding aggressive behavior, even in very difficult situations.

back to top

Work Values

  • 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.
  • 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.
  • Independence — Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.

back to top

Wages & Employment Trends

Median wages data collected from Computer Occupations, All Other.
Employment data collected from Computer Occupations, All Other.
Industry data collected from Computer Occupations, All Other.

Median wages (2017) $42.56 hourly, $88,510 annual
State wages Local Salary Info
 
Employment (2016) 287,000 employees
Projected growth (2016-2026) Average (5% to 9%) Average (5% to 9%)
Projected job openings (2016-2026) 22,400
State trends Employment Trends
 
Top industries (2016)

Source: Bureau of Labor Statistics 2017 wage data external site and 2016-2026 employment projections external site. "Projected growth" represents the estimated change in total employment over the projections period (2016-2026). "Projected job openings" represent openings due to growth and replacement.

back to top

Job Openings on the Web

Find Jobs

back to top