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

Related Technology & Tools

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

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