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, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

Job Details

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

☝️ Information based on the reference occupation “Data Warehousing Specialists”.

Also Known As…

Tasks for “Data Analyst”

Select methods, techniques, or criteria for data warehousing evaluative procedures.
Design and implement warehouse database structures.
Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
Implement business rules via stored procedures, middleware, or other technologies.
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
Map data between source systems, data warehouses, and data marts.
Review designs, codes, test plans, or documentation to ensure quality.
Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
Prepare functional or technical documentation for data warehouses.
Create or implement metadata processes and frameworks.
Test software systems or applications for software enhancements or new products.
Verify the structure, accuracy, or quality of warehouse data.
Provide or coordinate troubleshooting support for data warehouses.
Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.

Related Technology & Tools

Personal computers
Mainframe computers
Laptop computers
Multi-line telephone systems
Desktop computers
Storage servers
Data warehouse appliances
Computer servers

Teradata FastLoad
Microsoft SQL Server
Altova MapForce
Apache Subversion SVN
Microsoft Visual Studio
Oracle Java
Apache Avro
Apatar
Tableau
Flat File Checker
Oracle Solaris
Embarcadero ER/Studio XE
Apache HTTP Server
IBM Domino
Nagios
Objective C
Oracle JD Edwards EnterpriseOne
SAP
Structured query language SQL
Apache Sqoop
Microsoft .NET Framework
Linux
SMSi Twister Data Integrator
Microsoft SharePoint
Common business oriented language COBOL
Oracle Business Intelligence Enterprise Edition
Aster Data nCluster
Extensible markup language XML
Microsoft Project
ParAccel Analytic Database
Relational database management software
Talendforge
StataCorp Stata
Apache Flume
Apache Oozie
Talend Big Data Integration
InterMine
Apache Hbase
Apache Solr
Oracle Warehouse Builder
IBM Netezza TwinFin
Job control language JCL
Coglin Mill RODIN
Microsoft SQL Server Reporting Services
Teradata FastExport
IBM Cognos Impromptu
Oracle PeopleSoft
Unified modeling language UML
Blackbaud The Raiser's Edge
Adaptive Metadata Manager
Adeptia ETL Suite
Microsoft Visio
Microsoft Visual Basic
C#
Python
Kalido Information Engine
SAP NetWeaver Business Warehouse
Apache Hadoop
Microsoft Visual Basic Scripting Edition VBScript
R
C++
IBM Clarity Systems Clarity
Microsoft Excel
Eclipse IDE
Rapid-I RapidMiner
Practical extraction and reporting language Perl
Sybase
SAP Sybase PowerDesigner
Informatica PowerCenter
Integrated development environment IDE software
SAP Business Objects
Apache Cassandra
HiT Software Allora
SAP Sybase Adaptive Server Enterprise
Teradata Tpump
Ruby on Rails
CodeFutures dbShards
Transact-SQL
SAND
Apache Pig
Hewlett Packard HP-UX
SPSS
Oracle PL/SQL
Cloudera Impala
MySQL
Teradata BTEQ
WisdomForce DatabaseSync System
Splunk Enterprise
Talend Open Studio
CA Erwin Data Modeler
NetSuite ERP
Apple Macintosh OS
IBM WebSphere
IBM InfoSphere DataStage
KornShell
Apache Spark
Microsoft Outlook
Microsoft Windows
Oracle Business Intelligence Discoverer
Microsoft Word
Jitterbit
McAfee
Veritas NetBackup
ESRI ArcGIS software
Greenplum Database
SAP Sybase IQ
PostgreSQL
TIBCO Spotfire
UNIX
Teradata Database
CloverETL
Scriptella
Microsoft Office
NoSQL
Teradata Parallel Transporter
SAP Crystal Reports
Oracle SQL Loader
Apache Hive
Symantec
SAS
C
MicroStrategy
Perforce Helix software
Red Hat Enterprise Linux
Talend Data Fabric
Qlik Tech QlikView
Ubuntu
Oracle WebLogic Server
Microsoft Access
SAS Data Integration Server
Microsoft PowerPoint
Oracle Hyperion
The MathWorks MATLAB
Pentaho Kettle
MongoDB