BlissPoint Analytics

Occupation AtlasData Warehousing Specialists

O*NET · 15-1243.01

Data Warehousing Specialists

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

Also called Analytics Manager · Big Data Engineer · Data Integrity Specialist · Data Management Engineer · Data Management Manager · Data Management Specialist · Data Migration Specialist · Data Quality Analyst
23 more

Data Specialist · Data Storage Specialist · Data Warehouse Analyst · Data Warehouse Developer · Data Warehouse Engineer · Data Warehouse ETL Developer · Data Warehouse ETL Developer (Data Warehouse Extract, Transform, and Load Developer) · Data Warehouse Programmer · Data Warehouse Solution Architect · Data Warehouse Specialist · Data Warehousing Engineer · Data Warehousing Specialist · Database Specialist · ETL Developer · ETL Developer (Extract-Transform-Load Developer) · ETL Tester · ETL Tester (Extract-Transform-Load Tester) · IT Data Specialist · IT Data Specialist (Information Technology Data Specialist) · Product Data Specialist · Provider Data Specialist · Research Data Specialist · Storage Engineer

Job Zone 4 — Considerable Preparation NeededHolland code CIE35 skills on file

Compare with another occupationCompare with Database Architects

Job Zone

  1. 1
  2. 2
  3. 3
  4. 4
  5. 5

Zone 4: Considerable Preparation Needed

Considerable preparation. Usually a bachelor's degree plus several years of work-related experience, knowledge, or training.

Job Zone is O*NET's rating of how much education, experience and training an occupation typically needs — a property of the work, not of anyone doing it.

Occupational interest profile

CIEConventional · Investigative · Enterprising — the three strongest interests, in order

  • C Conventional6.38
  • I Investigative4.79
  • E Enterprising3.05
  • R Realistic2.93
  • S Social2.03
  • A Artistic1.62

RIASEC (Holland) interests on O*NET's 0–7 scale: what the work draws on, not what any individual prefers. Hover a row for what each dimension means.

Education and experience

The education level respondents say the job requires, and the most common answer for experience and training.

  • High School Diploma or the equivalent4%
  • Post-Secondary Certificate4%
  • Some College Courses4%
  • Associate's Degree or other 2-year degree4%
  • Bachelor's Degree78%
  • Master's Degree4%
Related work experience
Over 2 years, up to and including 4 years (44%)
On-site or in-plant training
None (26%)
On-the-job training
Over 1 month, up to and including 3 months (22%)

Typically associated skills

All 35 O*NET skills, most important first. Importance (1–5) says how much a skill matters here; level (0–7) says how much of it the work calls for, with O*NET's example of a nearby level. Neither is a proficiency rating of a person.

  • Reading Comprehensionbasic3.94.0Level 4 looks like: Understand an email from management describing new personnel policies
  • Critical Thinkingbasic3.93.9Level 4 looks like: Evaluate customer complaints and determine appropriate responses
  • Programming3.83.8Level 4 looks like: Write a statistical analysis program to analyze demographic data
  • Complex Problem Solving3.63.5Level 4 looks like: Redesign a floor layout to take advantage of new manufacturing techniques
  • Active Listeningbasic3.53.6Level 4 looks like: Answer inquiries regarding credit references
  • Systems Analysis3.53.5Level 4 looks like: Determine how a new piece of equipment will affect production rates
  • Judgment and Decision Making3.43.6Level 4 looks like: Evaluate a loan application for degree of risk
  • Speakingbasic3.43.6Level 4 looks like: Interview applicants to obtain personal and work history
  • Systems Evaluation3.33.5Level 4 looks like: Identify the reasons why a client might be unhappy with a product
  • Writingbasic3.33.4Level 4 looks like: Write an email to staff outlining new directives
  • Coordination3.13.4Level 4 looks like: Work with others to put a new roof on a house
  • Active Learningbasic3.03.3Level 4 looks like: Determine the impact of new menu changes on a restaurant's purchasing requirements
