Data Engineer

Pt Lentera Bangsa Benderang; Daerah Khusus Ibukota Jakarta; On-site; IDR 417.710.000 - 584.796.000; Full time

Job summary

A leading data solutions company in South Jakarta is seeking an experienced Data Engineer to build and maintain ETL pipelines for their data-driven operations. The ideal candidate will have at least 3 years of experience in SQL and ETL tools like Talend or SSIS, and a Bachelor's degree. Responsibilities include optimizing data flow across platforms and collaborating with various teams. This role is office-based, with a 6-month contract and potential for extension.

Qualifications

• 3+ years of work experience, preferably specialized in Data.
• Hands-on experience with SQL and ETL tools.

Responsibilities

• Build and maintain reliable ETL pipelines for data-driven operations.
• Manage and optimize data flow across multiple platforms.
• Develop scalable solutions for real-time and batch data processing.
• Collaborate with teams to deliver high-quality data.
• Design and maintain data models and documentation.
• Implement data quality checks and monitor pipeline performance.

Skills

SQL

ETL - SSIS / Talend / Kettle / Pentaho

Debezium

Kafka

Flink

Spark

PostgreSQL

Oracle Database

NoSQL

MongoDB

Python

Education

Bachelor's degree (S1)

Job description

Responsibilities

Build and maintain reliable ETL pipelines to support data-driven operations and projects. Manage and optimize data flow across multiple platforms (PostgreSQL, Oracle, MongoDB, etc.). Develop scalable solutions for real-time and batch data processing using tools like Kafka, Flink, or Spark. Collaborate closely with data analysts, scientists, and business teams to deliver accessible, high-quality data. Design and maintain data models, schemas, and documentation for analytics and reporting. Integrate new data sources and APIs (REST-based) to enhance system capabilities. Implement data quality checks, monitor pipeline performance, and troubleshoot issues proactively. Support event-based streaming and CDC processes using tools such as Debezium or equivalent. Explore and adopt new technologies to improve data workflows and performance.

Required Skills and Experience

Minimum education is a bachelor's degree (S1) 3+ years of work experience (specialized in Data is preferred). At least 3 years of hands-on experience with SQL. Proven skills in ETL - SSIS / Talend / Kettle / Pentaho, Debezium, Kafka, Flink, Spark, PostgreSQL, Oracle Database, SQL, NoSQL, GSQL, TG, Python, MongoDB. Knowledge of ETL, CDC, Event-Based Streaming, GraphDB, REST API, Python, Basic Programming. Eager and willing to learn new technologies.

Preferred Qualifications (if any)

Experience in the insurance industry is a plus.

Work Arrangement

Placement: South Jakarta. Work setup: Work from Office (WFO). Contract duration: 6 months with possibility of extension.

Notes

Start date: Available ASAP (1 month notice period is acceptable). Join date preference: the sooner, the better.