Senior Data Engineer

Scarlett Indonesia

Jakarta Barat

Hybrid

IDR 156,240,000 - 267,840,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Customer Experience Manager
Customer Experience Manager

Scarlett Indonesia • Jakarta Barat

On-site
IDR 279,000,000 - 468,720,000
Human Resources Business Partner
Human Resources Business Partner

Scarlett Indonesia • Jakarta Barat

On-site
IDR 250,000,000 - 400,000,000
Senior Executive, Creative Campaign
Senior Executive, Creative Campaign

Scarlett Indonesia • Jakarta Pusat

On-site
IDR 89,280,000 - 178,560,000
Beauty Advisor Capability Development Supervisor
Beauty Advisor Capability Development Supervisor

Scarlett Indonesia • Jakarta Barat

On-site
IDR 111,600,000 - 156,240,000
Social Media Content Creator
Social Media Content Creator

Scarlett Indonesia • Jakarta Pusat

On-site
IDR 66,960,000 - 122,760,000
Supervisor, Packaging Procurement & Finish Good
Supervisor, Packaging Procurement & Finish Good

Scarlett Indonesia • Jakarta Pusat

On-site
IDR 180,000,000 - 260,000,000
Procurement Executive
Procurement Executive

Scarlett Indonesia • Jakarta Pusat

On-site
IDR 60,000,000 - 90,000,000
Supervisor, Indirect Procurement
Supervisor, Indirect Procurement

Scarlett Indonesia • Jakarta Barat

On-site
IDR 180,000,000 - 260,000,000
Product Management Supervisor (Perfume)
Product Management Supervisor (Perfume)

Scarlett Indonesia • Jakarta Barat

On-site
IDR 1,800,000,000 - 2,400,000,000
Area Sales Supervisor (Palu)
Area Sales Supervisor (Palu)

Scarlett Indonesia • Palu

On-site
IDR 180,000,000 - 240,000,000