Data Modeler
RemoteFull-time5–9 yrsPosted over a month ago
Senior data science role at Elfonze. Needs 5+ years and an MBA. Remote.
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
- SQL
- Data modelling
- dbt
- Data warehousing
- Snowflake
- Redshift
Good to have
- ETL
- Airflow
- BigQuery
- Informatica