data engineer

Database infrastructure specialist

A data engineer builds and maintains the systems that collect, store, and process large amounts of data.

Where data scientists analyze data to extract insights, data engineers create the infrastructure that makes such analysis possible—pipelines, databases, and processing frameworks.

We need a data engineer to rebuild our ETL pipeline before the analysts can work with this data.

ETL

pipeline

Long-distance fluid transport tube

batch processing · streaming · dataflow · scheduling · ELT · Luigi

code

Python

Large nonvenomous squeezer

  • SQLDatabase manipulation language
  • scriptingWriting executable commands
  • GitDistributed version control system

version control · debugging · APIs · unit testing · code review · notebooks · refactoring · functions · automation · shell scripting

database

SQL

Database manipulation language

  • NoSQLSchema-free database systems
  • schemasConceptual organizing structures
  • indexingSystematic organization for retrieval

normalization · relational · MySQL · Snowflake · Redshift · tables · queries · joins · partitioning · ACID

infrastructure

Kafka

Czech-Jewish literary surname

Hadoop · clusters · microservices · deployment · monitoring · logging · Prometheus · reliability · fault tolerance · scalability

cloud

AWS

Cloud computing platform

  • AzureMicrosoft cloud computing service
  • GCPGoogle's cloud computing platform
  • serverlessCloud-managed compute model

cloud storage · Lambda · EMR · Athena · cloud-native · auto-scaling · multi-cloud

governance

metadata

Descriptive information about content

documentation · Great Expectations · testing · monitoring · alerting · audit trails

Categories
Opposites
data pipeline role

data engineerdata analyst

Studies information for insights

business analyst · end user · data scientist · decision maker

data creation vs. data infrastructure

data engineerdata source

Information origin point

content creator · field researcher

technical infrastructure role

data engineerUI designer

Creates digital interface layouts

web designer · mobile developer · graphic designer · product designer

Family

data, engineer, engineering, engineered, engineers, reengineering, reengineer

Familiarity
Top 500,000
Profile
Used worldwide · Timeless · Rated G