Analytics Engineer

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

Own the organisation's data foundation end to end, from source-system pipelines through the data warehouse to clean data models, dashboards, automated reports, and clear insights for management. This is a hands‑on technical analytics role focused on data and business intelligence rather than software development. You will work independently and take primary ownership of reliable, reporting‑ready data.

Key responsibilities

Build, maintain, and optimise data pipelines from source systems into the data warehouse.

Extract, transform, and automate data workflows using Python or similar tools.

Design and maintain reporting‑ready data models, including fact and dimension tables.

Build and own dashboards and automated reports using a BI tool such as 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 and management.

Prioritise work effectively, manage changing priorities, and take ownership through to delivery.

Requirements

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, including window functions, CTEs, and query optimisation on large tables.

Proficiency in Python or a similar language for data extraction, transformation, and ETL automation.

Hands‑on experience building and managing dashboards in a BI tool such as Metabase, Power BI, or Tableau.

Knowledge of data modelling, data quality checks, data warehouses, and pipeline scheduling.

Strong Microsoft Office skills, especially Excel.

Strong written and verbal communication skills in Indonesian and English, including the ability to read technical documentation and communicate in writing in English.

Ability to work independently, learn quickly, stay curious, and maintain quality in a fast-paced environment.

Education in any major.

Experience with ERP data such as SAP or Odoo, Linux or command line, Git, and basic statistics is desirable.

Manufacturing, Transport & Logistics 101-1,000 employees

For over three decades, Somagede Indonesia has been a trusted partner for Indonesia’s industries, providing high-quality cutting tools, adhesives, and essential solutions. From automotive to mining industries, our products are trusted to deliver precision and durability. With a strong commitment to customer satisfaction and industry expertise, we empower businesses across Indonesia to achieve reliable, efficient, and high-performance operations.

For over three decades, Somagede Indonesia has been a trusted partner for Indonesia’s industries, providing high-quality cutting tools, adhesives, and essential solutions. From automotive to mining industries, our products are trusted to deliver precision and durability. With a strong commitment to customer satisfaction and industry expertise, we empower businesses across Indonesia to achieve reliable, efficient, and high-performance operations.