Senior Data Engineer — Real-Time Analytics & Pipelines

PIXELATE EVERYTHING; Puchong; On-site; MYR 100,000 - 150,000; Full time

Job summary

A technology company is seeking a highly skilled Data Engineer to support its Marketing & Analytics Department in Puchong, Malaysia. This role focuses on developing robust data pipelines, ensuring data quality, and automating reporting workflows. The ideal candidate will have strong experience with ClickHouse and data streaming technologies, proficiency in SQL and Python, and familiarity with modern data integration practices. The company offers flexible working hours and comprehensive medical benefits.

Benefits

Flexi Working Hours

Medical, Optical and Dental Benefits

Body Screening and Insurance Claims

Qualifications

• Strong experience with ClickHouse or willingness to switch from other data warehouses.
• Hands-on experience with data streaming technologies.
• Proficiency in advanced SQL queries and optimization techniques.
• Experience building data pipelines and integrating analytics tools.
• Proficiency in Python for automation tasks.

Responsibilities

• Build and maintain ETL/ELT pipelines for analytics data.
• Design and manage ClickHouse schemas and optimize performance.
• Validate data and ensure high levels of data quality.
• Automate reporting workflows and integrate tracking tools.
• Develop APIs or microservices for data sharing.

Skills

ClickHouse

Kafka

SQL

Python

Airflow

Tools

dbt

Prefect

Job description

A technology company is seeking a highly skilled Data Engineer to support its Marketing & Analytics Department in Puchong, Malaysia. This role focuses on developing robust data pipelines, ensuring data quality, and automating reporting workflows. The ideal candidate will have strong experience with ClickHouse and data streaming technologies, proficiency in SQL and Python, and familiarity with modern data integration practices. The company offers flexible working hours and comprehensive medical benefits.