Data Modeler

About the role

Design conceptual, logical, and physical data models (ER diagrams, dimensional/star schemas, Data Vault where applicable) for midstream data domains — pipeline scheduling and nominations, volumetric measurement and allocations, gathering and processing, terminal/storage inventory, tariffs and regulatory reporting, and commercial contracts.

What you'll do

• Design conceptual, logical, and physical data models (ER diagrams, dimensional/star schemas
• Own the Bronze → Silver → Gold layering strategy in partnership with data engineering: define what belongs in raw/staging vs. conformed business entities vs.…
• Build and maintain dimensional models (fact/dimension design, SCD Type 1/2 strategy, surrogate vs. natural keys
• Partner with data engineers to translate models into dbt sources, staging models, and marts, and review PRs for adherence to modeling and naming standards
• Define and maintain the enterprise data dictionary, entity relationship documentation, and column-level metadata (business definitions, valid values

What you need

• 5–9 years in data science & ai
• SQL
• Data modelling
• dbt
• Data warehousing
• Snowflake
• Redshift
• MBA

Good to have

• ETL
• Airflow
• BigQuery
• Informatica