Show the other 23
  • Mathematicsbasic3.03.3Level 4 looks like: Calculate the square footage of a new home under construction
  • Social Perceptiveness3.03.0Level 2 looks like: Notice that customers are angry because they have been waiting too long
  • Monitoringbasic2.93.1Level 4 looks like: Monitor a meeting and revise the agenda to ensure important topics are discussed
  • Time Management2.92.8Level 2 looks like: Keep a monthly calendar of appointments
  • Operations Analysis2.83.4Level 4 looks like: Suggest changes in software to make a system more user friendly
  • Persuasion2.83.1Level 4 looks like: Convince a supervisor to purchase new office equipment
  • Instructing2.63.4Level 4 looks like: Instruct a coworker in how to operate a software program
  • Learning Strategiesbasic2.62.8Level 2 looks like: Learn a different method of completing a task from a coworker
  • Technology Design2.62.8Level 2 looks like: Adjust exercise equipment for use by a customer
  • Negotiation2.62.6Level 2 looks like: Present justification to a manager for altering a work schedule
  • Service Orientation2.62.6Level 2 looks like: Ask customers if they would like a cup of coffee
  • Operations Monitoring2.52.3Level 2 looks like: Monitor completion times while running a computer program
  • Quality Control Analysis2.42.3Level 2 looks like: Inspect a draft email for errors (e.g., grammar, punctuation)
  • Management of Personnel Resources2.12.0Level 2 looks like: Encourage a coworker who is having difficulty finishing a project
  • Management of Material Resources1.91.6Level 2 looks like: Reserve a room for a management meeting
  • Operation and Control1.91.6Level 2 looks like: Navigate the settings on an office printer to print on both sides of the paper
  • Sciencebasic1.91.3Level 2 looks like: Conduct standard tests to determine soil quality
  • Management of Financial Resources1.81.4Level 2 looks like: Use available funds to buy office supplies and record the amount of the purchase
  • Troubleshooting1.61.0Level 2 looks like: Identify the source of a leak by looking under a machine
  • Equipment Selection1.5—
  • Equipment Maintenance1.1—
  • Repairing1.1—
  • Installation1.0—

Tasks

18 core

What people in this occupation do, as O*NET records it, core tasks first by importance (1–5).

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

Knowledge

Bodies of knowledge the work draws on.

  • Computers and Electronics4.35.6
  • English Language3.23.4Level 4 looks like: Edit an article for a news website
  • Mathematics3.24.6Level 4 looks like: Analyze data to determine areas with the highest sales
  • Design3.03.4Level 4 looks like: Design plans for remodeling a kitchen
  • Engineering and Technology2.93.0Level 4 looks like: Design a custom office chair
  • Administration and Management2.63.5Level 4 looks like: Monitor progress of a project to ensure timely completion
  • Customer and Personal Service2.42.6
  • Economics and Accounting2.22.4Level 1 looks like: Answer billing questions from credit card customers
Show all 33
  • Education and Training2.23.0Level 4 looks like: Lead a quality improvement seminar
  • Production and Processing2.12.2Level 1 looks like: Put a computer back into its packing materials
  • Personnel and Human Resources2.02.6
  • Telecommunications2.02.0Level 1 looks like: Send an email
  • Administrative1.92.3Level 1 looks like: Direct phone calls to the appropriate staff member
  • Sales and Marketing1.71.9Level 1 looks like: Sell cakes at a bake sale
  • Communications and Media1.61.4Level 1 looks like: Write a thank you note
  • Law and Government1.61.4Level 1 looks like: Describe the length of a U.S. presidential term
  • Psychology1.51.3Level 1 looks like: Monitor several children on a playground
  • Geography1.40.9Level 1 looks like: Know the capital of the United States
  • Sociology and Anthropology1.3—
  • Physics1.2—
  • Public Safety and Security1.2—
  • Transportation1.2—
  • Building and Construction1.1—
  • Fine Arts1.1—
  • Foreign Language1.1—
  • History and Archeology1.1—
  • Mechanical1.1—
  • Medicine and Dentistry1.1—
  • Philosophy and Theology1.1—
  • Biology1.0—
  • Chemistry1.0—
  • Food Production1.0—
  • Therapy and Counseling1.0—

Abilities

Enduring capacities the work calls for.

  • Information Ordering3.94.0Level 2 looks like: Follow the correct steps to make change
  • Written Comprehension3.94.0Level 4 looks like: Understand an apartment lease
  • Deductive Reasoning3.84.0Level 5 looks like: Decide what factors to consider in selecting stocks
  • Inductive Reasoning3.83.9Level 4 looks like: Determine the prime suspect based on crime scene evidence
  • Oral Comprehension3.84.0Level 4 looks like: Understand a coach's oral instructions for a sport
  • Near Vision3.63.9
  • Category Flexibility3.53.5Level 3 looks like: Classify flowers according to size, color, and smell
  • Oral Expression3.54.0Level 4 looks like: Give instructions to a lost motorist
