Data Engineer
Summary
PT Asuransi Raksa Pratikara, an established Indonesian insurance company, is hiring a Data Engineer to design and maintain ETL/ELT pipelines, APIs, database schemas, and analytical data models ensuring business-critical data is accurate, secure, and accessible. Core stack includes SQL databases (PostgreSQL, Oracle, MySQL) and BI tools like Power BI or Tableau.
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.
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.
Product & Services
Driven by the customers trust built up over the years, we never stop endeavoring to improve the quality of our services. As a testimony to our commitment to quality service, we implemented 24-hour customer service and free car-towing service within the Jakarta-Bogor-Depok-Tangerang-Bekasi area in 2003. Having gained wide acclaim from customers, the free car-towing service was expanded to the area of Bandung and Surabaya. In 2004, we once again materialized our commitment to the enhancement of customer satisfaction by launching Raksa Gold Club (RGC), which provides dedicated services to motor-car policy holders with sum-insured of and above US$ 70,000. No efforts have been spared to ensure our best services to our customers. In 2005, we created Raksa Emergency Quick Service (REQS) rendering quick assistance to customers encountering emergency on the road, such as flat tires and car engine failure. Following the success of Raksa Gold Club, we achieved another milestone in upgrading our claim service by launching Raksa Silver Club (RSC) which is specifically aimed at pampering customers with motor insurance coverage below US$ 70,000. The advent of RSC brings in a new touch in insurance world which distinguishes Asuransi Raksa Pratikara from other insurers. Under our claim service motto “MUCAK” (Mudah, Cepat, Akrab which is translated as Easy, Fast, Friendly) all customers visiting RSC will enjoy relaxing ambience and affable claim service.
Asuransi Raksa Pratikara was established in 1975 and conducts business operation based on the motto “Prudent and Trusted”. Our service qualities are enshrined in our professional, reliable, experienced and conscientious staff. Armed with the latest innovative insurance knowledge, we are constantly prepared to deliver high quality insurance services to our clientele. Our services comprise 23 offices nation-wide in Indonesia supported by the latest information technology. Communications among branches are performed through on-line network.
PENGUMUMAN :
Asuransi Raksa Pratikara was established in 1975 and conducts business operation based on the motto “Prudent and Trusted”. Our service qualities are enshrined in our professional, reliable, experienced and conscientious staff. Armed with the latest innovative insurance knowledge, we are constantly prepared to deliver high quality insurance services to our clientele. Our services comprise 23 offices nation-wide in Indonesia supported by the latest information technology. Communications among branches are performed through on-line network.
Product & Services
Driven by the customers trust built up over the years, we never stop endeavoring to improve the quality of our services. As a testimony to our commitment to quality service, we implemented 24-hour customer service and free car-towing service within the Jakarta-Bogor-Depok-Tangerang-Bekasi area in 2003. Having gained wide acclaim from customers, the free car-towing service was expanded to the area of Bandung and Surabaya. In 2004, we once again materialized our commitment to the enhancement of customer satisfaction by launching Raksa Gold Club (RGC), which provides dedicated services to motor-car policy holders with sum-insured of and above US$ 70,000. No efforts have been spared to ensure our best services to our customers. In 2005, we created Raksa Emergency Quick Service (REQS) rendering quick assistance to customers encountering emergency on the road, such as flat tires and car engine failure. Following the success of Raksa Gold Club, we achieved another milestone in upgrading our claim service by launching Raksa Silver Club (RSC) which is specifically aimed at pampering customers with motor insurance coverage below US$ 70,000. The advent of RSC brings in a new touch in insurance world which distinguishes Asuransi Raksa Pratikara from other insurers. Under our claim service motto “MUCAK” (Mudah, Cepat, Akrab which is translated as Easy, Fast, Friendly) all customers visiting RSC will enjoy relaxing ambience and affable claim service.