Azure Data Engineer (ADF, Synapse, SQL/Python)

EPAM Systems; Malaysia; On-site; MYR 120,000 - 180,000; Full time

Job summary

EPAM Systems in Malaysia is seeking an Azure Data Engineer to build scalable data ingestion and transformation pipelines using Azure Data Factory and Azure Synapse. You will leverage SQL and Python to transform complex datasets, design analytics-ready data models, and orchestrate automated workflows.

You will partner with business teams to deliver high-quality reporting solutions and mentor junior engineers while applying best practices across development, testing and deployment.

Qualifications

• Experience building ETL/ELT solutions including ingestion and transformation.
• Proficient in SQL for transformation, validation and performance tuning.
• Experience with Azure Data Factory and Azure Synapse for data integration.
• Proficient in Python for data processing and automation.
• Knowledge of dimensional modeling and Lakehouse concepts.
• Ability to communicate clearly in English (written and spoken).

Responsibilities

• Develop, maintain and support ETL/ELT pipelines.
• Build and optimize data ingestion and transformation pipelines with Azure services.
• Design data models to support analytics and reporting use cases.
• Transform, validate and analyze large datasets using SQL and Python.
• Orchestrate workflows and monitor pipelines for reliability.
• Create technical documentation and mentor junior engineers.

Skills

Azure Data Factory

Azure Synapse

ETL/ELT pipelines

SQL

Python

Data modeling (dimensional, Lakehouse)

Cloud platform: Microsoft Azure

English communication (written &spoken

Tools

Databricks

Power BI

Apache Airflow

Job description

We are seeking an Azure Data Engineer to build and optimize scalable data ingestion and transformation pipelines using Azure Data Factory and Azure Synapse . You will leverage SQL and Python to transform complex datasets, design analytics-ready data models, and orchestrate automated workflows. You will partner with business teams to deliver high-quality, trusted reporting solutions.

Responsibilities

• Develop, maintain and support ETL/ELT solutions
• Build and optimize data ingestion and transformation pipelines using Azure Data Factory and Azure Synapse
• Design and implement data models to support analytics and reporting use cases
• Use SQL and Python to transform, validate and analyze large datasets
• Orchestrate workflows, scheduling and monitoring to ensure reliable pipeline execution
• Apply best practices across development, testing and deployment
• Create and maintain technical documentation
• Mentor junior engineers and contribute to team knowledge sharing

Requirements

• Azure Data Factory expertise for building, scheduling and monitoring pipelines
• Azure Synapse experience for data integration and analytics workloads
• ETL/ELT Solutions background including ingestion, transformation and incremental processing
• SQL proficiency for data transformation, validation and performance tuning
• Python capability for data processing and automation
• Data modeling knowledge including dimensional modeling and Lakehouse concepts
• Cloud platform familiarity, especially Microsoft Azure
• Clear communication in English, written and spoken

Nice to have

• Experience with Databricks for Data Analytics
• Experience with Microsoft Power BI
• Experience with Apache Airflow