Data Warehouse & Automation Engineer

Monee; Jakarta Pusat; On-site; IDR 240,000,000 - 420,000,000; Full time

Job summary

Monee is seeking a Data Warehouse & Automation Engineer to join our data platform team in Jakarta. The role focuses on building robust Data Warehouse & Data Mart schemas, automating data pipelines, and implementing reverse-ETL to feed compliant data back to operational tools and regulatory portals.

You will collaborate with BI, Regulatory Compliance, and Project teams to translate requirements into scalable data models and automated workflows, ensuring data quality and performance at scale.

Qualifications

• Bachelor’s degree in Computer Science, Data Analytics or related field with 2+ years of experience in Data Warehouse Engineering.
• Advanced SQL with focus on performance tuning and best practices.
• Experience designing robust data warehouse architectures for high-volume analytics and reporting.
• Working knowledge of Python for scripting, automation, and reverse-ETL.
• Proficiency in Apache Spark (PySpark/Spark SQL) for large-scale data engineering.
• Experience with analytics engineering tools (dbt, Dataform) is a plus.
• Good English communication skills to explain insights to non-technical stakeholders.

Responsibilities

• Design, build, and maintain robust Data Warehouse & Data Mart tables.
• Build automated data pipelines and reverse-ETL workflows to supply regulatory data.
• Collaborate with BI, Regulatory Compliance, and Project teams to translate requirements.
• Implement data validation, error handling, and automated quality checks.
• Apply software engineering best practices to analytics codebases and queries.
• Ensure secure, scalable data pipelines to regulatory portals.

Skills

Advanced SQL

Data warehouse design

Python scripting

Spark PySpark

Data quality checks

English communication

Education

Bachelor’s degree in Computer Science

Data Analytics related field

Tools

dbt

Dataform

Apache Spark

Job description

Monee is seeking a Data Warehouse & Automation Engineer to join our data platform team in Jakarta. The role focuses on building robust Data Warehouse & Data Mart schemas, automating data pipelines, and implementing reverse-ETL to feed compliant data back to operational tools and regulatory portals.

You will collaborate with BI, Regulatory Compliance, and Project teams to translate requirements into scalable data models and automated workflows, ensuring data quality and performance at scale.