Job Description

To design, develop, and optimization of enterprise-level

data warehousing

solutions. Design and implement robust

ETL processes

using industry-standard tools and frameworks. Develop and maintain conceptual, logical, and physical

data models

to support business analytics. Collaborate with stakeholders and

BA

to gather

business requirements (BRS)

and translate them into detailed

SRS

and

SDS

documentation. Ensure data accuracy, integrity, consistency, and availability across platforms and applications. Provide technical leadership in data architecture and modelling best practices. Work with

business analysts

and

data consumers

to define and deliver actionable insights and reporting. Drive performance tuning, capacity planning, and scalability enhancements for data warehousing infrastructure. Utilize

Pentaho

for data integration workflows, and

Vertica

for high-performance analytical processing is advantage. Mentor junior team members and provide technical guidance.

Required Skills and Qualifications:

3-5+ years of experience in

data warehousing

,

ETL development

, and

data analytics

. Strong experience in

data modelling

(star schema, snowflake, normalization/denormalization). Proficient in writing complex

SQL

queries and performance tuning. Proven experience with

ETL tools

(Pentaho Data Integration is a plus). Strong knowledge of

data warehouse architectures

and methodologies. Experience with

columnar databases

like

Vertica

is a strong advantage. Familiarity with SDLC processes, including active participation in

BRS

,

SRS

, and

SDS

documentation. Solid understanding of

data governance

,

data quality

, and

metadata management

. Excellent communication, problem-solving, and documentation skills.
Job Types: Full-time, Contract
Contract length: 12 months

Pay: RM7,000.00 - RM12,000.00 per month

Benefits:

Health insurance Maternity leave Opportunities for promotion Professional development
Ability to commute/relocate:

Kuala Lumpur: Reliably commute or planning to relocate before starting work (Required)
Application Question(s):

How many years of experience do you have as a Data Warehouse Engineer? How many years of experience do you have in Data Analytics? How long your notice period? Are you able to start immediately? How many years of experience do you have in Data Modelling?
Education:

Bachelor's (Required)
Experience:

ETL tools: 3 years (Required) Software Development Life Cycle (SLDC): 3 years (Required)
Language:

Malay (Required)
Work Location: In person