Enterprise Data Warehouse (EDW) Specialist

Hong Leong Bank; Selangor; On-site; MYR 40,000 - 80,000; Full time

Job summary

An established industry player is seeking an Enterprise Data Warehouse Specialist to enhance their data architecture and optimize database performance. This role involves collaborating with various teams to develop and implement data lake strategies while ensuring best practices in data management. The ideal candidate will have a strong background in data warehouse architecture and SQL, with hands-on experience in ETL methodologies. Join a dynamic team where your contributions will drive significant improvements in data processing and reporting. If you are passionate about data and eager to make an impact, this opportunity is perfect for you.

Qualifications

• 3 to 5 years of experience in data warehouse architecture.
• Strong SQL knowledge and hands-on experience.

Responsibilities

• Manage database performance and optimize architecture.
• Develop and implement solutions for data lake projects.

Skills

Data warehouse architecture

SQL

ETL methodology

Big Data (Hive/Spark)

Information management best practices

Education

Bachelor’s degree

Job description

Enterprise Data Warehouse (EDW) Specialist

Add expected salary to your profile for insights

The EDW Specialist will work closely with users, the ETL (Extract, Transform, and Load) team, and data modellers to advise on and ensure the optimization of the database architecture, Logical Data Model (LDM), and Product Data Management (PDM) design best practices. He/she will also develop and deliver the Data Lake strategy and roadmap, architecture, guiding principles, and best practices. Other key responsibilities are as detailed below:

Key responsibilities

1. Database management and performance tuning
2. Analyze and perform query fine-tuning
3. Monitor and report on system utilization and node performance

Data Lake Solution

1. Ensure data optimization and process improvement
2. Develop and ensure timely delivery (e.g., statutory reporting, real-time & batch campaigns)
3. Design, develop, test, and implement technical solutions for projects and daily service requests

Research & Analysis

1. Perform research on projects, change requests, solution efficiency, and problem resolution
2. Support future applications and services by HLB Data Lake solution

Project Management & Production Support

1. Monitor technical tasks and ensure deliverables are met within the project timeline
2. Work with Business PM & IT PM, and business users to define & support business UAT
3. Responsible for production support and outage resolution within expected service levels

Other responsibilities

• R&D activities on new technologies

Jobholder Requirements:

Education/Qualification

• Bachelor’s degree from an accredited university or college

Experience & Skillsets

• Possess 3 to 5 years of similar experience in:
• Data warehouse architecture with toolset capabilities
• Practicing information management best practices
• SQL knowledge and hands-on experience (with strong usage)
• Extract, Transform, and Load (ETL) methodology
• Handling user requirements with at least 2 implementation projects
• Working knowledge of Big Data (Hive/Spark)

What’s next?

• After applying online, our team will review your application. Due to high volume, we appreciate your patience during the process.
• If shortlisted, you will receive an email invitation for an interview. You can also check your application status by logging into your candidate account.