BI Data Engineer - ETL Pipelines & Data Warehouse

Cermati.com; Daerah Khusus Ibukota Jakarta; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading data analytics company in Jakarta is seeking a highly technical Business Intelligence Engineer to design and maintain data infrastructure for analytics. Responsibilities include developing scalable ETL pipelines, building data models, and optimizing warehouse performance. Candidates should hold a relevant degree and possess strong SQL and Python coding skills. This role involves collaboration with BI Analysts, ensuring data integrity, and implementing data quality processes. The company offers competitive benefits and a dynamic work environment.

Qualifications

• Experience with data modeling and data warehouse design principles.
• Strong analytical and problem-solving skills are required.
• Excellent verbal and written communication skills.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines.
• Develop robust data models within data warehouse.
• Write and optimize SQL and Python scripts for data processing.
• Collaborate with BI Analysts to understand data requirements.
• Monitor and optimize data pipeline performance.
• Implement data quality checks and governance processes.

Skills

Expert-level SQL skills

Data modeling principles

Python coding skills

Data processing tools

Analytical problem-solving

Communication skills

Education

Bachelor's or master's degree in Computer Science, Information Systems, or Engineering

Tools

BigQuery

Jupyter

dbt

Airflow

AWS Glue

Azure Data Factory

Job description

A leading data analytics company in Jakarta is seeking a highly technical Business Intelligence Engineer to design and maintain data infrastructure for analytics. Responsibilities include developing scalable ETL pipelines, building data models, and optimizing warehouse performance. Candidates should hold a relevant degree and possess strong SQL and Python coding skills. This role involves collaboration with BI Analysts, ensuring data integrity, and implementing data quality processes. The company offers competitive benefits and a dynamic work environment.