Job Role - Enterprise Data Modeler – Midstream Oil & Gas. Location: PAN India Experience: 7+ Years Domain: Midstream Oil & Gas — Mandatory Qualification: Any Graduate | Any Post Graduate | Any Diploma We are looking for an experienced Enterprise Data Modeler with solid Midstream Oil & Gas domain expertise to design and govern data models supporting pipeline, gathering, processing, storage, commercial, regulatory, and analytics platforms. This role sits at the intersection of Data Architecture + Data Modeling + Midstream Domain Expertise, working across Snowflake, dbt, Informatica IDMC, and Airflow.● Key Responsibilities• Design Conceptual, Logical & Physical Data Models• Build ER Diagrams, Star Schemas, Data Vault & 3 NF models• Model midstream domains including: Pipeline scheduling & nominations Volumetric measurement & allocations Gathering & processing Terminal / storage inventory Tariffs & regulatory reporting Commercial contracts• Define and govern Bronze → Silver → Gold data-layering strategy• Design Fact & Dimension models, SCD Type 1/2,



surrogate & natural keys• Develop conformed dimensions across business units• Partner with Data Engineering teams on dbt sources, staging models & marts• Define Data Dictionary, Metadata, Lineage & Business Definitions• Reconcile source systems into conformed enterprise data models• Support Master Data Management for assets, meters, contracts, counterparties & tariff schedules• Contribute to Data Governance, Data Quality & Modeling Standards● Mandatory Skills• Midstream Oil & Gas Domain – Mandatory• 5+ years of Data Modeling experience• Conceptual / Logical / Physical Data Modeling• ERD | Star Schema | Data Vault | 3 NF• Fact & Dimension Design | SCD Type 1 & 2• Strong SQL• Snowflake or equivalent cloud data warehouse• dbt or comparable transformation framework• Data Dictionary | Metadata | Lineage | Data Quality• Experience with data modeling tools such as erwin, ER/Studio, Sql DBM, dbdiagram or similar● Good to Have• Infor

📌 Data Modeler (Bengaluru)
🏢 Ipivot
📍 Bengaluru