Data Warehouse Engineer - ETL & Analytics Leader

Reliable Business Technologies; Kuala Lumpur; On-site; MYR 80,000 - 100,000; Full time

Job summary

A leading technology firm in Malaysia is seeking an experienced specialist in data warehousing and ETL development. The successful candidate will design, develop, and optimize enterprise-level solutions, ensuring data integrity and providing technical leadership. Responsibilities include developing data models, collaborating with stakeholders, and mentoring junior team members. The ideal candidate will have at least 3 years of relevant experience, proficient SQL skills, and knowledge of ETL tools like Pentaho. Malaysians with good command of Malay preferred.

Qualifications

• 3 years of experience in data warehousing, ETL development, and data analytics.
• Strong experience in data modeling (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.
• MALAYSIANS with good speaking knowledge of Malay will be preferred.

Responsibilities

• Design, develop, and optimize enterprise-level data warehousing solutions.
• Implement robust ETL processes using industry-standard tools.
• Develop and maintain data models for business analytics.
• Collaborate with stakeholders to gather business requirements.
• Ensure data accuracy, integrity, consistency across platforms.
• Provide technical leadership in data architecture best practices.
• Work with analysts to define actionable insights and reporting.
• Drive performance tuning and scalability for data warehousing.

Skills

Data warehousing

ETL development

Data analytics

Data modeling

SQL

ETL tools (Pentaho)

Data governance

Communication skills

Problem-solving skills

Tools

Pentaho

Vertica

Job description

A leading technology firm in Malaysia is seeking an experienced specialist in data warehousing and ETL development. The successful candidate will design, develop, and optimize enterprise-level solutions, ensuring data integrity and providing technical leadership. Responsibilities include developing data models, collaborating with stakeholders, and mentoring junior team members. The ideal candidate will have at least 3 years of relevant experience, proficient SQL skills, and knowledge of ETL tools like Pentaho. Malaysians with good command of Malay preferred.