Data Engineer: Data Lakehouse & Pipeline Architect

KLK OLEO; Selangor; On-site; MYR 60,000 - 100,000; Full time

Job summary

KLK OLEO is hiring a data management professional based in Mutiara Damansara, Petaling Jaya to oversee MS SQL Server, PostgreSQL and DuckDB. You will ensure stability, build scalable data pipelines, and drive data quality across analytics workloads.

Responsibilities include optimizing T-SQL, scheduling workflows, and contributing to a data lakehouse transformation while establishing governance and documentation standards.

Qualifications

• Experience with data warehousing concepts and dimensional modeling (star/snowflake).
• Proficiency in MS SQL Server, T-SQL development, and performance tuning.
• Knowledge of data pipelines, ETL/ELT, and data governance practices.

Responsibilities

• Support end-to-end management of MS SQL Server, PostgreSQL and DuckDB databases for stability and reliability.
• Develop scalable data pipelines and optimize end-to-end data workflows.
• Document data lineage, definitions and pipeline logic for team accessibility.

Skills

SQL

PowerShell

Python

T-SQL

SSIS

ADF

Data modelling

Education

Bachelor's degree in IT/CS/Data Analytics/Engineering

Tools

MS SQL Server

PostgreSQL

DuckDB

ADLS2

Job description

KLK OLEO is hiring a data management professional based in Mutiara Damansara, Petaling Jaya to oversee MS SQL Server, PostgreSQL and DuckDB. You will ensure stability, build scalable data pipelines, and drive data quality across analytics workloads.

Responsibilities include optimizing T-SQL, scheduling workflows, and contributing to a data lakehouse transformation while establishing governance and documentation standards.