Security Data Engineer - Real-Time, Big Data & ETL

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

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.