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”

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

Related Technology & Tools

Personal computers
Copy machines
Laser facsimile machines
Load balancers

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