Data Engineer (ETL & PySpark)

Hong Kong Unison Limited; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

Unison Consulting is seeking a skilled Data Engineer to design, develop, and optimize scalable data pipelines and ETL processes in a Singapore-based role. The candidate will work with Python, PySpark, SQL, and cloud data platforms to handle large-scale datasets and ensure data quality and performance.

Responsibilities include building data models and warehouses, optimizing Spark jobs, and collaborating with analysts and business teams. Strong scripting, CI/CD, and cloud experience are preferred.

Qualifications

• Proficient in Python programming with hands-on PySpark experience.
• Strong SQL skills with query optimization and data transformations.
• Experience building ETL/ELT pipelines and data processing solutions.
• Solid understanding of data warehousing concepts and relational databases.
• Knowledge of Linux/Unix environments and shell scripting.
• Experience with Git and CI/CD processes.
• Analytical mindset with strong problem-solving skills.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines using Python and PySpark.
• Develop high-performance data processing solutions for structured and unstructured data.
• Write optimized SQL queries, stored procedures, and data transformations.
• Build and maintain data models, data marts, and data warehouses.
• Perform data cleansing, validation, and quality checks.
• Optimize Spark jobs for performance and scalability.
• Integrate data from APIs, databases, and cloud storage.
• Collaborate with analysts, data scientists, and business teams to deliver data solutions.
• Troubleshoot production issues and perform root cause analysis.
• Ensure data governance, security, and best engineering practices.
• Participate in code reviews and maintain technical documentation.

Skills

Python

PySpark

SQL

ETL/ELT

Data warehousing concepts

Relational databases

Linux/Unix scripting

Git & CI/CD

Analytical & problem solving

Education

Bachelor's or Master's in CS/IT/Engineering

Tools

Airflow

Databricks

Hadoop/Hive ecosystem

Cloud platforms (AWS/Azure/GCP)

Docker & Kubernetes

Job description

We are looking for a skilled Data Engineer with strong expertise in Python, PySpark, and SQL to design, develop, and optimize scalable data pipelines and ETL processes. The ideal candidate should have experience working with large-scale datasets, distributed computing frameworks, and cloud-based data platforms while ensuring data quality, reliability, and performance.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines using Python and PySpark.
• Develop high-performance data processing solutions for structured and unstructured data.
• Write optimized SQL queries, stored procedures, and data transformations.
• Build and maintain data models, data marts, and data warehouses.
• Perform data cleansing, validation, and quality checks.
• Optimize Spark jobs for performance, scalability, and resource utilization.
• Integrate data from multiple sources including APIs, databases, and cloud storage.
• Collaborate with Data Analysts, Data Scientists, and Business teams to deliver data solutions.
• Troubleshoot production issues and perform root cause analysis.
• Ensure data governance, security, and best engineering practices.
• Participate in code reviews and maintain technical documentation.

Required Skills

• Strong experience in Python programming.
• Hands‑on experience with PySpark and Apache Spark.
• Strong SQL skills with query optimization.
• Experience with ETL/ELT pipeline development.
• Good understanding of data warehousing concepts.
• Experience with relational databases (Oracle, SQL Server, PostgreSQL, MySQL, etc.).
• Knowledge of Linux/Unix environment and Shell Scripting.
• Familiarity with Git and CI/CD processes.
• Strong analytical and problem‑solving skills.

Preferred Skills

• Experience with cloud platforms such as AWS, Azure, or GCP.
• Knowledge of Databricks, AWS Glue, or EMR.
• Experience with Airflow or other workflow orchestration tools.
• Understanding of Delta Lake, Hive, or Hadoop ecosystem.
• Exposure to Kafka or other streaming technologies.
• Knowledge of Docker and Kubernetes.
• Experience with Agile/Scrum methodology.

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.

Nice to Have

• Experience with Snowflake or Databricks.
• Cloud certifications (AWS, Azure, or GCP).
• Knowledge of DevOps practices and CI/CD pipelines.
• Python Development
• PySpark
• SQL & Query Optimization
• ETL/ELT Development
• Data Warehousing
• Performance Tuning
• Data Modeling
• Problem Solving
• Communication Skills

Unison Consulting established in the year 2012 in Singapore. We provide technology consulting, systems implementation, and integrations service to Asia Pacific customers. We help transform enterprise data in actionable insights. Our consultants have wide range of functional expertise within Banking and Financial services spectrum, working closely with clients to anticipate, illuminate and overcome complex business challenges.

Our objective is to be a one-stop solution provider all enterprise business intelligence and data warehousing needs of organizations.

Our mission is to consistently deliver our services to our clients in a cost-effective way without compromising the quality.

Our current clients include - DBS, OCBC, Standard Chartered Bank and Maybank.

Unison Consulting established in the year 2012 in Singapore. We provide technology consulting, systems implementation, and integrations service to Asia Pacific customers. We help transform enterprise data in actionable insights. Our consultants have wide range of functional expertise within Banking and Financial services spectrum, working closely with clients to anticipate, illuminate and overcome complex business challenges.

Our objective is to be a one-stop solution provider all enterprise business intelligence and data warehousing needs of organizations.

Our mission is to consistently deliver our services to our clients in a cost-effective way without compromising the quality.

Our current clients include - DBS, OCBC, Standard Chartered Bank and Maybank.