Associate Data Engineer - BI Dashboards & SQL Automation

EDTS; Jakarta Pusat; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

EDTS is seeking a Data Engineer to build and optimize SQL queries for ad-hoc BI needs and to automate data pipelines. You will design interactive dashboards and reports, monitor data quality, and collaborate across teams to ensure accurate analytics.

The role emphasizes hands-on SQL, Python scripting, and cloud-aware data warehousing. Ideal candidates have a Bachelor's degree in a related field, at least 1 year of experience in data engineering, and familiarity with BI tools such as Looker or

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• Min. 1 year experience as Data Engineer.
• Proficiency in Python for data manipulation, automation, and pipeline development.
• Solid understanding of SQL and relational databases (PostgreSQL, MySQL, SQL Server).
• Familiarity with ETL concepts and data warehousing; basic cloud knowledge (GCP or AWS).

Responsibilities

• Create SQL queries to deliver ad-hoc BI requirements and optimize data systems.
• Write and optimize SQL queries to access and manipulate large datasets.
• Create BI mechanisms (interactive reports, dashboards, alerts, scheduled emails) using available BI tools like Looker/Power BI.
• Monitor data quality and troubleshoot data issues; ensure data accuracy and integrity.

Skills

Python

SQL

ETL concepts

Data visualization

Cloud services

Education

Bachelor’s degree in CS/IS/Engineering

Tools

PostgreSQL

MySQL

SQL Server

Job description

EDTS is seeking a Data Engineer to build and optimize SQL queries for ad-hoc BI needs and to automate data pipelines. You will design interactive dashboards and reports, monitor data quality, and collaborate across teams to ensure accurate analytics.

The role emphasizes hands-on SQL, Python scripting, and cloud-aware data warehousing. Ideal candidates have a Bachelor's degree in a related field, at least 1 year of experience in data engineering, and familiarity with BI tools such as Looker or