Senior Data Engineer

Job Description

We are looking for a highly skilled Data Engineer to support the Marketing & Analytics Department. This role focuses on building robust data pipelines, ensuring data quality, enabling accurate analytics, and supporting high-volume data operations across marketing, product, and BI use cases.

Responsibilities

1. Data Pipeline Development

• Build and maintain ETL/ELT pipelines for marketing, product, and user analytics data.
• Implement real-time streaming pipelines using Kafka, Redpanda, Pulsar, or equivalent.
• Integrate data from multiple platforms (GA4, GTM, ad platforms, CRM, tracking systems).
• Ensure scalable ingestion into ClickHouse or other columnar databases.

2. Data Infrastructure & Storage

• Design and manage ClickHouse schemas, tables, materialized views, and optimizations.
• Maintain data warehouse performance, partitioning, compression, and cost efficiency.
• Implement data retention policies and optimize for high-volume event data.

3. Data Quality & Governance

• Work closely with Marketing Data Analysts to support accurate event tracking.
• Validate incoming data, perform QA on new fields/events, maintain consistency.
• Establish naming conventions, data dictionary, and governance rules.
• Monitor pipelines and ensure high system uptime & data accuracy.

4. Data Integration & Automation

• Build connectors between tracking tools (GA4, PostHog, Mixpanel, Amplitude) and warehouse.
• Automate marketing and product reporting workflows.
• Support ingestion of pixel tracking data, ad conversions, campaign performance metrics.
• Develop APIs or microservices for data sharing across internal systems.

Required Skillset

Must-Have (At Least 5):

• Strong experience with ClickHouse (or Redshift/BigQuery/Snowflake with willingness to switch).
• Hands-on experience with data streaming (Kafka, Redpanda, Kinesis, Pulsar).
• Proficiency in SQL (advanced queries, window functions, optimization).
• Experience building pipelines using tools like Airflow, dbt, Prefect, or custom scripts.
• Experience integrating with marketing + product analytics tools (GA4, GTM, tracking SDKs).
• Proficiency in Python for ETL, API ingestion, and automation.
• Understanding of event-driven data models (events, properties, sessions, users).
• Experience with version control (Git) and CI/CD workflows for data.
• Able to write and talk in Chinese.

Good-to-Have (Bonus Skills):

• Experience with ClickHouse cluster administration (replication, sharding).
• Knowledge of marketing metrics (ROAS, CAC, LTV, attribution).
• Familiarity with BI tools (Tableau, Looker, Power BI, Metabase).
• Experience in fintech, ad-tech, or other high-volume tracking environments.
• Familiarity with tracking QA tools, SDK instrumentation, or tag management.

Benefits:

• Flexi Working Hours
• Optical and Dental
• Body Screening and Insurance Claims