Ihsan Wanda

Analytics Engineer · dbt · DuckDB · Python · SQL

I build production data pipelines, dimensional models, and the semantic layer that makes a warehouse answer questions in its own language. Currently seeking remote Analytics Engineer roles.

dbtDuckDBPython SQLAirflowClickHouse Kimball modelingSemantic layer CI/CD

Featured projects

palm-analytics-dbt

End-to-end analytics engineering pipeline on Indonesian palm-oil estate operations. Four keyless data sources → Kimball star schema across 23 models (staging → intermediate → marts), with SCD2 snapshots, model contracts, and 99 passing tests enforced in CI.

developer-marketing-measurement-dbt

Marketing measurement for developer-tooling and PLG companies. Attribution triangulation — Multi-Touch Attribution, Media Mix Modeling (adstock & saturation), and incrementality testing (geo-lift, holdouts) — reconciled into one tested semantic layer. 15 models, 19 passing tests.

Case study — Making a Warehouse Answer Questions in Its Own Language

A case study in semantic layers over a data platform: 118 tables and 65 pipelines distilled into a 35-concept graph and a 135-metric business tree — 128 approved, 6 validator-failed, 1 rejected by its owner. Sanitized write-up; no client or metric names.

Other work