Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
24 alternate job titles:
Analytics Manager
Big Data Engineer
Data Integrity Specialist
Data Management Engineer
Data Management Manager
Data Management Specialist
Data Migration Specialist
Data Quality Analyst
Data Specialist
Data Storage Specialist
Data Warehouse Analyst
Data Warehouse Developer
Data Warehouse Engineer
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 (Extract-Transform-Load Developer)
ETL Tester (Extract-Transform-Load Tester)
Research Data Specialist
Storage Engineer
Salary Information
Data Warehousing Specialists: $135,980 (median) per year.
Starting salary (10th percentile).
Required expreience: Varies by Company
Data source: U.S. Bureau of Labor Statistics
Daily Tasks & Responsibilities
| Task Description | Category |
|---|---|
| Test software performance. | General |
| Troubleshoot issues with computer applications or systems. | General |
| Document operational procedures. | General |
| Modify software programs to improve performance. | General |
| Write computer programming code. | General |
| Apply new technologies to improve work processes. | General |
| Apply information technology to solve business or other applied problems. | General |
| Evaluate project designs to determine adequacy or feasibility. | Analysis |
| Evaluate data quality. | Analysis |
| Analyze data to identify trends or relationships among variables. | Analysis |
| Design software applications. | Development |
| Develop performance metrics or standards related to information technology. | Development |
| Develop diagrams or flow charts of system operation. | Development |
| Create databases to store electronic data. | Development |
| Develop testing routines or procedures. | Development |
| Develop models of information or communications systems. | Development |
| Develop procedures for data management. | Management |
Showing 1 to 10 of 0 entries
Technology Requirements
| Technology | Description |
|---|---|
| Microsoft Access | Data base user interface and query software |
| Microsoft Power BI | Business intelligence and data analysis software |
| Structured query language SQL | Data base user interface and query software |
| Tableau | Business intelligence and data analysis software |
| Amazon DynamoDB | Data base management system software |
| Amazon Elastic Compute Cloud EC2 | Data base user interface and query software |
| Amazon Redshift | Data base user interface and query software |
| Amazon Web Services AWS software | Data base user interface and query software |
| Apache Cassandra | Data base management system software |
| Apache Hadoop | Data base management system software |
| Apache Hive | Data base user interface and query software |
| Informatica software | Metadata management software |
| Microsoft SQL Server | Data base user interface and query software |
| Microsoft SQL Server Reporting Services SSRS | Data base reporting software |
| MongoDB | Data base management system software |
| MySQL | Data base user interface and query software |
| NoSQL | Data base management system software |
| Oracle Database | Data base user interface and query software |
| Oracle PL/SQL | Data base management system software |
| PostgreSQL | Object oriented data base management software |
| Teradata Database | Data base management system software |
| Transact-SQL | Data base user interface and query software |
| Adaptive Metadata Manager | Metadata management software |
| Altova MapForce | Metadata management software |
| Apache Flume | Data base management system software |
| Apache HBase | Data base management system software |
| Apache Oozie | Data base management system software |
| Apache Pig | Data base management system software |
| Apache Solr | Data base management system software |
| Apache Sqoop | Data base management system software |
| Apatar | Metadata management software |
| Cloudera Impala | Data base user interface and query software |
| CodeFutures dbShards | Data base management system software |
| Coglin Mill RODIN | Metadata management software |
| Embarcadero ER/Studio XE | Metadata management software |
| Flat File Checker | Metadata management software |
| Greenplum Database | Data base management system software |
| HiT Software Allora | Metadata management software |
| IBM Cognos Impromptu | Business intelligence and data analysis software |
| IBM Netezza TwinFin | Data base reporting software |
| Informatica PowerCenter | Metadata management software |
| InterMine | Data base management system software |
| Kalido Information Engine | Data base management system software |
| MicroStrategy | Business intelligence and data analysis software |
| Oracle Business Intelligence Discoverer | Data base reporting software |
| Oracle Business Intelligence Enterprise Edition | Business intelligence and data analysis software |
| Oracle SQL Loader | Data base reporting software |
| Oracle Warehouse Builder | Metadata management software |
| ParAccel Analytic Database | Data base management system software |
| Pentaho Kettle | Metadata management software |
| Qlik Tech QlikView | Business intelligence and data analysis software |
| Quest Erwin Data Modeler | Metadata management software |
| Rapid-I RapidMiner | Data mining software |
| Relational database management software | Data base management system software |
| SAND | Data base management system software |
| SAP Adaptive Server Enterprise | Data base management system software |
| SAP Crystal Reports | Data base reporting software |
| SAP IQ | Data base management system software |
| SAP NetWeaver BW | Data mining software |
| SAP PowerDesigner | Metadata management software |
| SAS Data Integration Server | Metadata management software |
| Scriptella | Metadata management software |
| TIBCO Spotfire | Business intelligence and data analysis software |
| Talend Big Data Integration | Data base management system software |
| Talend Data Fabric | Metadata management software |
| TalendForge | Data base management system software |
| Teradata BTEQ | Data base user interface and query software |
| Teradata FastLoad | Data mining software |
| Teradata Parallel Transporter | Data mining software |
| Teradata Tpump | Data mining software |
| WisdomForce DatabaseSync System | Metadata management software |
| Microsoft Excel | Spreadsheet software |
| Microsoft Office software | Office suite software |
| Microsoft Outlook | Electronic mail software |
| Microsoft PowerPoint | Presentation software |
| Python | Object or component oriented development software |
| SAP software | Enterprise resource planning ERP software |
| Amazon Simple Storage Service S3 | Storage networking software |
| Apache Kafka | Development environment software |
| Apache Spark | Object or component oriented development software |
| Apache Subversion SVN | File versioning software |
| Apple macOS | Operating system software |
| Atlassian JIRA | Content workflow software |
| Bash | Operating system software |
| C | Development environment software |
| C# | Object or component oriented development software |
| C++ | Object or component oriented development software |
| Eclipse IDE | Development environment software |
| Extensible markup language XML | Enterprise application integration software |
| IBM SPSS Statistics | Analytical or scientific software |
| Linux | Operating system software |
| Microsoft .NET Framework | Development environment software |
| Microsoft Azure software | Development environment software |
| Microsoft Dynamics | Enterprise resource planning ERP software |
| Microsoft Project | Project management software |
| Microsoft SQL Server Integration Services SSIS | Enterprise application integration software |
| Microsoft SharePoint | Document management software |
| Microsoft Visio | Process mapping and design software |
| Microsoft Visual Basic | Development environment software |
| Microsoft Visual Studio | Development environment software |
| Microsoft Windows | Operating system software |
| Microsoft Word | Word processing software |
| Oracle Java | Object or component oriented development software |
| Oracle PeopleSoft | Enterprise resource planning ERP software |
| Perl | Object or component oriented development software |
| R | Object or component oriented development software |
| Red Hat Enterprise Linux | Operating system software |
| SAS | Analytical or scientific software |
| Scala | Object or component oriented development software |
| Shell script | Operating system software |
| Splunk Enterprise | Cloud-based management software |
| The MathWorks MATLAB | Analytical or scientific software |
| UNIX | Operating system software |
| UNIX Shell | Operating system software |
| Adeptia ETL Suite | Development environment software |
| Advanced business application programming ABAP | Object or component oriented development software |
| Apache Avro | Information retrieval or search software |
| Apache HTTP Server | Portal server software |
| Aster Data nCluster | Clustering software |
| Blackbaud The Raiser's Edge | Customer relationship management CRM software |
| CloverETL | Development environment software |
| Common business oriented language COBOL | Development environment software |
| Customer information control system CICS | Transaction server software |
| Hewlett Packard HP-UX | Operating system software |
| Human resource management software HRMS | Human resources software |
| IBM Clarity Systems Clarity | Enterprise resource planning ERP software |
| IBM Domino | Communications server software |
| IBM InfoSphere DataStage | Enterprise application integration software |
| IBM WebSphere | Cloud-based management software |
| Integrated development environment IDE software | Development environment software |
| Jitterbit | Cloud-based management software |
| Job control language JCL | Operating system software |
| KornShell | Operating system software |
| McAfee | Transaction security and virus protection software |
| Microsoft Publisher | Desktop publishing software |
| Microsoft Visual Basic Scripting Edition VBScript | Development environment software |
| Nagios | Network monitoring software |
| NetSuite ERP | Enterprise resource planning ERP software |
| NortonLifeLock cybersecurity software | Transaction security and virus protection software |
| Objective C | Object or component oriented development software |
| Oracle E-Business Suite Financials | Financial analysis software |
| Oracle Fusion Applications | Enterprise resource planning ERP software |
| Oracle Hyperion | Enterprise resource planning ERP software |
| Oracle JD Edwards EnterpriseOne | Enterprise resource planning ERP software |
| Oracle Solaris | Operating system software |
| Oracle WebLogic Server | Application server software |
| Perforce Helix software | Configuration management software |
| Ruby on Rails | Web platform development software |
| SAP Business Objects | Enterprise resource planning ERP software |
| SMSi Twister Data Integrator | Enterprise application integration software |
| StataCorp Stata | Analytical or scientific software |
| Talend Open Studio | Enterprise application integration software |
| Teradata FastExport | Document management software |
| Ubuntu | Operating system software |
| Unified modeling language UML | Requirements analysis and system architecture software |
| VMware | Clustering software |
| Veritas NetBackup | Backup or archival software |
| ESRI ArcGIS software | Geographic information system |
Showing 1 to 10 of 0 entries
Relevant Certifications
Industry certifications that may be valuable for this career role:
| Certification | Issuing Organization | Practice Test |
|---|---|---|
| AEM Dev/Ops Engineer | Adobe Systems Incorporated | Not Available |
| Associate Insurance Data Manager | Insurance Data Management Association | Not Available |
| Certified Associate BMC Discovery 11.x | BMC Software, Inc. | Not Available |
| Certified Data Management Administrator | Network Appliance, Inc. | Not Available |
| Certified Data Privacy Solutions Engineer | Information Systems Audit and Control Association | Not Available |
| Certified Data Professional - Associate | Institute for the Certification of Computing Professionals | Not Available |
| Certified Insurance Data Manager | Insurance Data Management Association | Not Available |
| Certified Professional BMC Discovery 11.x | BMC Software, Inc. | Not Available |
| Certified Public Sector Data Governance Professional - Mastery | Institute for the Certification of Computing Professionals | Not Available |
| Certified Public Sector Data Governance Professional - Principal | Institute for the Certification of Computing Professionals | Not Available |
| Cisco and NetApp FlexPod Design Specialist | Cisco Systems, Inc. | Not Available |
| Cloud Architect | Dell Corporation | Not Available |
| CompTIA Cloud Essentials | Computing Technology Industry Association (CompTIA) | Not Available |
| Data Governance and Stewardship Professional - Associate/Practitioner | Institute for the Certification of Computing Professionals | Not Available |
| Data Governance and Stewardship Professional - Foundation | Institute for the Certification of Computing Professionals | Not Available |
| Enterprise Geodata Management - Professional 10.5 | Environmental Systems Research Institute | Not Available |
| Expert - Implementation Engineer, Avamar Version 8.0 | Dell Corporation | Not Available |
| GIAC Information Security Fundamentals | Global Information Assurance Certification | Not Available |
| IBM Certified Solution Architect - Data Warehouse V1 | IBM Corporation | Not Available |
| IBM Certified Solution Developer - InfoSphere DataStage v11.3 | IBM Corporation | Not Available |
| IBM Certified Solution Implementer - DataPower Gateway v7.6 | IBM Corporation | Not Available |
| IBM Certified Specialist - IBM Cloud Object Storage V3.14 | IBM Corporation | Not Available |
| Information System Analyst | Institute for the Certification of Computing Professionals | Not Available |
| MySQL 8.0 Database Administrator | Oracle Corporation | Not Available |
| MySQL 8.0 Database Developer | Oracle Corporation | Not Available |
| NetApp Certified Storage Associate - Hybrid Cloud | Network Appliance, Inc. | Not Available |
| NetApp Certified Technologfy Associate | Network Appliance, Inc. | Not Available |
| Oracle Cloud Infrastructure 2021 Architect Professional | Oracle Corporation | Not Available |
| Oracle Cloud Infrastructure 2021 Certified Architect Professional | Oracle Corporation | Not Available |
| Oracle Cloud Infrastructure 2021 Certified Cloud Operations Associate | Oracle Corporation | Not Available |
| Oracle Database 12c Administrator Certified Master | Oracle Corporation | Not Available |
| Oracle Database 12c Essentials | Oracle Corporation | Not Available |
| Oracle Database 12c: Advanced Administration | Oracle Corporation | Not Available |
| Oracle Database SQL | Oracle Corporation | Not Available |
| SAP Certified Application Associate - Extended Warehouse Management with SAP S/4HANA | SAP America, Inc. | Not Available |
| SAP Certified Application Associate - Modeling and Data Acquisition with SAP BW 7.5 powered by SAP H | SAP America, Inc. | Not Available |
| SAP Certified Application Specialist - SAP BW/4HANA 2.0 Delta | SAP America, Inc. | Not Available |
| SAS Certified Predictive Modeler Using SAS Enterprise Miner 14 | SAS Institute, Inc. | Not Available |
| SAS Certified Advanced Analytics Professional Using SAS 9 | SAS Institute, Inc. | Not Available |
| SAS Certified Big Data Professional Using SAS 9 | SAS Institute, Inc. | Not Available |
| SAS Certified Clinical Trials Programmer Using SAS 9 | SAS Institute, Inc. | Not Available |
| SAS Certified Data Integration Developer for SAS 9 | SAS Institute, Inc. | Not Available |
| SAS Certified Data Quality Steward for SAS 9 | SAS Institute, Inc. | Not Available |
| SAS Certified Data Scientist Using SAS 9 | SAS Institute, Inc. | Not Available |
| SNIA Certified Storage Architect | Storage Networking Industry Association | Not Available |
| SNIA Certified Storage Engineer | Storage Networking Industry Association | Not Available |
| SNIA Certified Storage Networking Expert | Storage Networking Industry Association | Not Available |
| SNIA Certified Storage Professional | Storage Networking Industry Association | Not Available |
| Specialist - Implementation Engineer, Data Domain Version 2.0 | Dell Corporation | Not Available |
| Specialist - Implementation Engineer, Dell EMC Unity Solutions Version 1.0 | Dell Corporation | Not Available |
| Specialist - Implementation Engineer, Isilon Solutions Version 3.0 | Dell Corporation | Not Available |
| Specialist - Systems Administrator, Avamar Version 8.0 | Dell Corporation | Not Available |
| Teradata Database Associate | Teradata | Not Available |
| Upgrade to Oracle Database 12c | Oracle Corporation | Not Available |
| VMware Certified Advanced Professional - Network Virtualization Deploy 2022 | VMWare | Not Available |
Showing 1 to 10 of 0 entries