Data Platform Engineer: ETL & Analytics Pipelines

Optimum Solutions Pte Ltd; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

Optimum Solutions Pte Ltd in Singapore is seeking a hands-on Data Engineer to support a central data platform, collaborating with technical teams, data owners, and business users to deliver reliable pipelines and high‑quality datasets for reporting.

You will develop ETL/ELT pipelines, implement data quality checks, optimize performance, and provide documentation while translating business requirements into scalable data solutions.

Qualifications

• 3-4 years of data engineering experience with strong SQL and Python for data processing and pipelines.
• Hands-on ETL/ELT development including ingestion, transformation, validation and production support.
• Solid understanding of data modelling, data warehousing and relational/file-based data.
• Experience handling complex/legacy data, data reconciliation and root-cause analysis.
• AWS experience (S3/Athena/IAM) and cloud data platforms are a plus.
• Familiarity with Spark/Databricks and BI tools is advantageous.

Responsibilities

• Develop and maintain ETL/ELT pipelines and interfaces for data ingestion.
• Build SQL and Python solutions for data cleansing, transformation, standardisation and reconciliation.
• Maintain data models, datasets and processing logic to support new requirements.
• Implement data quality checks, investigate anomalies and resolve root causes.
• Monitor pipelines, rerun jobs and improve reliability and performance.
• Support testing, UAT, defect resolution and production issues.
• Develop governed datasets and data sources for downstream reporting and analytics.
• Translate business requirements into data mappings with clear documentation.
• Support data governance, audit, access review and compliance activities.

Skills

SQL

Python

ETL/ELT pipelines

Data cleansing

Data modelling

Data warehousing

Troubleshooting

Stakeholder management

Problem solving

Tools

Databricks

Spark

Tableau

AWS

S3

Athena

Job description

Optimum Solutions Pte Ltd in Singapore is seeking a hands-on Data Engineer to support a central data platform, collaborating with technical teams, data owners, and business users to deliver reliable pipelines and high‑quality datasets for reporting.

You will develop ETL/ELT pipelines, implement data quality checks, optimize performance, and provide documentation while translating business requirements into scalable data solutions.