Data Engineer

Kumparan; Jakarta Pusat; On-site; IDR 180,000,000 - 240,000,000; Full time

Job summary

Kumparan is seeking a Data Engineer to design, build, and maintain robust data pipelines and analytics data warehouses. You will work with SQL, Python, and cloud technologies to develop ETL/ELT processes, implement data quality checks, and optimize data flows for analytics across the organization.

The role emphasizes collaboration with analysts, engineers, and business stakeholders to transform raw data into reliable insights using BigQuery, dbt, Airflow, and other modern tools.

Qualifications

• Bachelor's degree or equivalent practical experience in CS/IT/Engineering.
• 1–3 years in Data Engineering, Data Analytics, or related tech role.
• Experience building and optimizing ETL/ELT pipelines.
• Experience with relational databases, data warehouses, and large datasets.
• Understanding data modeling, transformation, and integration concepts.
• Familiarity with batch processing and basic data orchestration workflows.
• Experience integrating data from databases, APIs, and files.
• Knowledge of data quality, validation, and monitoring.
• Familiarity with cloud platforms such as GCP, AWS, or Azure.

Skills

SQL

Python

Data Warehousing

ETL/ELT Development

Workflow Orchestration

Data Transformation

Data Modeling

Cloud Technologies

Version Control

Data Quality

Problem-Solving

Collaboration

Education

Bachelor's degree in CS/IT/Engineering

Tools

PostgreSQL

MySQL

BigQuery

Airflow

Mage.ai

dbt

Git

Job description

• SQL: Strong understanding of SQL queries, joins, aggregations, Common Table Expressions (CTEs), window functions, and query optimization.
• Programming: Proficiency in Python for data processing, automation, and pipeline development.
• Databases: Hands-on experience with relational databases such as PostgreSQL or MySQL.
• Data Warehousing: Familiarity with analytical databases such as Google BigQuery
• ETL/ELT Development: Ability to build and maintain data ingestion, transformation, and loading processes.
• Workflow Orchestration: Familiarity with Apache Airflow, Mage.ai, or similar workflow orchestration tools.
• Data Transformation: Understanding of data transformation frameworks such as dbt or equivalent SQL-based transformation approaches.
• Data Modeling: Knowledge of dimensional modeling, fact and dimension tables, and star schema design.
• Cloud Technologies: Basic knowledge of cloud storage, compute, and managed data services.
• Version Control: Experience using Git for source code management and collaboration.
• Data Quality: Ability to implement basic data validation, logging, and pipeline monitoring.
• Problem-Solving: Strong analytical thinking, debugging skills, and ability to investigate data inconsistencies.
• Collaboration: Ability to communicate technical concepts clearly and work effectively with analysts, engineers, and business stakeholders.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.
• 1–3 years of experience in Data Engineering, Data Analytics, Software Engineering, or a related technical role.
• Experience developing, maintaining, and optimizing ETL/ELT data pipelines.
• Experience working with relational databases, data warehouses, and large datasets.
• Understanding of data modeling, data transformation, and data integration concepts.
• Familiarity with batch processing and basic data orchestration workflows.
• Experience integrating data from multiple sources, including databases, APIs, and files.
• Understanding of data quality, consistency, validation, and monitoring practices.
• Familiarity with cloud-based data platforms such as Google Cloud Platform (GCP), AWS, or Azure.
• Ability to troubleshoot data pipeline issues and collaborate with cross-functional teams.
• Willingness to learn new technologies and follow data engineering best practices.

Company Values:

We don't tell you what to do.

We ask what you have

We seek your potential

We don't say follow our lead.

We listen to what makes your mind tick

We try to understand your interest

We don't walk in front of you.

We walk side by side

We create togetherness

kumparan.com is where the journalists and audience interact, crowdsourcing made possible, and users involvement valued.

kumparan.com is where the journalists and audience interact, crowdsourcing made possible, and users involvement valued.