Data Warehousing Specialists
SOC: 15-1199.07

Description:

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


National Salary Information:

Hourly Statistics:

Annual Statistics:

Source: Bureau of Labor Statistics 2015 wage data.


Employment Projections:

Employment (2014):
233,000 employed

Projected (2024):
240,800 employed

Projected growth (2014-2024)


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


Alternate Titles:

  • Data Analyst
  • Data Manager
  • Data Storage Specialist
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • Data Warehouse Specialist
  • Data Warehousing Engineer
  • Data Warehousing Manager
  • Data Warehousing Specialist
  • Datastage Developer
  • Integration Engineer


  • Tasks:

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

  • Tools & Technology:

  • Computer servers
  • Data warehouse appliances
  • Desktop computers
  • Laptop computers
  • Mainframe computers
  • Multi-line telephone systems
  • Personal computers
  • Storage servers
  • Adaptive Metadata Manager
  • Adeptia ETL Suite
  • Altova MapForce
  • Apache Avro
  • Apache Cassandra
  • Apache Flume
  • Apache Hadoop
  • Apache Hbase
  • Apache Hive
  • Apache Oozie
  • Apache Pig
  • Apache Solr
  • Apache Sqoop
  • Apatar
  • Apple Macintosh OS
  • Aster Data nCluster
  • Blackbaud The Raiser's Edge
  • C
  • C#
  • C++
  • CA Erwin Data Modeler
  • Cloudera Impala
  • CloverETL
  • CodeFutures dbShards
  • Coglin Mill RODIN
  • Common business oriented language COBOL
  • Embarcadero ER/Studio XE
  • ESRI ArcGIS software
  • Extensible markup language XML
  • Flat File Checker
  • Greenplum Database
  • Hewlett Packard HP-UX
  • HiT Software Allora
  • IBM Clarity Systems Clarity
  • IBM Cognos Impromptu
  • IBM InfoSphere DataStage
  • IBM Netezza TwinFin
  • IBM WebSphere
  • Informatica PowerCenter
  • InterMine
  • Jitterbit
  • Job control language JCL
  • Kalido Information Engine
  • KornShell
  • Linux
  • McAfee software
  • Microsoft .NET Framework
  • Microsoft Access
  • Microsoft Excel
  • Microsoft Office software
  • Microsoft Outlook
  • Microsoft PowerPoint
  • Microsoft Project
  • Microsoft SharePoint software
  • Microsoft SQL Server Reporting Services
  • Microsoft SQL Server software
  • Microsoft Visio
  • Microsoft Visual Basic
  • Microsoft Visual Basic Scripting Edition VBScript
  • Microsoft Visual Studio
  • Microsoft Windows
  • Microsoft Word
  • MicroStrategy software
  • MongoDB
  • MySQL software
  • NoSQL software
  • Objective C
  • Oracle Business Intelligence Discoverer
  • Oracle Business Intelligence Enterprise Edition
  • Oracle Hyperion software
  • Oracle Java
  • Oracle JD Edwards EnterpriseOne
  • Oracle PeopleSoft software
  • Oracle PL/SQL
  • Oracle Solaris
  • Oracle SQL Loader
  • Oracle Warehouse Builder
  • ParAccel Analytic Database
  • Pentaho Kettle
  • PostgreSQL software
  • Practical extraction and reporting language Perl
  • Python
  • Qlik Tech QlikView
  • R
  • Rapid-I RapidMiner
  • Red Hat Enterprise Linux
  • Relational database management software
  • Ruby on Rails
  • SAND
  • SAP Business Objects software
  • SAP Crystal Reports
  • SAP NetWeaver Business Warehouse
  • SAP software
  • SAP Sybase Adaptive Server Enterprise
  • SAP Sybase IQ
  • SAP Sybase PowerDesigner
  • SAS Data Integration Server
  • SAS software
  • Scriptella
  • SMSi Twister Data Integrator
  • Spark
  • Splunk Enterprise
  • SPSS software
  • StataCorp Stata
  • Structured query language SQL
  • Sybase software
  • Symantec security software
  • Tableau software
  • Talend Big Data Integration
  • Talend Data Fabric
  • Talend Open Studio
  • Talendforge
  • Teradata BTEQ
  • Teradata Database
  • Teradata FastExport
  • Teradata FastLoad
  • Teradata Parallel Transporter
  • Teradata Tpump
  • The MathWorks MATLAB
  • TIBCO Spotfire
  • Transact-SQL
  • Unified modeling language UML
  • UNIX
  • Veritas NetBackup
  • WisdomForce DatabaseSync System


  • computer and mathematical


    industry stats

    SOC: 15-0000

    Total Employed: 4,005,250

    Average Annual Salary: $86,170