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”

Prepare functional or technical documentation for data warehouses.
Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
Create or implement metadata processes and frameworks.
Design and implement warehouse database structures.
Test software systems or applications for software enhancements or new products.
Implement business rules via stored procedures, middleware, or other technologies.
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.
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 data warehouse process models, including sourcing, loading, transformation, and extraction.
Provide or coordinate troubleshooting support for data warehouses.
Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
Verify the structure, accuracy, or quality of warehouse data.
Select methods, techniques, or criteria for data warehousing evaluative procedures.
Review designs, codes, test plans, or documentation to ensure quality.
Map data between source systems, data warehouses, and data marts.
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.

Related Technology & Tools

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

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