Senior Data Engineer

Alliance Bank Malaysia Berhad; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Job summary

Alliance Bank Malaysia Berhad is seeking a data engineer to design, build, and maintain scalable ETL/ELT pipelines for batch and real-time data processing. You will integrate data from multiple internal and external sources to support analytics and reporting.

You will develop data models, ensure data quality, automate workflows with Airflow, and collaborate with analysts, data scientists, and stakeholders across cloud platforms (AWS/Azure/GCP).

Qualifications

• Bachelor's degree in CS/Engineering/IS or related field.
• Experience with real-time data streaming and processing.
• Familiarity with Docker and Kubernetes.
• Knowledge of data modeling techniques (dimensional, star schema).
• Experience with CI/CD pipelines for data workflows.
• Understanding of machine learning workflows and data preparation.
• Strong programming skills in Python, Java, or Scala.
• Experience with SQL and NoSQL databases.
• Hands-on experience with data pipeline tools (Airflow, Talend, Informatica).
• Familiarity with Hadoop, Spark, Kafka.
• Experience with cloud platforms such as AWS, Azure, or Google Cloud.
• Understanding of data warehousing concepts (Snowflake, Redshift, BigQuery).
• Knowledge of version control systems (Git).

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines for batch and real-time data processing.
• Integrate data from multiple sources (databases, APIs, streaming platforms, third-party systems).
• Ensure efficient data ingestion, transformation, and loading processes.
• Develop and maintain data models (dimensional models, star/snowflake schemas).
• Transform raw data into analytics-ready datasets.
• Optimize data structures for performance, scalability, and usability.
• Implement data validation, cleansing, and enrichment processes.
• Establish data quality frameworks, including rules, checks, and monitoring.
• Troubleshoot data inconsistencies and failures; ensure high availability.
• Work with cloud data platforms (Azure, AWS, GCP) and data services (Synapse, BigQuery, Redshift).
• Monitor pipeline performance and improve throughput and latency.
• Collaborate with analysts, data scientists, architects, and stakeholders.
• Provide clean datasets for reporting, dashboards, and ML use cases.
• Support self-service analytics with easy data access and documentation.
• Automate data workflows using orchestration tools (Airflow, Azure Data Factory).
• Apply version control and infrastructure-as-code practices.
• Promote reusable components and standardized frameworks.
• Set up monitoring, alerting, and logging.

Skills

Python

Java

Scala

SQL

NoSQL

Real-time data streaming

Data modeling

Data warehousing

Education

Bachelor's degree in Computer Science, Engineering, Information Systems, or related field

Tools

Docker

Kubernetes

Apache Airflow

Talend

Informatica

Hadoop

Spark

Kafka

AWS

Azure

Google Cloud

Snowflake

Redshift

BigQuery

CI/CD

Git

Job description

• Design, build, and maintain scalable, reusable ETL/ELT pipelines for batch and real-time data processing
• Integrate data from multiple internal and external sources (databases, APIs, streaming platforms, third-party systems)
• Ensure efficient data ingestion, transformation, and loading processes

2. Data Modeling & Transformation

• Develop and maintain logical and physical data models (e.g., dimensional models, star/snowflake schemas)
• Transform raw data into structured, analytics-ready datasets
• Optimize data structures for performance, scalability, and usability

3. Data Quality & Reliability

• Implement data validation, cleansing, and enrichment processes
• Establish data quality frameworks, including rules, checks, and monitoring
• Troubleshoot and resolve data inconsistencies, anomalies, and failures
• Ensure high availability and reliability of data pipelines
• Work with cloud data platforms (e.g., Azure, AWS, GCP) and data services (e.g., Synapse, BigQuery, Redshift)
• Optimize storage, query performance, and compute efficiency
• Monitor pipeline performance and continuously improve throughput and latency
• Collaborate with data analysts, data scientists, architects, and business stakeholders to understand data requirements
• Provide clean, well-structured datasets for reporting, dashboards, and machine learning use cases
• Support self-service analytics by enabling easy data access and documentation

6.Data Governance & Security

• Implement and adhere to data governance policies, standards, and best practices
• Ensure compliance with data privacy, security, and regulatory requirements
• Manage data access controls, lineage, and auditability

7. Automation & DevOps Practices

• Automate data workflows using orchestration tools (e.g., Airflow, Azure Data Factory)
• Apply version control and infrastructure-as-code practices
• Promote reusable components and standardized frameworks
• Set up monitoring, alerting, and logging frameworks for pipelines and datasets
• Track data lineage, pipeline health, and system performance
• Proactively identify and resolve production issues

9. Documentation & Knowledge Sharing

• Maintain clear documentation for data pipelines, data models, and architecture
• Define data definitions, metadata, and data catalogs
• Share knowledge and best practices across teams
• Stay current with emerging data engineering tools, technologies, and patterns
• Recommend and implement improvements in architecture, performance, and cost efficiency
• Contribute to evolving enterprise data strategy and standards

Requirement

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field
• Experience with real-time data streaming and processing
• Familiarity with containerization tools such as Docker and Kubernetes
• Knowledge of data modeling techniques (dimensional, star schema)
• Experience with CI/CD pipelines for data workflows
• Understanding of machine learning workflows and data preparation
• Strong programming skills in Python, Java, or Scala
• Experience with SQL and NoSQL databases
• Hands-on experience with data pipeline tools (e.g., Apache Airflow, Talend, Informatica)
• Familiarity with big data technologies (e.g., Hadoop, Spark, Kafka)
• Experience with cloud platforms such as AWS, Azure, or Google Cloud
• Understanding of data warehousing concepts (e.g., Snowflake, Redshift, BigQuery)
• Knowledge of version control systems (e.g., Git)