Data Engineer: Build Scalable Pipelines & APIs

PT Asuransi Raksa Pratikara; Jakarta Pusat; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

PT Asuransi Raksa Pratikara seeks a Data Engineer to design, build, and maintain data pipelines and integrations ensuring accurate, secure, and accessible business-critical data. You will work with software developers, data analysts, and business teams to improve data quality and automate processing.

You’ll implement scalable data solutions, optimize databases, and contribute to analytical data models and dashboards using BI tools such as Power BI, Tableau, Metabase, or Apache Superset.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Information Systems, Data Science, or related field.
• 1–2 years of experience in Data Engineering, Database Engineering, Backend Engineering, or similar role.
• Strong knowledge of PostgreSQL, Oracle, and/or MySQL.
• Strong SQL skills including joins, CTEs, subqueries, window functions, indexing, transactions, and optimization.
• Good understanding of data modeling, database design, normalization, and relational database architecture.
• Experience with ETL/ELT, data pipelines, data transformation, APIs, and system integration.
• Familiarity with BI and visualization tools such as Power BI, Tableau, Metabase, or Apache Superset is a plus.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines and data integrations across applications, databases, and data sources.
• Develop and maintain APIs and integrations for secure data exchange between systems.
• Design and maintain database schemas, data models, tables, relationships, and analytical data structures.
• Write and optimize complex SQL queries, indexes, execution plans, and db structures.
• Ensure data quality, integrity, consistency, and availability across systems.
• Automate data validation, transformation, synchronization, and repetitive data-processing tasks.
• Monitor and troubleshoot data pipelines, scheduled jobs, integrations, database performance, and data discrepancies.
• Support data migration, replication, synchronization, and transformation across database platforms.
• Review database designs, queries, and data-related changes before production deployment.
• Collaborate with business users and analysts to build analytical data models, reporting tables, and dashboards.

Skills

SQL

Data Modeling

ETL/ELT

APIs & Integrations

Relational Databases

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

Tableau

Metabase

Apache Superset

Job description

PT Asuransi Raksa Pratikara seeks a Data Engineer to design, build, and maintain data pipelines and integrations ensuring accurate, secure, and accessible business-critical data. You will work with software developers, data analysts, and business teams to improve data quality and automate processing.

You’ll implement scalable data solutions, optimize databases, and contribute to analytical data models and dashboards using BI tools such as Power BI, Tableau, Metabase, or Apache Superset.