Data Engineer

Facetology; Jakarta Selatan; On-site; IDR 279,000,000 - 468,720,000; Full time

Job summary

FACETOLOGY in Jakarta is seeking a Data Engineer to develop, maintain, and optimize ETL/ELT data pipelines, design data warehouse models, and build automated monitoring and data quality checks. You will ingest data from REST APIs, e-commerce/ad platforms, Excel/CSV, and other sources while ensuring performance, scalability, and reliability.

The role collaborates with Data Analysts and cross-functional teams to translate business requirements into reliable data solutions, with a strong focus on

Qualifications

• Bachelor’s degree in CS or IT with GPA ≥ 3.00/4.00.
• 2–4 years of Data Engineer experience.
• Strong SQL and data transformation skills.
• Experience with ETL/orchestration tools (Airflow, Glue, Composer, ADF).
• Experience with AWS, GCP, or Azure cloud platforms.
• Familiarity with data warehousing and dimensional modeling.

Responsibilities

• Develop, maintain, and optimize ETL/ELT data pipelines to ensure performance, scalability, and reliability.
• Design and maintain data warehouse architecture and data models, including star/snowflake schemas and partitioning.
• Build automated pipeline monitoring, alerting, data quality checks, and error-handling mechanisms.
• Develop robust data ingestion processes from REST APIs, e-commerce/ad platforms, Excel/CSV, and other data sources.
• Manage and optimize cloud data infrastructure, primarily using AWS, to improve efficiency and control costs.
• Collaborate with Data Analysts and cross-functional teams to translate business requirements into reliable data solutions.

Skills

SQL proficiency

Data modeling

ETL/ELT design

Data pipeline monitoring

REST API data ingestion

Cross-functional collaboration

Education

Bachelor’s Degree in Computer Science or Information Technology (GPA 3.00/4.00)

Tools

Apache Airflow

AWS Glue

GCP Composer

Azure Data Factory

Job description

Joining FACETOLOGY means becoming part of a dynamic beauty brand. We are a human-centric environment, driven by the purpose of enhancing quality of life through our products.

As a Data Engineer, you will:

Job Description

• Develop, maintain, and optimize ETL/ELT data pipelines to ensure performance, scalability, and reliability.
• Design and maintain data warehouse architecture and data models, including star/snowflake schemas and partitioning.
• Build automated pipeline monitoring, alerting, data quality checks, and error-handling mechanisms.
• Develop robust data ingestion processes from REST APIs, e-commerce/ad platforms, Excel/CSV, and other data sources.
• Manage and optimize cloud data infrastructure, primarily using AWS, to improve efficiency and control costs.
• Collaborate with Data Analysts and cross-functional teams to translate business requirements into reliable data solutions.

Qualifications

• Minimum Bachelor’s Degree (S1) in Computer Science or Information Technology with a minimum GPA of 3.00/4.00.
• 2–4 years of experience as a Data Engineer or in a related data role.
• Advanced proficiency in SQL and experience in query optimization and complex data transformations.
• Hands-on experience with ETL/orchestration tools such as Apache Airflow, AWS Glue, GCP Composer, or Azure Data Factory.
• Strong experience with AWS, GCP, or Azure; AWS experience is highly preferred.
• Good understanding of data warehousing, dimensional modeling, APIs, data quality, and data pipeline monitoring.
• Experience with AWS Glue, S3, Athena, EventBridge, CloudWatch, Spark/PySpark is a strong plus.

Only shortlisted candidates will be contacted by our recruitment team.