Data modeler

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 Big Query 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 Dev Ops seat