ABOUT US:
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.
Requirements
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
Base Salary Range: $100 - 120K
- Free snacks and drinks
- Fully paid medical, dental, and vision insurance (partial coverage for dependents)
- Contributions to 401K funds
- Bi-annual reviews, and 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. If you share our passion and connection to this mission, we welcome you to apply and join us in building a vibrant and inclusive team at TP-Link Systems Inc.
Please, no third-party agency inquiries, and we are unable to offer visa sponsorships at this time.
Skills Required
- Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent practical experience.
- 2+ years of hands-on data development in a production environment.
- Production ownership of a data pipeline or platform component, including incident accountability.
- Strong SQL skills, including window functions, complex joins, incremental and idempotent writes, execution plans, data skew, and query tuning.
- Production-grade Python experience for maintainable, testable ETL and tooling code, including PySpark, pandas, or boto3.
- Hands-on Apache Spark on Amazon EMR or equivalent Hadoop/Hive experience, including partitioning, shuffle, and memory tuning.
- Production experience with Apache Airflow, including DAG design, dependencies, retries, idempotent reruns, backfills, and SLA alerting.
- Production experience with a data ingestion or CDC tool such as DataX, Sqoop, or Debezium.
- Experience with an OLAP engine such as StarRocks, Doris, or ClickHouse, including table modeling, partitioning, bucketing, materialized views, and query tuning.
- Strong understanding of data warehouse modeling, dimensional modeling, slowly changing dimensions, and warehouse layering conventions.
- Working knowledge of AWS, including S3 with Parquet or ORC, partitioning, IAM basics, and day-to-day EMR operations.
- Working knowledge of Linux and Git.
- Ability to learn new tools and engines as the data platform evolves.
- Effective use of AI for SQL, debugging, and unfamiliar schemas, with judgment to validate outputs.
- AWS cost optimization, including EMR instance sizing, Spot strategy, S3 lifecycle policies, and StarRocks versus Athena trade-offs.
- Experience with Iceberg, Hudi, or Delta Lake table formats.
- Streaming experience with Kafka and Flink or Spark Structured Streaming.
- Experience with dbt, AWS Glue Data Catalog, data lineage, or a data quality framework.
- Experience designing QuickSight datasets, SPICE usage, and row-level permissions.
TP-Link USA Corporation Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about TP-Link USA Corporation and has not been reviewed or approved by TP-Link USA Corporation.
-
Strong & Reliable Incentives — Incentives are highlighted through performance bonuses and employee product discounts, with several roles also noting annual or twice‑yearly bonus/raise opportunities. This signals a consistent emphasis on variable pay alongside base salary.
-
Healthcare Strength — Multiple U.S. job postings state fully paid medical, dental, and vision coverage for employees, alongside HSA/FSA options. This points to robust core health benefits in many roles.
-
Leave & Time Off Breadth — Hiring materials describe paid vacation (around 15 days) plus approximately 11 paid holidays and sick time. Together, these elements indicate a comprehensive time‑off program on paper.
TP-Link USA Corporation Insights
What We Do
Ranked “Highest in Customer Satisfaction for Wireless Routers” by J.D. Power. TP-Link is an industry-leading provider of wireless networking products. With tens of millions of customers in more than 120 countries, TP-Link’s consumer and business products reflect the company’s substantial investment in research and development and meticulous in-house design, manufacturing and testing. TP-Link’s award-winning product line includes routers, range extenders, switches, network adapters, IP cameras, media converters, Powerline adapters and smart home products. TP-Link products are available from the world’s leading distributors, resellers and consumer tech retailers. TP-Link’s U.S. presence includes its headquarters in Brea, CA. For career-related inquiries, please contact [email protected].
