Analytics Engineer & Data Modeler: Semantic Graph

Randomtrees; United States; Remote; USD 110,000 - 170,000; Full time

Job summary

Randomtrees is seeking an Analytics Engineer/Data Modeler to own the semantic layer and graph model, making numbers deterministic and relationships traversable. You will focus on dimensional modeling, ontology work, and enterprise-grade entity resolution, with dbt Core and SQL proficiency.

You will also craft semantic views, named metrics, and verified queries while designing row access policies, masking policies, and governance in collaboration with DevOps.

Qualifications

• Experience with dimensional modeling (star schema, conformed & slowly changing dims).
• Strong handling of graph data modeling, node/edge design and ontology work.
• Proficiency in SQL and Python for transformations; familiarity with dbt or equivalent.

Responsibilities

• Own semantic layer and graph model, making numbers deterministic and relationships traversable.
• Develop and enforce verified queries, semantic views and named metrics.
• Design row access policies and masking policies in collaboration with DevOps.

Skills

Dimensional modeling

Graph data modelling

Entity resolution

SQL

dbt Core

Python

BigQuery

Row-level security

Policy design

Tools

dbt Core

SQLFluff

Python

GCP BigQuery

Job description

Randomtrees is seeking an Analytics Engineer/Data Modeler to own the semantic layer and graph model, making numbers deterministic and relationships traversable. You will focus on dimensional modeling, ontology work, and enterprise-grade entity resolution, with dbt Core and SQL proficiency.

You will also craft semantic views, named metrics, and verified queries while designing row access policies, masking policies, and governance in collaboration with DevOps.