Will “Data Analyst” be Replaced By Robots? 🤔

Unknown Chance of Automation

Sadly, the research paper did not provide any information about this occupation. Maybe have a look at our directory?

Job Description

Design strategies for enterprise database systems and set standards for operations, programming, and security. Design and construct large relational databases. Integrate new systems with existing warehouse structure and refine system performance and functionality.

Job Details

The SOC (Standard Occupational Classification) code is 15-1199.06

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

Also Known As…

Tasks for “Data Analyst”

Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
Develop load-balancing processes to eliminate down time for backup processes.
Create and enforce database development standards.
Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
Identify and correct deviations from database development standards.
Develop or maintain archived procedures, procedural codes, or queries for applications.
Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
Develop data models for applications, metadata tables, views or related database structures.
Document and communicate database schemas, using accepted notations.
Design databases to support business applications, ensuring system scalability, security, performance and reliability.
Set up database clusters, backup, or recovery processes.
Plan and install upgrades of database management system software to enhance database performance.
Demonstrate database technical functionality, such as performance, security and reliability.
Provide technical support to junior staff or clients.
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
Test changes to database applications or systems.
Develop and document database architectures.

Related Technology & Tools

Copy machines
Load balancers
Laser facsimile machines
Personal computers

IBM Rational Data Architect
Hewlett Packard LoadRunner
IBM InfoSphere DataStage
Apache Solr
Oracle JD Edwards EnterpriseOne
Quest SQL Optimizer for Oracle
Oracle PL/SQL
IBM Domino
Rapid-I RapidMiner
IBM InfoSphere Warehouse
Transact-SQL
Apple Macintosh OS
Oracle Real Application Cluster RAC
C++
Application server software
SAP Business Objects
Jitterbit
Relational database management software
Apache HTTP Server
Coglin Mill RODIN
Oracle Data Integrator
Oracle Fusion Applications
Splunk Enterprise
C shell
Oracle Hyperion
Data Recovery Software SQL Server Data Recovery
Extensible markup language XML
CA Technologies ERWin Data Modeler
Apache Pig
Microsoft .NET Framework
Common business oriented language COBOL
SMSi Twister Data Integrator
Oracle Data Guard
Flat File Checker
ESRI ArcGIS software
C#
SAP Sybase Replication Server
Apache Oozie
Apache Cassandra
Cisco IOS
SAP Crystal Reports
Citrix
Adeptia ETL Suite
Apache Sqoop
Oracle Java
Amazon Kinesis
Veritas NetBackup
WisdomForce DatabaseSync System
SAS Data Integration Studio
SAS
PHP: Hypertext Preprocessor
MySQL
Hewlett Packard HP-UX
Oracle Solaris
Data modeling software
Apache Avro
Tableau
Informatica PowerCenter
Puppet
Red Hat WildFly
SAP
Microsoft PowerShell
Teradata Database
Microsoft Visio
Interface Computers Data Loader
Infobright Community Edition ICE
Advanced business application programming ABAP
Structured query language SQL
Spring Framework
Red Hat Enterprise Linux
IBM DB2
Apache Hbase
IBM Cognos Impromptu
UNIX
Microsoft Excel
Oracle Designer
Microsoft SQL Server
Unified modeling language UML
SAP Sybase PowerDesigner
SAP Sybase Adaptive Server Enterprise
Oracle WebLogic Server
Oracle Golden Gate
Microsoft Windows
Microsoft SharePoint
Pentaho Kettle
Intel Data Migration Software
Oracle JDBC
Oracle Application Server
Sybase
Microsoft Exchange Server
MongoDB
Microsoft ActiveX
Apache Spark
Dynamic hypertext markup language DHTML
IBM Content Manager
Talend Big Data Integration
Oracle Recovery Manager
Integrated development environment IDE software
Perl shell
SPSS
Customer information control system CICS
Oracle Jdeveloper
Symantec
Microsoft Visual Studio
Microsoft Active Server Pages ASP
HiT Software Allora
Apache Flume
MicroStrategy
NoSQL
Linux
Multidimensional Expressions MDX
Oracle Enterprise Manager
Epic Systems
R
CloverETL
Cloudera Impala
IBM Rational System Architect
PostgreSQL
IBM WebSphere
Apache Hadoop
Practical extraction and reporting language Perl
IBM AIX
Microsoft SQL Server Reporting Services
Enterprise JavaBeans
Adobe Systems Adobe Acrobat
Altova MapForce
CA Erwin Data Modeler
Oracle Business Intelligence Enterprise Edition
Ruby
Nagios
Perforce Helix software
Talend Open Studio
Oracle Migration Workbench
Scriptella
Microsoft Access
KornShell
Swift
Bash
Apatar
Job control language JCL
Python
Talend Data Fabric
Apache Hive
Microsoft Visual Basic
Microsoft Visual Basic Scripting Edition VBScript
Qlik Tech QlikView