IT Data Modeler

PT Kaldu Sari Nabati Indonesia; Kota Bandung; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading data solutions company based in Indonesia is seeking an IT Data Modeler to enhance its enterprise data foundation for high-quality analytics and reporting. Responsibilities include designing and maintaining data models, developing data warehouse models on Amazon Redshift, and collaborating with cross-functional teams using Azure DevOps. The ideal candidate will have strong experience in dimensional modeling, advanced SQL skills, and familiarity with cloud platforms. This role supports agile methodologies and emphasizes strong communication skills.

Qualifications

• Strong hands-on experience in dimensional modeling.
• Advanced SQL skills with a solid understanding of data governance principles.
• Familiarity with DBT and ETL/ELT frameworks.

Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Create and manage ERDs, data dictionaries, and data lineage documentation.
• Develop and optimize data warehouse models.

Skills

Dimensional modeling

Advanced SQL skills

Data governance principles

Collaboration skills

Agile/Scrum mindset

Tools

Amazon Redshift

Azure DevOps

DBT

ETL/ELT frameworks

MindMeister

draw.io

Job description

We’re seeking an IT Data Modeler to enhance our enterprise data foundation and facilitate high-quality analytics and reporting. In this role, you will design scalable data models, support cloud-based data warehouse initiatives, and collaborate closely with cross‑functional data teams to deliver reliable, business‑ready data assets.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Create and manage ERDs, data dictionaries, and data lineage documentation.
• Develop and optimize data warehouse models on Amazon Redshift.
• Collaborate with Data Engineers on data model implementation and validation.
• Support sprint planning and delivery activities using Azure DevOps.

Requirements

• Strong hands‑on experience in dimensional modeling.
• Advanced SQL skills with a solid understanding of data governance principles.
• Familiarity with DBT and ETL/ELT frameworks.
• Experience working with cloud platforms, preferably AWS.
• Exposure to data modeling tools such as MindMeister or draw.io is a plus.
• Strong communication and collaboration skills with an Agile/Scrum mindset.