Data Engineer - SQL & ETL Pipelines

PT Bumi Amartha Teknologi Mandiri; Kemayoran; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

PT Bumi Amartha Teknologi Mandiri (AMARTEK) seeks a Data Engineer to design, develop, and maintain data pipelines that support business reporting and analytics. You will write, optimize, and maintain complex SQL queries and perform data integration across sources.

You will ensure data accuracy and reliability, monitor pipeline and database performance, and document data processes. Requires a Bachelor's degree in a related field and 2–3 years' experience in data engineering; experience with

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Information Systems, or a related field.
• Minimum 2–3 years of experience as a Data Engineer or in a similar role.
• Strong proficiency in SQL, including complex queries, joins, subqueries, CTEs, and query optimization.
• Good understanding of database concepts, data modeling, and relational databases.
• Experience in developing and maintaining ETL/ELT processes and data pipelines.
• Familiarity with databases such as PostgreSQL, MySQL, SQL Server, or Oracle.
• Strong analytical, problem-solving, and troubleshooting skills.
• Able to work independently and collaboratively within a team.

Responsibilities

• Design, develop, and maintain data pipelines to support business and reporting requirements.
• Write, optimize, and maintain complex SQL queries for data extraction, transformation, and analysis.
• Perform data integration and transformation from multiple data sources.
• Ensure data accuracy, consistency, quality, and reliability.
• Monitor and troubleshoot data pipeline and database performance issues.
• Collaborate with business analysts, developers, and other stakeholders to understand data requirements.
• Maintain technical documentation related to data processes and database structures.

Skills

SQL proficiency

Data modeling

ETL/ELT pipelines

Analytical troubleshooting

Team collaboration

Independent work

Education

Bachelor's degree in CS/IT/IS

Tools

PostgreSQL

MySQL

SQL Server

Oracle

Job description

PT Bumi Amartha Teknologi Mandiri (AMARTEK) seeks a Data Engineer to design, develop, and maintain data pipelines that support business reporting and analytics. You will write, optimize, and maintain complex SQL queries and perform data integration across sources.

You will ensure data accuracy and reliability, monitor pipeline and database performance, and document data processes. Requires a Bachelor's degree in a related field and 2–3 years' experience in data engineering; experience with