Senior Data Engineer: Lakehouse & Data Warehouse Lead

KLK OLEO; Selangor; On-site; MYR 120,000 - 190,000; Full time

Job summary

KLK OLEO in Malaysia is seeking a senior Data Engineer to manage MS SQL Server, PostgreSQL and DuckDB, ensuring stable, scalable data solutions for analytics.

You will design data ingestion from SAP ECC6, orchestrate complex data workflows, enforce governance, optimize performance, and collaborate with business stakeholders to deliver a trusted data platform. A strong background in data modeling and lakehouse technologies is required.

Qualifications

• Minimum of 5 years in data/analytics consulting or a data warehouse delivery role with direct stakeholder partnership.
• Experience with SAP ECC6 or SAP S/4HANA, including ABAP data extraction approaches and table structures.
• Proficiency in MS SQL Server including T-SQL development, stored procedures, views, functions and triggers.
• Experience with data lakehouse formats (Delta Lake, Apache Iceberg, Apache Hudi, DuckLake) and related catalogs.
• Knowledge of dimensional modelling (star/snowflake), SCD, staging/ODS patterns and pipeline architecture.
• Hands-on SSIS and data orchestration (ADF) for ETL; strong data quality and governance focus.
• Structured documentation, data lineage, and data dictionary maintenance.

Responsibilities

• Lead end-to-end data management and platform development across SQL Server, PostgreSQL, and DuckDB.
• Provide design and optimization for data ingestion from SAP ECC6 and other sources, ensuring low latency and reliability.
• Develop and maintain data models, governance policies, and robust ETL pipelines; monitor and troubleshoot data workflows.
• Collaborate with business stakeholders to translate requirements into scalable technical solutions and roadmaps.
• Drive data lakehouse modernization efforts and contribute to cross-functional knowledge sharing and best practices.

Skills

SQL performance tuning

Data modeling

Data governance

RBAC & data masking

Education

Bachelor's degree in Information Technology, Computer Science, Data Analytics, Engineering or related STEM field

Tools

MS SQL Server

PostgreSQL

DuckDB

DuckLake

Snowflake

Databricks

BigQuery

Synapse

SSIS

ADF

PowerShell

Python

Job description

KLK OLEO in Malaysia is seeking a senior Data Engineer to manage MS SQL Server, PostgreSQL and DuckDB, ensuring stable, scalable data solutions for analytics.

You will design data ingestion from SAP ECC6, orchestrate complex data workflows, enforce governance, optimize performance, and collaborate with business stakeholders to deliver a trusted data platform. A strong background in data modeling and lakehouse technologies is required.