Show all 52
  • Speech Recognition3.53.3Level 4 looks like: Identify a former customer's voice over the phone
  • Written Expression3.54.0Level 4 looks like: Write a job recommendation for a subordinate
  • Problem Sensitivity3.43.5Level 4 looks like: Notice from a subtle difference in a client's mood that something is bothering them
  • Speech Clarity3.43.0Level 4 looks like: Make stadium-wide announcements during a sporting event
  • Fluency of Ideas3.13.3Level 4 looks like: Think of as many ideas as possible for the name of a new company
  • Mathematical Reasoning3.13.1Level 4 looks like: Decide how to calculate profits to determine the amounts of yearly bonuses
  • Flexibility of Closure3.03.0Level 2 looks like: Detect that your phone is ringing while at a concert
  • Number Facility3.03.3Level 3 looks like: Calculate a discounted price
  • Originality3.03.3Level 4 looks like: Redesign job tasks to be interesting for employees
  • Selective Attention3.03.0Level 2 looks like: Answer a business call with coworkers talking nearby
  • Perceptual Speed2.62.9Level 2 looks like: Sort mail according to ZIP codes with no time pressure
  • Visualization2.62.8Level 2 looks like: Imagine how to place paper in a printer so that the letterhead comes out on top
  • Speed of Closure2.52.5Level 3 looks like: Recognize a song after hearing only the first few notes
  • Far Vision2.42.4Level 2 looks like: Read a roadside billboard
  • Memorization2.32.5Level 1 looks like: Remember the number on your bus to be sure you get back on the right one
  • Trunk Strength2.11.8Level 2 looks like: Sit up in an office chair
  • Visual Color Discrimination2.11.8Level 1 looks like: Separate laundry into colors and whites
  • Hearing Sensitivity1.91.4Level 2 looks like: Notice a doorbell ringing
  • Time Sharing1.91.8Level 2 looks like: Listen to music while entering numbers into a spreadsheet
  • Wrist-Finger Speed1.91.4Level 2 looks like: Use a screwdriver to twist in a screw
  • Auditory Attention1.81.3Level 2 looks like: Listen to a lecture while people nearby are talking
  • Depth Perception1.60.9
  • Dynamic Strength1.60.8
  • Arm-Hand Steadiness1.3—
  • Finger Dexterity1.3—
  • Speed of Limb Movement1.1—
  • Control Precision1.0—
  • Dynamic Flexibility1.0—
  • Explosive Strength1.0—
  • Extent Flexibility1.0—
  • Glare Sensitivity1.0—
  • Gross Body Coordination1.0—
  • Gross Body Equilibrium1.0—
  • Manual Dexterity1.0—
  • Multilimb Coordination1.0—
  • Night Vision1.0—
  • Peripheral Vision1.0—
  • Rate Control1.0—
  • Reaction Time1.0—
  • Response Orientation1.0—
  • Sound Localization1.0—
  • Spatial Orientation1.0—
  • Stamina1.0—
  • Static Strength1.0—

Work activities

Kinds of activity the work is made of.

  • Working with Computers5.05.8
  • Analyzing Data or Information4.66.0Level 7 looks like: Analyze the cost of medical care services for all hospitals in the country
  • Processing Information4.55.7
  • Getting Information4.45.0Level 4 looks like: Review a budget
  • Updating and Using Relevant Knowledge4.25.5Level 4 looks like: Keep current on changes in maintenance procedures for repairing sports cars
  • Identifying Objects, Actions, and Events4.14.8Level 4 looks like: Judge the suitability of food products for an event
  • Making Decisions and Solving Problems4.04.9Level 4 looks like: Select the location for a major retail store
  • Thinking Creatively4.05.5Level 4 looks like: Adapt popular music for a high school marching band
