Data Modeler - ETL/Snowflake DB

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.