Data Engineer - Ads Data

Responsibilities

TikTok is the leading destination for short-form mobile video. Our mission is to inspire creativity and bring joy. TikTok has global offices including Los Angeles, New York, London, Paris, Berlin, Dubai, Singapore, Jakarta, Seoul, and Tokyo.

Our ads data platform team works closely with our product managers and data analysts by building state-of-the-art streaming and batch data processing solutions. The entire data pipeline supports both the TikTok ads platform and our internal business intelligence platform. In this role, you will see a direct link between your work and the company's business success. You will have opportunities to deal with Petabyte-level data warehouse. Some of the world's most challenging technical and business problems are waiting for you to solve.

Responsibilities:

1. Work with product managers and data analysts to design data-related products.
2. Interface with engineers, product managers, and product analysts to understand data needs.
3. Build data expertise and own data quality for allocated areas of ownership.
4. Design, build, and launch new data extraction, transformation, and loading processes in production.
5. Support existing streaming and batch systems in production, solving on-call issues.
6. Define and manage SLA for all data sets in allocated areas of ownership.
7. Work with data infrastructure to triage infra issues and drive to resolution.
8. Support daily project management and assist junior engineers with business and technical problems.

Qualifications

1. BS/BA in Technical Field, Computer Science, or Mathematics.
2. 3+ years of experience in the data warehouse space.
3. 3+ years of experience in custom ETL design, implementation, and maintenance.
4. 2+ years of experience working with big data technologies (Hadoop, Hive, Spark, etc.).
5. 2+ years of experience with schema design and dimensional data modeling.
6. 3+ years of experience in writing SQL statements.
7. Proficient in one of the programming languages (e.g., Python, Java).
8. Communication skills including the ability to identify and communicate data-driven insights.
9. Ability to manage and communicate data warehouse plans to internal clients.

TikTok is committed to creating an inclusive space where employees are valued for their skills, experiences, and unique perspectives. Our platform connects people from across the globe and so does our workplace. At TikTok, our mission is to inspire creativity and bring joy. To achieve that goal, we are committed to celebrating our diverse voices and creating an environment that reflects the many communities we reach.

TikTok is committed to providing reasonable accommodations in our recruitment processes for candidates with disabilities, pregnancy, sincerely held religious beliefs, or other reasons protected by applicable laws. If you need assistance or a reasonable accommodation, please reach out to us at

Job Information:

For Pay Transparency

The base salary range for this position in the selected city is $129,960 - $194,750 annually. Compensation may vary outside of this range depending on a number of factors, including a candidate’s qualifications, skills, competencies, experience, and location. Base pay is one part of the Total Package that is provided to compensate and recognize employees for their work, and this role may be eligible for additional discretionary bonuses/incentives and restricted stock units.

Our company benefits are designed to convey company culture and values, to create an efficient and inspiring work environment, and to support our employees to give their best in both work and life. We offer the following benefits to eligible employees:

• 100% premium coverage for employee medical insurance, approximately 75% premium coverage for dependents, and a Health Savings Account (HSA) with a company match.
• Dental, Vision, Short/Long term Disability, Basic Life, Voluntary Life, and AD&D insurance plans.
• 10 paid holidays per year plus 17 days of Paid Personal Time Off (PPTO) (prorated upon hire and increased by tenure) and 10 paid sick days per year as well as 12 weeks of paid Parental leave and 8 weeks of paid Supplemental Disability.
• Mental and emotional health benefits through our EAP and Lyra.
• A 401K company match, gym, and cellphone service reimbursements.

The Company reserves the right to modify or change these benefits programs at any time, with or without notice.