Data Engineer: Build Scalable Data Pipelines & Lakehouse

KLK OLEO; Petaling Jaya; On-site; MYR 70,000 - 95,000; Full time

Job summary

KLK OLEO is seeking a Data Management and Platform Transformation specialist based in Mutiara Damansara, Petaling Jaya. You will manage MS SQL Server, PostgreSQL and DuckDB, ensuring stability, scalability and reliable data delivery across pipelines.

You will optimize T-SQL, orchestrate complex workflows with SSIS and ADF, and collaborate with business stakeholders to translate requirements into robust data solutions, while contributing to governance and documentation.

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, Engineering or a related STEM field.
• Minimum 1 year of experience in business solutioning, data/analytics consulting or a data warehouse delivery role with stakeholder engagement.
• Proficiency in MS SQL Server; T-SQL development, query optimization and performance tuning.
• Knowledge of star/snowflake schemas, SCD, and staging/ODS design patterns for schema and pipeline decisions.
• Strong documentation, data quality validation and issue escalation abilities.

Responsibilities

• Manage end-to-end MS SQL Server, PostgreSQL and DuckDB databases for stability and reliability.
• Develop scalable data pipelines and optimize ETL/ELT processes.
• Write and optimize T-SQL queries, procedures, views, functions and triggers.
• Orchestrate data workflows and monitor job statuses.
• Collaborate with stakeholders to translate requirements into technical solutions.
• Support data governance, lineage, and metadata documentation.

Skills

SQL

PowerShell

Python

Education

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

Tools

MS SQL Server

PostgreSQL

DuckDB

SSIS

ADF

ADLS2

Job description

KLK OLEO is seeking a Data Management and Platform Transformation specialist based in Mutiara Damansara, Petaling Jaya. You will manage MS SQL Server, PostgreSQL and DuckDB, ensuring stability, scalability and reliable data delivery across pipelines.

You will optimize T-SQL, orchestrate complex workflows with SSIS and ADF, and collaborate with business stakeholders to translate requirements into robust data solutions, while contributing to governance and documentation.