Show all 41
  • Communicating with Supervisors, Peers, or Subordinates3.94.9Level 4 looks like: Report the results of a sales meeting to a supervisor
  • Interpreting the Meaning of Information for Others3.84.4Level 4 looks like: Interpret how foreign tax laws apply to U.S. exports
  • Organizing, Planning, and Prioritizing Work3.75.0Level 4 looks like: Plan and adjust a personal to-do list according to changing demands
  • Establishing and Maintaining Interpersonal Relationships3.54.2Level 4 looks like: Maintain good working relationships with almost all coworkers and clients
  • Evaluating Information to Determine Compliance with Standards3.44.0Level 4 looks like: Evaluate a complicated insurance claim for compliance with policy terms
  • Providing Consultation and Advice to Others3.44.6Level 4 looks like: Recommend a new software package to increase operational efficiency
  • Developing Objectives and Strategies3.33.7Level 4 looks like: Develop the plan to complete the merger of two organizations over a 3-year period
  • Developing and Building Teams3.13.4Level 4 looks like: Lead an assembly team in an automobile plant
  • Documenting/Recording Information3.03.5Level 4 looks like: Document the results of a crime scene investigation
  • Scheduling Work and Activities3.03.4Level 4 looks like: Prepare the work schedule for salesclerks in a large retail store
  • Training and Teaching Others3.03.7Level 4 looks like: Teach a social sciences course to high school students
  • Estimating the Quantifiable Characteristics of Products, Events, or Information2.93.1Level 4 looks like: Estimate the time required to evacuate a city in the event of a major disaster
  • Monitoring Processes, Materials, or Surroundings2.93.4Level 4 looks like: Test electrical circuits
  • Coordinating the Work and Activities of Others2.83.6Level 4 looks like: Organize the cleanup crew after a major sporting event
  • Judging the Qualities of Objects, Services, or People2.83.1Level 4 looks like: Determine the value of property lost in a fire
  • Coaching and Developing Others2.73.8Level 4 looks like: Provide on-the-job training for administrative workers
  • Communicating with People Outside the Organization2.63.0Level 4 looks like: Present information to potential clients about available services
  • Resolving Conflicts and Negotiating with Others2.63.3Level 4 looks like: Get two subordinates to agree about vacation schedules
  • Performing Administrative Activities2.53.0Level 4 looks like: Complete tax forms for a small business
  • Guiding, Directing, and Motivating Subordinates2.43.0Level 4 looks like: Manage a small team of employees in a dynamic workplace
  • Selling or Influencing Others2.32.1Level 1 looks like: Convince a coworker to assist with an assignment
  • Monitoring and Controlling Resources2.22.9
  • Staffing Organizational Units2.12.8
  • Assisting and Caring for Others1.81.5Level 1 looks like: Help a coworker complete an assignment
  • Inspecting Equipment, Structures, or Materials1.61.3Level 1 looks like: Check that doors to building are locked
  • Controlling Machines and Processes1.51.0Level 1 looks like: Operate a cash register
  • Drafting, Laying Out, and Specifying Technical Devices, Parts, and Equipment1.51.0Level 1 looks like: Specify the lighting for a work area
  • Repairing and Maintaining Electronic Equipment1.4—
  • Performing for or Working Directly with the Public1.2—
  • Handling and Moving Objects1.1—
  • Operating Vehicles, Mechanized Devices, or Equipment1.1—
  • Performing General Physical Activities1.1—
  • Repairing and Maintaining Mechanical Equipment1.0—

Work context

The conditions most characteristic of the work, on O*NET's 1–5 context scale.

  • E-Mail5.0
  • Spend Time Sitting4.9
  • Indoors, Environmentally Controlled4.8
  • Face-to-Face Discussions with Individuals and Within Teams4.5
  • Importance of Being Exact or Accurate4.4
  • Telephone Conversations4.3
  • Work With or Contribute to a Work Group or Team4.3
  • Freedom to Make Decisions4.1
  • Determine Tasks, Priorities and Goals3.9
  • Contact With Others3.4

Technology

159 tools

Software used in this work. In demand: among the tools job postings for this occupation name most. Hot: often named in job postings across the economy.

In demand (10)

  • Microsoft Accesshot
  • Microsoft Excelhot
  • Microsoft Office softwarehot
  • Microsoft Outlookhot
  • Microsoft Power BIhot
  • Microsoft PowerPointhot
  • Pythonhot
  • Structured query language SQLhot
  • Tableauhot
  • Operational Data Store ODS software

Hot (55; 9 more marked hot above)

  • Amazon DynamoDB
  • Amazon Elastic Compute Cloud EC2
  • Amazon Redshift
  • Amazon Web Services AWS software
  • Apache Cassandra
  • Apache Hadoop
  • Apache Hive
  • Apache Kafka
  • Apache Spark
  • Apache Subversion SVN
  • Apple macOS
  • Atlassian JIRA
  • Bash
  • C
  • C#
  • C++
  • Eclipse IDE
  • ESRI ArcGIS software
  • Extensible markup language XML
  • IBM SPSS Statistics
  • Informatica software
  • Linux
  • Microsoft .NET Framework
  • Microsoft Azure software
Show the other 31
  • Microsoft Project
  • Microsoft SharePoint
  • Microsoft SQL Server
  • Microsoft SQL Server Integration Services SSIS
  • Microsoft SQL Server Reporting Services SSRS
  • Microsoft Visio
  • Microsoft Visual Basic
  • Microsoft Visual Studio
  • Microsoft Windows
  • Microsoft Word
  • MongoDB
  • MySQL
  • NoSQL
  • Oracle Database
  • Oracle Java
  • Oracle PeopleSoft
  • Oracle PL/SQL
  • Perl
  • PostgreSQL
  • R
  • Red Hat Enterprise Linux
  • SAP software
  • SAS
  • Scala
  • Shell script
  • Splunk Enterprise
  • Teradata Database
  • The MathWorks MATLAB
  • Transact-SQL
  • UNIX
  • UNIX Shell
