Data Engineer (Security) - TikTok Shop

TIKTOK PTE. LTD.; Singapore; On-site; SGD 140,000 - 230,000; Full time

Job summary

TikTok PTE. LTD. is seeking a senior data engineering professional to build and safeguard the data warehouse for global e-commerce security. You will design data models, manage ETL, and ensure data quality to support live risk indicators across multiple regions.

Ideally, you have 5+ years in big data ecosystems with Spark, Flink, and ClickHouse, plus a solid grasp of Lambda/Kappa architectures and real-time pipelines. This role is office-based in Singapore with global impact.

Qualifications

• Bachelor's or higher degree in Computer Science, Information Technology, Programming & System Analysis, Science (Computer Studies) or related discipline.
• Candidates should have at least 5 years of experience in big data ecosystem development, familiar with technologies such as Spark, Flink, Clickhouse, Hadoop, and practical experience with Lambda/Kappa architectures.
• Proficient in data warehouse implementation methodologies, with a deep understanding of data warehouse systems, and experience supporting real-world business scenarios.
• Experience in SQL performance tuning, with an understanding of Hive SQL development.

Responsibilities

• Responsible for the offline data warehouse construction of global e-commerce security, including data layering, model design, ETL process, etc.
• Establish data warehouse standards for global e-commerce security to ensure data accuracy and consistency.
• Collaborate with the security team in optimising their offline tasks to ensure system stability and improving resource efficiency.
• Assist in identifying risk indicators through data analysis to support the development of key security projects.
• Support real-time data processing pipelines, including tagging systems and real-time ETL infrastructure.
• Visualise, interpret, and report data findings and may create dynamic data reports as well.

Skills

Big data ecosystem development

Spark & Flink

SQL performance tuning

Data warehouse design

Education

Bachelor's or higher degree in Computer Science, IT, Programming & System Analysis, Science (Computer Studies) or related discipline

Tools

Spark

Flink

ClickHouse

Hadoop

Hive SQL

Lambda/Kappa architectures

Job description

About TikTok

TikTok is the leading destination for short-form mobile video. At TikTok, our mission is to inspire creativity and bring joy. TikTok's global headquarters are in Los Angeles and Singapore, and we also have offices in New York City, London, Dublin, Paris, Berlin, Dubai, Jakarta, Seoul, and Tokyo.

Why Join Us

Inspiring creativity is at the core of TikTok's mission. Our innovative product is built to help people authentically express themselves, discover and connect - and our global, diverse teams make that possible. Together, we create value for our communities, inspire creativity and bring joy - a mission we work towards every day.

We strive to do great things with great people. We lead with curiosity, humility, and a desire to make impact in a rapidly growing tech company. Every challenge is an opportunity to learn and innovate as one team. We're resilient and embrace challenges as they come. By constantly iterating and fostering an "Always Day 1" mindset, we achieve meaningful breakthroughs for ourselves, our company, and our users. When we create and grow together, the possibilities are limitless. Join us.

Diversity & Inclusion

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 to creating an environment that reflects the many communities we reach. We are passionate about this and hope you are too.

Responsibilities

TikTok Shop is a content e-commerce business with international short video product as the carrier. It is committed to becoming the first choice for users to discover and purchase good products with affordable prices. TikTok Shop business team hopes to provide users with more tailored and efficient consumption experience, enabling merchants to receive reliable platform services in different scenarios such as live e-commerce, short video content e-commerce, thereby making more affordable and high-quality products easily accessible and improving lives.

The E-commerce Security team is responsible for safeguarding the platform's security and creating a safe, trustworthy shopping and business environment for TikTok Shop: allowing consumers to shop with confidence, sellers to operate with peace of mind, and influencers to focus on the enjoyment of bringing goods.

• Responsible for the offline data warehouse construction of global e-commerce security, including data layering, model design, ETL process, etc.
• Establish data warehouse standards for global e-commerce security to ensure data accuracy and consistency.
• Collaborate with the security team in optimising their offline tasks to ensure system stability and improving resource efficiency.
• Assist in identifying risk indicators through data analysis to support the development of key security projects.
• Support real-time data processing pipelines, including tagging systems and real-time ETL infrastructure.
• Visualise, interpret, and report data findings and may create dynamic data reports as well.

Minimum Qualifications

• Bachelor's or higher degree in Computer Science, Information Technology, Programming & System Analysis, Science (Computer Studies) or related discipline.
• Candidates should have at least 5 years of experience in big data ecosystem development, familiar with technologies such as Spark, Flink, Clickhouse, Hadoop, and practical experience with Lambda/Kappa architectures.
• Proficient in data warehouse implementation methodologies, with a deep understanding of data warehouse systems, and experience supporting real-world business scenarios.
• Experience in SQL performance tuning, with an understanding of Hive SQL development.

Preferred Qualifications

• Candidates with deep experience in real-time data warehouse construction.
• Data-sensitive with strong business understanding, excellent logical reasoning skills, and some data analysis capabilities.