Senior Analytics Engineer: Data Quality & Modeling Lead

PT AJAIB TTX Solusi (jakarta); Kebayoran Baru; On-site; IDR 240,000,000 - 480,000,000; Full time

Job summary

Ajaib is hiring a mid to senior Analytics Engineer to join the Analytics & Data Engineering team. This role sits between data engineering and business stakeholders, owning the transformation layer that turns raw data into trusted, well-modeled datasets that power analytics, reporting, and ML use cases across the company.

We seek someone who treats data ownership as a craft, pushes back when numbers don’t add up, and collaborates with upstream engineers to ensure reliable, scalable solutions.

Qualifications

• 5+ years of experience as an Analytics Engineer, Data Engineer, or Data Analyst with strong SQL/modeling focus.
• Strong SQL skills, including window functions, CTEs, and query optimization on a cloud warehouse.
• Production experience with dbt (sources, models, tests, macros, snapshots, exposures).
• Hands-on experience with BigQuery or an equivalent cloud data warehouse (Snowflake, Redshift).
• Solid understanding of dimensional modeling (Kimball) and modern data modeling patterns.
• Experience with version control (Git) and CI/CD workflows for data pipelines.
• Ability to communicate clearly with both technical and non-technical stakeholders, including holding the line on data quality issues with upstream teams.
• A track record of self-directed initiatives — projects, tools, or improvements you started without being asked.

Responsibilities

• Design, build, and maintain dbt models on BigQuery, following modular and tested transformation patterns.
• Take end-to-end ownership of assigned data domains — including the projects built on top of them, their data quality, documentation, and the trust stakeholders place in them.
• Treat data quality as non-negotiable: investigate anomalies, follow up persistently with data engineers and source system owners to resolve root causes rather than apply patches, and advocate for fixes upstream when needed.
• Partner with analysts, PMs, and business stakeholders to translate requirements into well-modeled datasets and clear metric definitions.
• Contribute to the team's governance frameworks — access control via taxonomy tags, naming conventions, model ownership, and CI/CD for dbt.
• Optimize BigQuery cost and performance (partitioning, clustering, incremental models, query patterns).
• Collaborate with data engineers on upstream pipelines (CDC, streaming, batch ingestion) to ensure source data fits downstream modeling needs.
• Proactively identify gaps and propose new AE initiatives — better testing frameworks, semantic layers, metric stores, internal tooling, automation.
• Mentor junior analytics engineers and review PRs.

Skills

SQL / data modeling

dbt

BigQuery

Dimensional modeling

Git / CI/CD for pipelines

Stakeholder communication

Self-directed initiative

Cloud data warehouse

Tools

BigQuery

Airflow

GitHub Actions

Snowflake

Job description

Ajaib is hiring a mid to senior Analytics Engineer to join the Analytics & Data Engineering team. This role sits between data engineering and business stakeholders, owning the transformation layer that turns raw data into trusted, well-modeled datasets that power analytics, reporting, and ML use cases across the company.

We seek someone who treats data ownership as a craft, pushes back when numbers don’t add up, and collaborates with upstream engineers to ensure reliable, scalable solutions.