Data Engineer (SQL)

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

• 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.

Job Description

• 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.

Minimum 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.

Bumi Amartha Teknologi Mandiri or “AMARTEK” was established to provide information technology solutions. Our mission from the very first day has been to cultivate professional relationships with our clients to provide effective and reliable information technology solutions for their needs. The team at "AMARTEK" is equipped with a highly developed skillset developed over decades of experience not only in information technology but also in business processes across a range of industry sectors. This business experience makes us uniquely positioned to offer solutions promising greater operational efficiency, productivity gains and cost savings for each of our clients, regardless of their industry.

As an established technology-intensive company, we pride ourselves on providing a comprehensive suite of solutions comprising of Infrastructure Consultancy, on/offsite services, Custom software and web development, Talent Augmentation, and enterprise architecture consulting. Our team consistently delivers state-of-the-art solutions in various areas including, but not limited to: integrated business solutions, system applications, product development and professional services.

At "AMARTEK", we guarantee rapid, reliable and robust information technology solutions that work.

Bumi Amartha Teknologi Mandiri or “AMARTEK” was established to provide information technology solutions. Our mission from the very first day has been to cultivate professional relationships with our clients to provide effective and reliable information technology solutions for their needs. The team at "AMARTEK" is equipped with a highly developed skillset developed over decades of experience not only in information technology but also in business processes across a range of industry sectors. This business experience makes us uniquely positioned to offer solutions promising greater operational efficiency, productivity gains and cost savings for each of our clients, regardless of their industry.

As an established technology-intensive company, we pride ourselves on providing a comprehensive suite of solutions comprising of Infrastructure Consultancy, on/offsite services, Custom software and web development, Talent Augmentation, and enterprise architecture consulting. Our team consistently delivers state-of-the-art solutions in various areas including, but not limited to: integrated business solutions, system applications, product development and professional services.

At "AMARTEK", we guarantee rapid, reliable and robust information technology solutions that work.