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”

Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
Establish and calculate optimum values for database parameters, using manuals and calculator.
Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.
Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
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.
Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
Select and enter codes to monitor database performance and to create production database.
Review procedures in database management system manuals for making changes to database.
Work as part of a project team to coordinate database development and determine project scope and limitations.
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.
Test programs or databases, correct errors, and make necessary modifications.
Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
Revise company definition of data as defined in data dictionary.
Specify users and user access levels for each segment of database.
Modify existing databases and database management systems or direct programmers and analysts to make changes.

Related Technology & Tools

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

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