Data Engineer & Analyst

SATURDAYS; Daerah Khusus Ibukota Jakarta; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A lifestyle optical brand in Jakarta seeks a mid-level Data Engineer & Analyst to manage the data lifecycle from pipelines to insights. The role requires strong SQL and Python skills, alongside experience in data warehousing and BI tools. Responsibilities include optimizing ETL pipelines, performing data analysis, and developing dashboards. Ideal candidates will have a Bachelor’s degree and 3–5 years in related fields. This position offers an opportunity to support decision-making through data.

Qualifications

• 3–5 years of experience in data engineering, data analytics, or hybrid roles.
• Strong proficiency in SQL and Python for data processing.
• Hands-on experience with BI tools and data warehousing concepts.

Responsibilities

• Build and optimize ETL/ELT pipelines from multiple data sources.
• Manage and improve data warehouse and models for analytics.
• Translate business questions into SQL-based analysis.

Skills

SQL

Python

Data warehousing concepts

ETL/ELT pipelines

Business Intelligence tools

Education

Bachelor’s degree in Computer Science, Engineering, Statistics, or related field

Tools

Tableau

Power BI

Looker

Job description

SATURDAYS is a lifestyle optical brand offering quality eyewear and professional eye care in a comfortable retail environment. We focus on providing reliable eye care while delivering a pleasant and approachable customer experience.

We are seeking a mid-level Data Engineer & Analyst who owns the end-to-end data lifecycle—from building reliable data pipelines to delivering meaningful insights. This role combines hands-on data engineering with analytical problem-solving to support business and operational decision-making.

Responsibilities

Data Engineering

• Build, maintain, and optimize ETL/ELT pipelines from multiple data sources
• Manage and improve data warehouse and data models for analytics use cases
• Ensure data quality, accuracy, and consistency across datasets
• Monitor and troubleshoot data pipeline performance and failures
• Collaborate with product and engineering teams to support data needs

Data Analytics

• Translate business questions into SQL-based analysis and metrics
• Develop dashboards and recurring reports for business stakeholders
• Define, track, and maintain KPIs and core metrics
• Perform ad-hoc analysis to identify trends, risks, and opportunities
• Communicate insights clearly with actionable recommendations

Required Qualifications

• Bachelor’s degree in Computer Science, Engineering, Statistics, or related field
• 3–5 years of experience in data engineering, data analytics, or hybrid roles
• Strong proficiency in SQL
• Proficiency in Python for data processing and analysis
• Experience with data warehousing concepts and dimensional modeling
• Hands-on experience with at least one BI tool (e.g. Tableau, Power BI, Looker)