Analytics Engineer: End-to-End Data Pipelines & BI

PT Somagede Indonesia; Jakarta Utara; On-site; IDR 180,000,000 - 360,000,000; Full time

Job summary

PT Somagede Indonesia is seeking a data analytics professional to own the organisation's data foundation end to end. You will work hands-on with pipelines, data models, and BI dashboards, delivering reliable, reporting‑ready data for management.

You will extract, transform, and automate data workflows using Python and SQL, build dashboards in Metabase/Power BI/Tableau, and ensure data quality before sharing insights with management.

Qualifications

• 2–3 years of experience in a data analyst, BI, analytics engineering, or data engineering role.
• Proven experience owning data pipelines and reporting in a real business environment.
• Advanced SQL skills with window functions, CTEs, and large-table query optimisation.
• Proficiency in Python or similar language for ETL.
• Hands-on experience building dashboards in Metabase, Power BI, or Tableau.
• Knowledge of data modelling, data warehouses, and pipeline scheduling.
• Strong Excel skills and MS Office proficiency.
• Strong written and verbal communication in Indonesian and English.

Responsibilities

• Own end-to-end data foundation from source systems to data warehouse and reports.
• Build, maintain, and optimise data pipelines.
• Design and maintain reporting-ready data models (fact and dimension tables).
• Develop dashboards and automated reports using Metabase, Power BI, or Tableau.
• Implement data quality checks and verify numbers before sharing insights.
• Translate business questions into structured analysis with minimal guidance.
• Explain technical findings clearly to non-technical stakeholders.
• Prioritise work, manage changing priorities, and deliver end-to-end.

Skills

SQL (Advanced)

Python

Data modeling

Data quality checks

ETL automation

Communication (Indonesian & English)

Analytical thinking

Education

Bachelor's degree or equivalent

Tools

Metabase

Power BI

Tableau

SAP

Odoo

Git

Linux

Job description

PT Somagede Indonesia is seeking a data analytics professional to own the organisation's data foundation end to end. You will work hands-on with pipelines, data models, and BI dashboards, delivering reliable, reporting‑ready data for management.

You will extract, transform, and automate data workflows using Python and SQL, build dashboards in Metabase/Power BI/Tableau, and ensure data quality before sharing insights with management.