Will “Data Warehouse Architect” be Replaced By Robots? 🤔

3% Chance of Automation

“Data Warehouse Architect” will not be replaced by robots.

This job is ranked #110 out of #702. A higher ranking (i.e., a lower number) means the job is less likely to be replaced.

Care to share? Click for Facebook, Twitter, LinkedIn, or XING. 👍

Job Description

Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases.

Job Details

The SOC (Standard Occupational Classification) code is 15-1141.00
The Mean Annual Wage in the U.S. is $ 87,130.00
The Mean Hourly Wage is $ 41.00
Currently, there are 113,730 people on this job

☝️ Information based on the reference occupation “Database Administrators”.

Also Known As…

Tasks for “Data Warehouse Architect”

Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
Modify existing databases and database management systems or direct programmers and analysts to make changes.
Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
Revise company definition of data as defined in data dictionary.
Establish and calculate optimum values for database parameters, using manuals and calculator.
Test programs or databases, correct errors, and make necessary modifications.
Work as part of a project team to coordinate database development and determine project scope and limitations.
Review procedures in database management system manuals for making changes to database.
Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
Review project requests describing database user needs to estimate time and cost required to accomplish project.
Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
Train users and answer questions.
Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.
Specify users and user access levels for each segment of database.
Select and enter codes to monitor database performance and to create production database.

Related Technology & Tools

Redundant array of independent disks RAID systems
Desktop computers
Tape libraries
Hard disk drives
Mainframe computers
Notebook computers

IBM Cognos Impromptu
CA Erwin Data Modeler
Customer information control system CICS
SPSS
LAMP Stack
Systems and data disaster recovery software
Restructured extended executor REXX
Oracle Java
Google AngularJS
Oracle Data Guard
Hewlett Packard HP-UX
Delphi Technology
Linux
Microsoft Project
Microsoft Dynamics GP
BMC Software Change Manager
SAP Crystal Reports
Microsoft Visual Basic Scripting Edition VBScript
Practical extraction and reporting language Perl
MongoDB
Oracle PeopleSoft
Quest Central
Nagios
StataCorp Stata
Data dictionary software
IBM InfoSphere DataStage
Microsoft Excel
Common business oriented language COBOL
Human resource management software HRMS
Job control language JCL
Drupal
Prolog
Transact-SQL
Oracle JD Edwards EnterpriseOne
Adobe Systems Adobe Flash
Oracle PL/SQL
CA IDMS
PostgreSQL
Index tuning software
Teradata Active Enterprise Data Warehouse
Catalog navigation software
Data validation software
C#
Oracle Solaris
R
NoSQL
Microsoft Exchange Server
Apache Hive
Apache Subversion SVN
BMC Software Recovery Manager RMAN
Hewlett Packard LoadRunner
Acronis Recovery Expert
Deployment software
Oracle Reports
Kornshell
Microsoft Visual Basic
Concurrency control software
Ext JS
Microsoft Visual C# .NET
Oracle Business Intelligence Enterprise Edition
Oracle SQL Loader
Minitab
Storage management software
Access management software
PHP: Hypertext Preprocessor
Oracle Application Express APEX
Microsoft Dynamics
Extensible markup language XML
Hewlett-Packard HP Omniback II
Apache Tomcat
Oracle JDBC
Microsoft PowerShell
Storage area network SAN software
ReCrystallize Crystal Reports
Integrated development environment IDE software
C++
Perforce Helix software
Database testing software
Data definition language DDL
Apache Pig
Test data generator software
Puppet
Oracle E-Business Suite Financials
Oracle Real Application Cluster RAC
Dynamic hypertext markup language DHTML
SAP Business Objects
Oracle WebLogic Server
MicroStrategy
Microsoft Visual Studio
Microsoft Windows
ESRI ArcGIS software
Microsoft .NET Framework
Teradata Database
FileMaker Pro
JavaScript
Object database management system ODBMS
Informatica Big Data
Enterprise JavaBeans
Microsoft Access
Sybase SQL Server
Node.js
IBM Informix
Informatica Corporation PowerCenter
Data modeling software
Database cloning software
Blackboard
McAfee
BMC Software Control-M
Citrix
Encryption software
IBM Domino
IBM ADSTAR
Oracle Hyperion
Microsoft Publisher
SAP
Oracle SQL Plus
Virtual private networking VPN software
Adobe Systems Adobe Dreamweaver
Dassault Systemes CATIA
Oracle PeopleSoft Financials
Legato NetWorker
Unified modeling language UML
Safe Software FME
Apache Solr
IBM Rational Data Architect
Extensible HyperText Markup Language XHTML
Wireshark
Microsoft Visio
The MathWorks MATLAB
Apache Struts
Data transformation services DTS software
Hibernate ORM
Database design software
Computer Associates Log Analyzer
Computer based training software
NetSuite ERP
Spring Framework
Relational database management software
Microsoft SQL Server
Microsoft Outlook
Epic Systems
Swift
Sybase PowerBuilder
Microsoft ActiveX
IBM Power Systems software
Hypertext markup language HTML
Cluster server software
Ruby on Rails
Tableau
Oracle Eloqua
Blackbaud The Raiser's Edge
Shell script
Microsoft Word
MySQL
Apache Hadoop
Data manipulation language DML
DOS shell script
Data entry software
Oracle JavaServer Pages JSP
Embarcadero Technologies DBArtisan
IBM WebSphere
Oracle Designer
Database security software
IBM DB2
Splunk Enterprise
Ruby
SAS
Git
IBM Notes
Microsoft PowerPoint
Microsoft SharePoint
Microsoft SQL Server Reporting Services
Oracle Enterprise Manager
Sybase Replication Server
Structured query language SQL
Apple Macintosh OS
Oracle Learning Management
Python
Advanced business application programming ABAP
Qlik Tech QlikView
Fund accounting software
Symantec
Sybase
Oracle Fusion Applications
Apache Cassandra
jQuery
Atlassian JIRA
Database capacity planning software
Apache HTTP Server
VERITAS NetBackup
Red Hat WildFly
Microsoft Office
Salesforce software
Oracle Primavera Enterprise Project Portfolio Management
Red Hat Enterprise Linux
Ubuntu
LexisNexis
UNIX
Micosoft SQL Server Analysis Services SSAS
Data mapping software
Microsoft SQL Server Integration Services SSIS
Visual Paradigm DB Visual ARCHITECT
Google Analytics
Eclipse IDE
AJAX
C
Microsoft Visual Basic.NET
Apache Maven