Big Data Engineer

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

Benefits offered by this job

Medical, dental, vision insurance

401k contributions

Paid time off (4+ weeks)

Bi-annual raises

Gym membership

Team-building events

Job summary

TP-Link Systems USA in California is seeking a data engineer to build, run and own ETL pipelines on EMR (Spark) orchestrated by Airflow. You will write SQL and Python for data ingestion and datasets used by analysts and dashboards.

You will own data quality, design data models, optimize performance and costs, and collaborate with analysts and business stakeholders to deliver reliable data products.

Qualifications

• 2–4 years of hands-on data development in production pipelines.
• Strong SQL with window functions and complex joins; understand slow queries.
• Python for production ETL and tooling (PySpark, pandas, boto3).
• Experience with Spark on cloud platforms (AWS EMR, Databricks, Glue).
• Experience with a scheduler (Airflow) and DAG design.
• Understanding of dimensional modeling and star schemas.
• Familiarity with AWS, Linux, and Git; ability to learn new tools.
• Bachelor’s degree or equivalent practical experience.

Responsibilities

• Build, run, and own ETL pipelines on EMR (Spark) orchestrated in Airflow.
• Write SQL and Python for data ingestion and datasets used by analysts.
• Own data quality checks and ensure correctness beyond job completion.
• Build and extend data models: fact and dimension tables following conventions.
• Keep jobs efficient; monitor runtime and cost, raise slow or expensive jobs.
• Reuse patterns and templates; automate repetitive tasks where possible.
• Collaborate with analysts and stakeholders to turn requests into usable datasets.

Skills

Strong SQL

Python for ETL

PySpark / Spark

Airflow

Dimensional modeling

AWS / Linux / Git

AI for data problems

Education

Bachelor's degree in Computer Science or related field

Tools

AWS EMR

Databricks

Glue

Airflow

S3 with Parquet/ORC

Job description

Headquartered in the United States, TP-Link Systems Inc. is a global provider of reliable networking devices and smart home products, consistently ranked as the world’s top provider of Wi-Fi devices. The company is committed to delivering innovative products that enhance people’s lives through faster, more reliable connectivity. With a commitment to excellence, TP-Link serves customers in over 170 countries and continues to grow its global footprint. We believe technology changes the world for the better! At TP-Link Systems Inc, we are committed to crafting dependable, high-performance products to connect users worldwide with the wonders of technology. Embracing professionalism, innovation, excellence, and simplicity, we aim to assist our clients in achieving remarkable global performance and enable consumers to enjoy a seamless, effortless lifestyle.

Key Responsibilities

• Build, run, and own ETL pipelines on EMR (Spark) orchestrated in Airflow - including their monitoring, alerting, and recovery.
• Write SQL and Python for data ingestion, transformation, and the datasets that analysts and dashboards depend on.
• Own data quality for what you build - run the checks before you ship and add new ones where they’re missing; confirm the results are correct, not only that the job completed.
• Build and extend the data models for your area: fact and dimension tables following the team’s layering conventions.
• Keep your jobs efficient - watch runtime and cost, and raise slow or expensive jobs rather than living with them.
• Use and extend the team’s shared patterns and templates, and turn work you find yourself repeating into something automated or reusable.
• Work with analysts and business stakeholders to turn requests into datasets that actually get used.

Required Qualifications

• 2-4 years of hands-on data development in a production environment - pipelines that run on a schedule with real downstream consumers, that you were responsible for including when they broke.
• Strong SQL: window functions, complex multi-table joins, incremental loads, and the ability to work out why a query is slow.
• Python for production ETL and tooling (PySpark, pandas, boto3) - code that runs on a schedule, not only notebooks.
• Hands-on experience with Spark on a cloud platform: AWS EMR, Databricks, Glue, or equivalent.
• Production experience with a scheduler, Airflow preferred: DAG design, dependencies, retries, and reruns that are safe to repeat.
• Working understanding of dimensional modeling: fact and dimension tables, star schema, and warehouse layering.
• Comfortable working on AWS (S3 with Parquet / ORC), Linux, and Git - and comfortable picking up new tools as the platform evolves.
• Effective use of AI to solve data problems - using it to move faster on SQL, debugging, and unfamiliar schemas, with the judgment to catch output that looks right but isn’t.
• Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent practical experience.

Preferred Qualifications

• Data ingestion or CDC tooling: DataX, Sqoop, Debezium, Fivetran, or similar.
• An OLAP / MPP engine: StarRocks, Doris, ClickHouse, Redshift, or similar.
• Spark performance work: partitioning, shuffle, skew, and memory tuning.
• AWS cost optimization: EMR instance sizing and Spot strategy, S3 lifecycle policies.
• Lakehouse formats (Iceberg, Hudi, Delta), streaming (Kafka, Flink), dbt, or a data quality framework.
• QuickSight or another BI tool: dataset and permission design.
• Self-directed learning: a project, an open-source contribution, or a tool you picked up on your own and put to real use.

Benefits

Salary Range: $100,000 -120,000

• Fully paid medical, dental, and vision insurance (partial coverage for dependents)
• Contributions to 401k funds
• Over four weeks of PTO per year
• Bi-annual pay increases
• Health and wellness benefits, including free gym membership
• Quarterly team-building events

At TP-Link Systems Inc., we are continually searching for ambitious individuals who are passionate about their work. We believe that diversity fuels innovation, collaboration, and drives our entrepreneurial spirit. As a global company, we highly value diverse perspectives and are committed to cultivating an environment where all voices are heard, respected, and valued. We are dedicated to providing equal employment opportunities to all employees and applicants, and we prohibit discrimination and harassment of any kind based on race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Beyond compliance, we strive to create a supportive and growth-oriented workplace for everyone. Please, no third-party agency inquiries, and we are unable to offer visa sponsorships at this time.

TP-Link is a leading provider of consumer Wi-Fi networking products. We continuously develop new products and technologies that transform the way people connect. Our networking expertise uniquely positions us as a leader in emerging technologies that improve our everyday lives, such as smart home products. Spacious and modern, our US offices create a casual atmosphere that fosters team collaboration. In addition to free snacks and drinks, TP-Link Systems Inc. offers a modern working environment, free gym membership, quarterly team building, flex-spending, employee paid benefits, bi-annual raise opportunity, paid vacation & holidays, 401k plan and annual bonus opportunity.