Career Details
Career Details
Use this dropdown to update your zip code
Back to top

Career Details

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.


Key Facts
Expand or Shrink Accordion
Bright Outlook
Career Details
Green Job
Career Details
Current Employment
N/A
Estimate
Forecasted Employment
N/A
Estimate
Change in Employment
N/A
Estimate
Change in Employment %
N/A
Estimate
Tasks
Expand or Shrink Accordion
Tasks
The tasks listed below can be performed to prepare you for a career in this field.
Core
  • 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.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Knowledge
Expand or Shrink Accordion
Knowledge

The items listed below are organized into sections that contain knowledge useful for pursuing a career in this field. Each section also contains a "Percentage of Importance" statistic that shows how relevant an item is to the occupation.
 Computers and Electronics
  • 85%
    Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
 Mathematics
  • 65%
    Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
 English Language
  • 64%
    Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
 Design
  • 61%
    Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
 Engineering and Technology
  • 57%
    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.
 Administration and Management
  • 52%
    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.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Tools
Expand or Shrink Accordion
Tools
The tools listed below include machines, equipment, tools, and software that is useful for individuals who are interested in this career.
 Computers
  • Computer servers
  • Data warehouse appliances
  • Desktop computers
  • Laptop computers
  • Mainframe computers
  • Personal computers
  • Storage servers
 Personal communication devices
  • Multi-line telephone systems
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Technology
Expand or Shrink Accordion
Technology
The technologies listed below include machines, equipment, tools, and software that is useful for individuals who are interested in this career.
 Data management and query software
  • Adaptive Metadata Manager
  • Altova MapForce
  • Amazon DynamoDBHOT
  • Amazon Elastic Compute Cloud EC2HOT
  • Amazon RedshiftHOT
  • Amazon Web Services AWS softwareHOT
  • Apache Avro
  • Apache CassandraHOT
  • Apache Flume
  • Apache HadoopHOT
  • Apache Hbase
  • Apache HiveHOT
  • Apache HTTP ServerHOT
  • Apache Oozie
  • Apache PigHOT
  • Apache SolrHOT
  • Apache Sqoop
  • Apatar
  • Aster Data nCluster
  • Blackbaud The Raiser's Edge
  • CA Erwin Data Modeler
  • Cloudera Impala
  • CodeFutures dbShards
  • Coglin Mill RODIN
  • Customer information control system CICS
  • Data entry softwareHOT
  • Embarcadero ER/Studio XE
  • Flat File Checker
  • Greenplum Database
  • HiT Software Allora
  • IBM Cognos ImpromptuHOT
  • IBM Netezza TwinFin
  • Informatica PowerCenter
  • InterMine
  • Kalido Information Engine
  • Microsoft AccessHOT
  • Microsoft SQL ServerHOT
  • Microsoft SQL Server Reporting ServicesHOT
  • MicroStrategyHOT
  • MongoDBHOT
  • MySQLHOT
  • NoSQLHOT
  • Oracle Business Intelligence Discoverer
  • Oracle Business Intelligence Enterprise EditionHOT
  • Oracle PL/SQLHOT
  • Oracle softwareHOT
  • Oracle SQL Loader
  • Oracle Warehouse Builder
  • ParAccel Analytic Database
  • Pentaho Kettle
  • PostgreSQLHOT
  • Qlik Tech QlikViewHOT
  • Rapid-I RapidMiner
  • Relational database management softwareHOT
  • SAND
  • SAP Adaptive Server Enterprise
  • SAP Crystal ReportsHOT
  • SAP IQ
  • SAP NetWeaver Business Warehouse
  • SAP PowerDesigner
  • SAS Data Integration Server
  • Scriptella
  • Structured query language SQLHOT
  • TableauHOT
  • Talend Big Data Integration
  • Talend Data Fabric
  • Talendforge
  • Teradata BTEQ
  • Teradata DatabaseHOT
  • Teradata FastLoad
  • Teradata Parallel Transporter
  • Teradata Tpump
  • TIBCO Spotfire
  • Transact-SQLHOT
  • WisdomForce DatabaseSync System
 Development software
  • Adeptia ETL Suite
  • Advanced business application programming ABAPHOT
  • Apache KafkaHOT
  • Apache SparkHOT
  • C
  • C#HOT
  • C++HOT
  • CloverETL
  • Common business oriented language COBOLHOT
  • Eclipse IDEHOT
  • Extensible markup language XMLHOT
  • IBM InfoSphere DataStage
  • IBM WebSphereHOT
  • Integrated development environment IDE softwareHOT
  • Jitterbit
  • Microsoft .NET FrameworkHOT
  • Microsoft AzureHOT
  • Microsoft SQL Server Integration Services SSISHOT
  • Microsoft Visual BasicHOT
  • Microsoft Visual Basic Scripting Edition VBScriptHOT
  • Microsoft Visual StudioHOT
  • Objective CHOT
  • Oracle JavaHOT
  • Perforce Helix software
  • Practical extraction and reporting language PerlHOT
  • PythonHOT
  • RHOT
  • Ruby on RailsHOT
  • ScalaHOT
  • SMSi Twister Data Integrator
  • Talend Open Studio
  • Unified modeling language UMLHOT
  • VMWareHOT
 Networking software
  • Amazon Simple Storage Service S3HOT
  • IBM Domino
 Content management software
  • Apache Subversion SVNHOT
  • Atlassian JIRAHOT
  • Teradata FastExport
 Operating environment software
  • Apple macOSHOT
  • BashHOT
  • Hewlett Packard HP-UX
  • Job control language JCL
  • KornShell
  • LinuxHOT
  • Microsoft WindowsHOT
  • Oracle SolarisHOT
  • Red Hat Enterprise LinuxHOT
  • Shell scriptHOT
  • Ubuntu
  • UNIXHOT
  • UNIX ShellHOT
 Information exchange software
  • ESRI ArcGIS softwareHOT
  • Microsoft OutlookHOT
 Business function specific software
  • Human resource management software HRMS
  • Microsoft OfficeHOT
  • Microsoft ProjectHOT
  • Microsoft SharePointHOT
 Finance accounting and enterprise resource planning ERP software
  • IBM Clarity Systems ClarityHOT
  • Microsoft DynamicsHOT
  • NetSuite ERPHOT
  • Oracle E-Business Suite Financials
  • Oracle Fusion ApplicationsHOT
  • Oracle HyperionHOT
  • Oracle JD Edwards EnterpriseOneHOT
  • Oracle PeopleSoftHOT
  • SAPHOT
  • SAP Business ObjectsHOT
 Industry specific software
  • IBM SPSS StatisticsHOT
  • SASHOT
  • StataCorp Stata
  • The MathWorks MATLABHOT
 Content authoring and editing software
  • Microsoft ExcelHOT
  • Microsoft PowerPointHOT
  • Microsoft Publisher
  • Microsoft VisioHOT
  • Microsoft WordHOT
 Network applications software
  • Oracle WebLogic ServerHOT
 System management software
  • Splunk EnterpriseHOT
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Certifications
Expand or Shrink Accordion
Certifications
The certifications listed below are useful to pursue if you are interested in a career in this field.
No specific certifications are listed for this career
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Licensing
Expand or Shrink Accordion
Licensing
The licensing information below is organized into sections and is useful for pursuing if you are interested in a career in this field.
No specific licensing information is listed for this occupation in the area you have selected.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Related Programs
Expand or Shrink Accordion
Online Programs related to this career, offered by participating institution(s), are listed below.

Clicking on the Degree programs in the list below will take you away from the Careers page.
INSTITUTION
PROGRAMS
Blue Ridge Community College
Brightpoint Community College
Central Virginia Community College
Germanna Community College
J Sargeant Reynolds Community College
Laurel Ridge Community College
Mountain Empire Community College
Mountain Gateway Community College
New River Community College
Northern Virginia Community College
Patrick & Henry Community College
Paul D. Camp Community College
Piedmont Virginia Community College
Rappahannock Community College
Southside Virginia Community College
Southwest Virginia Community College
Tidewater Community College
Virginia Peninsula Community College
Virginia Western Community College
Wytheville Community College