
Data Modeler
Posted 6 days ago

Posted 6 days ago
This is a fully remote position, open to applicants in India.
β’ Develop conceptual, logical, and physical data models for midstream data areas, such as pipeline scheduling and nominations, volumetric measurement and allocations, gathering and processing, terminal/storage inventory, tariffs and regulatory reporting, and commercial contracts.
β’ Take ownership of the Bronze β Silver β Gold layering approach in collaboration with data engineering.
β’ Create and sustain dimensional models, which encompass fact/dimension design, slowly changing dimensions (SCD) Type 1/2 strategy, surrogate versus natural keys, and conformed dimensions.
β’ Collaborate with data engineers to convert models into dbt sources, staging models, and marts, while reviewing pull requests to ensure compliance with modeling and naming standards.
β’ Establish and maintain the enterprise data dictionary, entity relationship documentation, and column-level metadata.
β’ Assess source systems ingested via Informatica IDMC/CDIR and dbt, and design their reconciliation into a unified conformed view.
β’ Lead data model evaluations with stakeholders from commercial, scheduling, accounting, and regulatory sectors.
β’ Assist in master data management for assets, meters/measurement points, contracts, counterparties, and tariff schedules.
β’ Contribute to data governance efforts, which include naming conventions, modeling standards, data quality regulations, and stewardship processes.
β’ Analyze the influence of new data sources and business modifications on current models, proposing schema evolution strategies to prevent disruption to downstream consumers.
β’ A minimum of 5 years of experience in data modeling (conceptual, logical, physical), including dimensional modeling and normalized/3NF design.
β’ Direct experience in the midstream oil & gas sector, with practical involvement in at least one of the following: pipeline scheduling/nominations, volumetric measurement and allocations, gas/liquids balancing, terminal or storage operations, or regulatory reporting.
β’ Proficient SQL skills and experience in modeling for a cloud data warehouse (Snowflake, Redshift, BigQuery, or similar).
β’ Hands-on experience with dbt or a similar transformation framework, including source()/ref() dependencies, tests, and documentation.
β’ Strong understanding of Kimball-style dimensional modeling, encompassing star schema, slowly changing dimensions, conformed dimensions, and factless facts, along with the appropriate application of Data Vault or 3NF.
β’ Familiarity with data modeling tools such as erwin, ER/Studio, SqlDBM, dbdiagram, or similar.
β’ Capability to create clear ER diagrams for both technical and business audiences.
β’ Ability to engage directly with business Subject Matter Experts (SMEs) to extract and formalize business rules into a data model.
β’ Understanding of fundamental data governance principles: metadata management, data lineage, data quality rules, and stewardship.
β’ Preferred: Experience with Informatica IDMC or similar ETL/ELT and CDC replication tools.
β’ Preferred: Experience with Airflow or another orchestration platform.
β’ Preferred: Familiarity with medallion/lakehouse architecture (Bronze/Silver/Gold).
β’ Preferred: Previous experience in a data governance or data steward role.
β’ Remote work arrangement.
ALB Conciergerie
Meiks Affiliate Tipps
StanMindsetMomentum
LEARN Behavioral
Get handpicked remote jobs straight to your inbox weekly.