Other tools (94)
  • Adaptive Metadata Manager
  • Adeptia ETL Suite
  • Advanced business application programming ABAP
  • Altova MapForce
  • Amazon Simple Storage Service S3
  • Apache Avro
  • Apache Flume
  • Apache HBase
  • Apache HTTP Server
  • Apache Oozie
  • Apache Pig
  • Apache Solr
  • Apache Sqoop
  • Apatar
  • Aster Data nCluster
  • Blackbaud The Raiser's Edge
  • Cloudera Impala
  • CloverETL
  • CodeFutures dbShards
  • Coglin Mill RODIN
  • Common business oriented language COBOL
  • Customer information control system CICS
  • Embarcadero ER/Studio XE
  • Flat File Checker
  • Greenplum Database
  • Hewlett Packard HP-UX
  • HiT Software Allora
  • Human resource management software HRMS
  • IBM Clarity Systems Clarity
  • IBM Cognos Impromptu
  • IBM Domino
  • IBM InfoSphere DataStage
  • IBM Netezza TwinFin
  • IBM WebSphere
  • Informatica PowerCenter
  • Integrated development environment IDE software
  • InterMine
  • Jitterbit
  • Job control language JCL
  • Kalido Information Engine
  • KornShell
  • McAfee
  • Microsoft Dynamics
  • Microsoft Publisher
  • Microsoft Visual Basic Scripting Edition VBScript
  • MicroStrategy
  • Nagios
  • NetSuite ERP
  • NortonLifeLock cybersecurity software
  • Objective C
  • Oracle Business Intelligence Discoverer
  • Oracle Business Intelligence Enterprise Edition
  • Oracle E-Business Suite Financials
  • Oracle Fusion Applications
  • Oracle Hyperion
  • Oracle JD Edwards EnterpriseOne
  • Oracle Solaris
  • Oracle SQL Loader
  • Oracle Warehouse Builder
  • Oracle WebLogic Server
  • ParAccel Analytic Database
  • Pentaho Kettle
  • Perforce Helix software
  • Qlik Tech QlikView
  • Quest Erwin Data Modeler
  • Rapid-I RapidMiner
  • Relational database management software
  • Ruby on Rails
  • SAND
  • SAP Adaptive Server Enterprise
  • SAP Business Objects
  • SAP Crystal Reports
  • SAP IQ
  • SAP NetWeaver BW
  • SAP PowerDesigner
  • SAS Data Integration Server
  • Scriptella
  • SMSi Twister Data Integrator
  • StataCorp Stata
  • Talend Big Data Integration
  • Talend Data Fabric
  • Talend Open Studio
  • TalendForge
  • Teradata BTEQ
  • Teradata FastExport
  • Teradata FastLoad
  • Teradata Parallel Transporter
  • Teradata Tpump
  • TIBCO Spotfire
  • Ubuntu
  • Unified modeling language UML
  • Veritas NetBackup
  • VMware
  • WisdomForce DatabaseSync System

Related occupations

O*NET's own list of the occupations most related to this one, closest first.

  1. Database Architects
  2. Database Administrators
  3. Software Developers
  4. Computer Systems Analysts
  5. Computer Systems Engineers/Architects
  6. Software Quality Assurance Analysts and Testers
  7. Data Scientists
  8. Blockchain Engineers
  9. Business Intelligence Analysts
  10. Computer Programmers

ESCO equivalents

From the official ESCO–O*NET crosswalk, strongest match first. A broader occupation takes in this one; a narrower one is a part of it.

Closest occupations

Compare any occupation →

Other O*NET occupations whose importance ratings on the 35 skills both rate are nearest to this one's, with the biggest differences named. A plain rule, not a hidden score.

Use this in your own job architecture

BlissPoint Organization Viewer can link a role directly to this occupation and suggest these skills as that role's starting requirements.

Try it free →

This page includes information from the O*NET 31.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. ESCO occupations and skills are from the European Commission's ESCO classification, and the occupation crosswalk is the official ESCO–O*NET mapping by the ESCO Secretariat with USDOL/ETA. This service uses the ESCO classification of the European Commission. BlissPoint Analytics has modified all or some of this information: skill, task and descriptor ratings are rounded to one decimal, and ESCO occupations show Job Zone and interests copied from a crosswalked O*NET occupation. USDOL/ETA has not approved, endorsed, or tested these modifications.