Data Engineer and Analyst

Hong Leong Bank Berhad; Selangor; On-site; MYR 120,000 - 180,000; Full time

Job summary

Hong Leong Bank Berhad is seeking a Data Engineer and Analyst to design, code, and implement ETL processes for the data lake, translating business needs into scalable data solutions.

The role requires strong SQL, data quality focus, and experience with large-scale data projects in a financial services setting. You will work with Informatica, SSIS, and modern streaming/batch frameworks in a collaborative environment.

Qualifications

• 4–6 years of experience in Data Engineering ETL, SQL and Big Data, preferably within Financial Services.
• 1–2 years in leadership or supervisory capacity.
• Proven track record delivering complex, large-scale data projects.

Responsibilities

• Consults with users and stakeholders on issues and recommends advanced data solutions.
• End-to-end design, development, testing and implementation of ETL processes.
• Maintains data lake/warehouse quality and performance across environments.
• Leads post-implementation reviews and ensures continued system effectiveness.
• Works with real-time and batch data ingestion frameworks (Kafka/Flink/Hudi/Hive/ClickHouse).

Skills

SQL

Data Quality

ETL Development

Python

Linux

Agile

Tools

Informatica ETL

SSIS

Kafka

Flink

Hudi

Hive

ClickHouse

Jupyter Notebook

Job description

If you are looking to excel and make a difference, take a closer look at us…

Overview

The Data Engineer and Analyst is responsible for designing, coding, and implementing new business application sources to be extracted, transformed and loaded to the data lake. The Data Engineer and Analyst must have good listening skills to be able to understand business needs and interpret those needs into an efficient and effective application design.

Responsibilities

• Consults with users, clients and other technology groups on issues and recommends advanced programming solutions.
• Accountable for all phases of development process, analysis, design, construction, testing and implementation.
• Provides user and operational support on applications to business users.
• Solves / works complex problems / projects through in-depth evaluation of business processes, system processes and industry standards; performs root cause analyses.
• Engages in post implementation analysis of business usage to ensure successful system design and functionality.
• Provides sound understanding of Big Data apps development concepts and principles and knowledge of concepts and principles in other technology areas.
• Provides evaluative judgment based on analysis of factual information in complicated and unique situations.
• Directly impacts the business by ensuring the quality of work provided by self and others.
• Impacts own team and closely related work teams. Exhibits sound and comprehensive communication and diplomacy skills to exchange complex information
• Strong leadership, interpersonal, influence, negotiation, and written and verbal communication skills required.
• Utilize ad-hoc techniques to perform on-the-fly analysis of data

Managerial (team/group Responsibilities)

• Support the division & department deliverables

Organizational (organizational responsibilities)

• Work closely with Department & Section Head to set department direction and AAM according to division and corporate vision
• Work closely with all levels of staff to achieve corporate goals and objectives

Skills And Experience We Are Looking For

• Writes advanced SQL including some query tuning
• Experience in the identification of data quality
• Experience working with Stored Procedures
• Some database design experience is helpful
• Implementing data Compression techniques for space saving
• Experience designing and building complete ETL processes moving and transforming data for ODS, Staging, and Data Warehousing
• Experience with Informatica ETL tool
• Proficient in how to deploy to and debug a production Data Lake environment
• Experience with real time and batch data ingestion frameworks using (Kafka/Flink/Hudi/Hive/Clickhouse)
• Informatica/Shell Scripting / SSIS Packages/ SQL experience
• Experience with Python, Anaconda and Jupiter Notebook skillset is highly desirable
• Hands on Experience with open-source software platforms Linux
• Agile development processes experiences a plus
• Hands on experience in building SSIS packages
• Minimum of 4-6 years of experience in Data Engineering ETL, SQL and Big data preferably within the Financial Services industry.
• At least 1-2 years in a leadership or supervisory capacity.
• Proven track record of delivering complex, large-scale data projects (e.g., system migrations, regulatory reporting).

About Hong Leong Bank

We are a leading financial institution in Malaysia backed by a century of entrepreneurial heritage. Providing comprehensive financial services guided by a Digital-at-the-Core ethos has earned us industry recognition and accolades for our innovative approach in making banking simpler and more effortless for our customers. Our digital and physical offerings span across a vast nationwide network in Malaysia, strengthened with an expanding regional presence in Singapore, Hong Kong, Vietnam, Cambodia, and China.

We seek to strike a balance between diversity, inclusion and merit to achieve our mission of infusing diversity in thinking and skillsets into our organisation. Candidates are assessed based on merit and potential, in line with our mission to attract and recruit the best talent available. Expanding on our “Digital at the Core” ethos, we are progressively digitising the employee journey and experience to provide a strong foundation for our people to drive life‑long learning, achieve their career aspirations and grow talent from within our organisation.