Data Warehouse & Automation Engineer (Reverse-ETL)

Moneep; Indonesia; On-site; IDR 300,000,000 - 540,000,000; Full time

Job summary

Moneep is hiring a Data Warehouse & Automation Engineer to design, build, and maintain data warehouse structures and automated data pipelines. You will ensure data quality and reliable operations across regulatory reporting and business analytics.

The role emphasizes strong SQL, Python, and Spark skills in a fast-paced environment. Collaborate with BI and Compliance teams to translate requirements into scalable data solutions, while applying software engineering practices to analytics codebases

Qualifications

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

Responsibilities

• Own the design, build, and maintenance of Data Warehouse & Data Mart tables.
• Build automated data pipelines and Reverse ETL workflows to feed operational tools and regulatory portals.
• Collaborate with BI, Regulatory Compliance, and Project teams to translate requirements into data solutions.
• Implement data validation, error handling, and automated data quality checks.
• Apply software engineering best practices to analytics code, optimize queries and storage for growing data volumes.
• Build and maintain secure, automated data pipelines to format and push compliance data to regulatory portals.

Skills

SQL

Python

Apache Spark

Education

Bachelor's degree in Computer Science or related field

Tools

dbt

Dataform

Job description

Moneep is hiring a Data Warehouse & Automation Engineer to design, build, and maintain data warehouse structures and automated data pipelines. You will ensure data quality and reliable operations across regulatory reporting and business analytics.

The role emphasizes strong SQL, Python, and Spark skills in a fast-paced environment. Collaborate with BI and Compliance teams to translate requirements into scalable data solutions, while applying software engineering practices to analytics codebases