Data Modeler

This is a fully remote position, open to applicants in India.

📋 Description

• 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.

⛳️ Requirements

• 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.

🏝️ Benefits

• Remote work arrangement.