Data Modeler

Deltacubes

India

Experience Required: Overall: 8 - 12 years, Data Modeling: 6–8+ yrs, Snowflake: 5+ years, Advanced SQL: 7+ years, dbt: 3+ years, Building Cortex Analyst semantic models and verified queries: 6 Months+

About: Owns the semantic layer and the graph model, where numbers become deterministic and relationships traversable

Must-have experience

Dimensional modeling: star schema, conformed and slowly changing dimensions

Snowflake semantic views, named metrics, row access policies, masking policies

Cortex Analyst semantic models and the Verified Query Repository

Graph data modelling, node and edge design, ontology or taxonomy work

Entity resolution and alias mapping at enterprise scale dbt Core, SQL, SQLFluff or equivalent linting

Python for transformation work

GCP BigQuery exposure an advantage

Owns

Semantic views, named metrics, verified queries

Graph schema and entity resolution against the alias map

SQL correctness and numbers-from-code discipline

Row access policy design, jointly with the DevOps seat

Score my resume against this job, free →