Data Engineer

Are you someone who enjoys solving complex data problems and building reliable, scalable data systems?

PT Asuransi Raksa Pratikara is looking for a Data Engineer to help strengthen our growing digital and data ecosystem. You’ll work hands-on with databases, data pipelines, APIs, system integrations, and analytical data models to ensure business-critical data is accurate, secure, accessible, and ready to use.

You’ll collaborate with Software Developers, System Administrators, Data Analysts, and business teams to improve data quality, automate data processing, optimize database performance, and build scalable data solutions.

If you enjoy turning complex data environments into reliable and automated solutions, this role is for you.

What You’ll Do

• Design, develop, and maintain ETL/ELT pipelines and data integrations across applications, databases, and data sources.

• Develop and maintain APIs and integrations for secure and efficient 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 database 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 using tools such as Power BI, Tableau, Metabase, or Apache Superset.

• Maintain documentation for data models, pipelines, APIs, integrations, and data architecture.

• Continuously evaluate technologies and engineering practices to improve scalability, reliability, security, and performance.

What We’re Looking For

1. Bachelor’s degree in Computer Science, Information Technology, Information Systems, Data Science, or a related field.

2. Minimum 1–2 years of experience in Data Engineering, Database Engineering, Backend Engineering, or a similar role.

3. Strong knowledge of relational databases such as PostgreSQL, Oracle Database, and/or MySQL.

4. Strong SQL skills, including joins, CTEs, subqueries, window functions, indexing, transactions, and query optimization.

5. Good understanding of data modeling, database design, normalization, and relational database architecture.

6. Experience or understanding of ETL/ELT, data pipelines, data transformation, APIs, and system integration.

7. Proficiency in at least one programming or scripting language such as Python, JavaScript/Node.js, or Bash.

8. Good understanding of data security, access control, integrity, and governance principles.

9. Familiarity with cloud databases, data migration, replication, high availability, NoSQL, or modern data platforms is a plus.

10. Experience with BI and visualization tools such as Power BI, Tableau, Metabase, or Apache Superset is a plus.

11. Strong analytical, problem-solving, communication, and collaboration skills.

12. Proactive, detail-oriented, and comfortable working in an environment where data reliability, accuracy, and scalability are critical.