Senior Data Engineer

Scarlett Indonesia; Jakarta Barat; Hybrid; IDR 156,240,000 - 267,840,000; Full time

Job summary

Scarlett Indonesia is seeking a Data Engineer to build and maintain robust ETL/ELT pipelines from diverse sources into a central data warehouse. You will design scalable data models, ensure data quality, and enable BI/reporting for business insights.

You will collaborate with analysts and IT teams, optimize queries, and document data architectures while supporting cloud platforms and data governance practices to drive informed decision making.

Qualifications

• Bachelor’s degree in IT, CS, Data Engineering or related field with 3–4 years of experience.
• Strong SQL skills, including complex queries, performance optimization, and data modeling.
• Hands-on ETL/ELT experience with tools like SSIS, Talend, Airflow, Azure Data Factory, or equivalent.
• Familiar with databases/data warehouses (SQL Server, PostgreSQL, Snowflake, BigQuery) and API integration for data consolidation.

Responsibilities

• Build and maintain ETL/ELT pipelines from databases, apps and APIs to the data warehouse.
• Design and manage data warehouse structures and data models.
• Ensure data quality, consistency, and availability across ecosystems.
• Monitor pipeline performance and troubleshoot data process failures.
• Publish datasets/reports to internal BI/reporting portal and maintain documentation.

Skills

SQL

ETL/ELT

Data modeling

REST/SOAP API integration

BI/reporting collaboration

Data governance

Cloud familiarity

Education

Bachelor’s degree in IT / Computer Science / Data Engineering

Tools

SSIS

Talend

Airflow

Azure Data Factory

SQL Server

PostgreSQL

Snowflake

BigQuery

Job description

Founded in 2017, Scarlett Indonesia has rapidly emerged as one of the leading local brands in beauty and personal care. As a fast-growing company, we have built a strong presence across both online and offline platforms.

Our growth is driven by our innovative product offerings, passionate team, and the support of over 5 million organic followers on Instagram and e-commerce channels.

With a bold vision to become Indonesia’s number one beauty and personal care brand, we invite you to be part of our journey and #BeOurSTARlett!

Qualifications:

• Bachelor’s degree in IT, Computer Science, Data Engineering, or a related field, with 3–4 years of experience in Data Engineering or related roles.
• Strong SQL skills, including complex queries, performance optimization, and data modeling (Star/Snowflake Schema).
• Hands-on experience with ETL/ELT tools such as SSIS, Talend, Airflow, Azure Data Factory, or equivalent.
• Familiar with databases/data warehouses such as SQL Server, PostgreSQL, Snowflake, BigQuery, or equivalent, and REST/SOAP API integration for data consolidation.
• Familiarity with Azure, AWS, or GCP is a plus.
• Experience working with Business Analysts/users to prepare data sources for BI/reporting.
• Understanding of data governance and data quality, including validation, cleansing, and documentation.

Responsibilities:

• Build and maintain ETL/ELT pipelines from databases, applications, and APIs to the data warehouse, including API integrations to consolidate data across systems.
• Design and manage data warehouse structures and data models.
• Ensure data quality, consistency, and availability.
• Monitor pipeline performance and troubleshoot data process failures.
• Publish Business Analyst datasets/reports to the internal reporting portal.
• Maintain technical documentation for data architecture, pipelines, and integrations.
• Collaborate with Business Analysts/users and IT teams to support BI/reporting and technical requirements.

Why Scarlett Indonesia?

At Scarlett Indonesia, time flies beautifully as we stay focused on building, growing, and achieving meaningful milestones through memorable experiences.

With our GLOW UP culture, we aim to build and empower a talented workforce that drives business growth through innovation, collaboration, and a positive work culture.

#BeOurSTARlett and illuminate your path to success in the dynamic world of beauty and personal care.