Data Engineer / Data Architect (ETL)

FIBERSTAR (PT. Mega Akses Persada); Jakarta Utara; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading fiber optic service provider in Indonesia seeks a Data Engineer to design and maintain data pipeline architecture, ensuring data quality and integrity. The ideal candidate has at least 2 years of experience and a Bachelor's degree in a relevant field, with strong skills in SQL and Python. This role involves collaboration with stakeholders and requires critical thinking and problem-solving skills.

Qualifications

• Minimum 2 years of experience as Data Engineer/Data Architect/Business Intelligence or in a similar role.
• Proven involvement in data migration projects, data warehouse implementation, or operational system integration.
• Detail oriented, critical and data driven, with good interpersonal skills.

Responsibilities

• Design, build, and maintain scalable data pipeline architecture.
• Ensure data quality, security, and integrity across all ETL processes.
• Support data migration processes, including mapping, staging, validation, and UAT.

Skills

SQL

Python

Relational databases

Data modeling

Data migration

ETL tools

Cloud data platforms

Education

Bachelor's degree in IT, Information System, Statistic, Mathematic, or related field

Tools

SQL Server

PostgreSQL

MySQL

BigQuery

Snowflake

dbt

Apache Hive

Talend

Informatica

Azure Data Factory

Google Cloud Dataflow

AWS Glue

Job description

Overview

Design, build, and maintain scalable data pipeline architecture (ETL/ELT) for integrating data from various systems (CRM, Billing, Network Inventory, etc.). Compile, process, and manage large and complex datasets to meet business requirements. Ensure data quality, security, and integrity across all ETL processes. Support data migration processes, including mapping, staging, validation, and UAT. Develop and maintain Enterprise Data Warehouse (EDW) and support its performance monitoring. Collaborate with Data Architects and BI Developers to design consistent and reusable data models. Build and optimize analytics tools, dashboards, reports, and self-service solutions to deliver actionable business insights. Provide clean, ready-to-use data for analytics, reporting, and AI/ML solutions. Design and develop APIs and back-end integrations to support data-driven applications. Document data pipelines, integration processes, and metadata in a clear and structured manner. Manage stakeholder communication, ensuring expectations are met and feedback is addressed.

Job Requirements

• Minimum 2 years of experience as Data Engineer/Data Architect/Business Intelligence or in a similar role.
• Minimum Bachelor's degree in IT, Information System, Statistic, Mathematic, or a related field
• Proven involvement in data migration projects, data warehouse implementation, or operational system integration.
• Proficient in SQL and Python (for scripting and automation).
• Hands-on experience with relational databases (SQL Server, PostgreSQL, MySQL) and data warehouses (BigQuery, Snowflake, etc.).
• Skilled in ETL tools such as dbt, Apache Hive, Talend, Informatica, or similar.
• Strong understanding of data modeling concepts (Star Schema, Snowflake Schema, semantic layer modeling).
• Experience with cloud data platforms (Azure Data Factory, Google Cloud Dataflow, AWS Glue) is a plus.
• Familiarity with data lineage, data validation, and data quality monitoring.
• Detail oriented, critical and data driven, with good interpersonal skills
• Logical thinking and strong problem solving skills

About the company: FiberStar is Indonesia\'s first fiber optic-based Nationwide Infrastructure service Provider with Net Neutrality concept. With 100% Fiber Optic, FiberStar is designed with open access infrastructure to distribute TRIPLE PLAY services on a QUAD PLAY network, supporting ICT adoption and national resilience in the Digital Economy.