Data Engineer

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

THIS POSITION IS TO BE BASED IN MUTIARA DAMANSARA, PETALING JAYA

ROLE AND RESPONSIBILITIES

A. DATA MANAGEMENT & TECHNICAL DEVELOPMENT

Supports the end-to-end management of MS SQL Server, PostgreSQL and DuckDB (DuckLake) database systems, ensuring their stability, scalability and reliability.

Monitor daily job statuses and perform troubleshoot and recovery when necessary.

Develop scalable and low latency end-to-end data pipelines in accordance to best practices.

Write, optimize and troubleshoot T-SQL queries, stored procedures, views, functions and triggers to support data transformation, loading, and validation logic.

Orchestrate and schedule complex data workflows, ensuring timely and reliable data delivery.

Implement and manage monitoring solutions to proactively address and prevent performance issues.

Develop and maintain staging structures and data models (star and snowflake schemas), ensuring data is structured for efficient querying and reliable analytical consumption.

Contribute to data quality validation, reconciliation checks, and exception handling across data pipelines, ensuring completeness, accuracy, and consistency of data.

Document pipeline logic, data lineage, transformation rules, table definitions and data dictionary entries, ensuring technical artefacts are kept current and accessible to the team.

B. OPTIMIZATION & PLATFORM TRANSFORMATION

Basic understanding and assessment of SSIS data pipelines to refactor SQL scripts and migrate them to the new data lakehouse environment.

Participate in discussions and debates on technical and architectural topics that are related to the data warehouse.

Participate in peer reviews and knowledge-sharing sessions, contributes to a culture of continuous improvement and cross-training across both legacy and modern data tooling within the team.

Identify opportunities to optimize data processes, reduce complexities and costs.

Contribute to the establishment of a data governance framework. Support in driving data standards and strategy for maintaining a proper and traceable governance model for all end-to-end data assets.

C. BUSINESS PARTNERSHIP & PROJECT MANAGEMENT

Collaborate with stakeholders to understand business requirements and translate them into technical solutions.

Assess, evaluate and prioritize new and change requests to ensure they are evaluated for strategic fit and feasibility before assigning them to the development pipeline.

Provide clear and timely communication on project status, risks and progress, keeping business stakeholders and ITBS management well-informed throughout the delivery lifecycle.

Job Success Requirements

Minimum of 1 years' experience in business solutioning, data / analytics consulting or a data warehouse delivery role, with a track record of partnering directly with business stakeholders.

Understanding of data warehousing concepts, including dimensional modelling (star & snowflake schemas), slowly changing dimensions (SCD), and staging/ODS design patterns, with the ability to apply these principles to schema design and pipeline architecture decisions.

Proficiency in MS SQL Server, including database design, T-SQL development (stored procedures, views, functions, triggers), query optimisation and performance tuning.

Detail-oriented and methodical, with a structured approach to documentation, data quality validation, and issue escalation, combined with the ability to manage multiple concurrent deliverables and work effectively in a fast-paced, cross-functional team environment.

Language: SQL (mandatory), PowerShell, Python (bonus)

Orchestration: SSIS, ADF

Transformation: SQL, SSIS

Storage: SQL Server, ADLS2

Qualification

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

Additional Notes

Maintains awareness of current developments in data and AI technologies, and able to evaluate their potential application within the organisation.

KLK OLEO is one of the world’s leading oleochemical producers that is committed to delivering excellence in the global marketplace. Our integrated oleochemical complexes located in key sourcing and supply markets (Malaysia, Indonesia, China and Europe) produce a wide range of high quality sustainable oleochemical products from natural renewable raw materials.

KLK OLEO is part of Kuala Lumpur Kepong Berhad (“KLK”), a leading international plantations group listed on the Main Market of Bursa Malaysia Securities Berhad. Strategically integrated to our upstream plantations parent, KLK OLEO is able to extract synergies and focus on developing sustainable solutions and reliable supply for our customers. At KLK OLEO, sustainability is integral to our business. Being a member of the RSPO, we are committed to delivering high quality and safe products to our customers, and ensuring high traceability throughout our supply chain. KLK OLEO’s strong commitment to meet customers’ expectations underscores our solid reputation as a reliable supplier in the global market place.

KLK OLEO's production portfolio ranges from basic oleochemical products, such as fatty acids, glycerine, fatty alcohols and fatty esters, all the way down the spectrum to specialties, such as methyl ester sulphonate (MES), surfactants and phytonutrients. Our products are used in diverse end-use applications, including home & personal health care, cosmetics & toiletries, food, flavours & fragrances, lubricants, polymers and industrial chemicals. Backed by a firm belief in innovation and a strong R&D culture, the creation of new downstream businesses continues to be the cornerstone of our strategy to capitalise on the integrated value chain.

Headquartered in Malaysia, with a workforce of 3,000 people worldwide, KLK OLEO strives to develop and uphold good relationships and long term partnerships with our customers and stakeholders.

KLK OLEO is one of the world’s leading oleochemical producers that is committed to delivering excellence in the global marketplace. Our integrated oleochemical complexes located in key sourcing and supply markets (Malaysia, Indonesia, China and Europe) produce a wide range of high quality sustainable oleochemical products from natural renewable raw materials.

KLK OLEO is part of Kuala Lumpur Kepong Berhad (“KLK”), a leading international plantations group listed on the Main Market of Bursa Malaysia Securities Berhad. Strategically integrated to our upstream plantations parent, KLK OLEO is able to extract synergies and focus on developing sustainable solutions and reliable supply for our customers. At KLK OLEO, sustainability is integral to our business. Being a member of the RSPO, we are committed to delivering high quality and safe products to our customers, and ensuring high traceability throughout our supply chain. KLK OLEO’s strong commitment to meet customers’ expectations underscores our solid reputation as a reliable supplier in the global market place.

KLK OLEO's production portfolio ranges from basic oleochemical products, such as fatty acids, glycerine, fatty alcohols and fatty esters, all the way down the spectrum to specialties, such as methyl ester sulphonate (MES), surfactants and phytonutrients. Our products are used in diverse end-use applications, including home & personal health care, cosmetics & toiletries, food, flavours & fragrances, lubricants, polymers and industrial chemicals. Backed by a firm belief in innovation and a strong R&D culture, the creation of new downstream businesses continues to be the cornerstone of our strategy to capitalise on the integrated value chain.

Headquartered in Malaysia, with a workforce of 3,000 people worldwide, KLK OLEO strives to develop and uphold good relationships and long term partnerships with our customers and stakeholders.