Data Engineer - Spark, Airflow & ETL Pipelines

TP-Link; Irvine (CA); On-site; USD 100,000 - 120,000; Full time

Benefits offered by this job

Free snacks and drinks

Fully paid medical, dental, and vision

401K contribution

Bi-annual reviews and pay raises

Gym membership

Team-building events

Job summary

TP-Link Systems Inc. in Irvine, CA is seeking a data engineer to design and operate scalable ETL pipelines on AWS cloud.

You will build pipelines on EMR/Spark orchestrated by Airflow, write SQL and Python, ensure data quality, and partner with analysts to deliver reliable datasets for dashboards and analytics. Experience with dimensional modeling, star schema, and lakehouse formats recommended; comfortable with Parquet/ORC, S3, Git, and cost-conscious engineering.

Qualifications

• 2–4 years of hands-on data development in production environments.

Responsibilities

• Build, run, and own ETL pipelines on EMR (Spark) orchestrated in Airflow.
• Write SQL and Python for data ingestion, transformation, and datasets for dashboards.
• Own data quality checks and extend data models (fact & dimension, star schema).
• Keep jobs efficient in runtime and cost, and automate repetitive tasks.
• Collaborate with analysts and stakeholders to deliver usable datasets.

Skills

SQL

Python

Airflow

AWS

Data modeling

Git

Pandas

PySpark

Education

Bachelor's degree in Computer Science or related field

Tools

Spark

Databricks

Airflow

Databases (SQL)

boto3

Job description

TP-Link Systems Inc. in Irvine, CA is seeking a data engineer to design and operate scalable ETL pipelines on AWS cloud.

You will build pipelines on EMR/Spark orchestrated by Airflow, write SQL and Python, ensure data quality, and partner with analysts to deliver reliable datasets for dashboards and analytics. Experience with dimensional modeling, star schema, and lakehouse formats recommended; comfortable with Parquet/ORC, S3, Git, and cost-conscious engineering.