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 strong 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 & 3NF 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 | 3NF • Fact & Dimension Design | SCD Type 1 & 2 • Solid 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, SqlDBM, dbdiagram or similar ● Good to Have • Informatica IDMC / CDC / ETL-ELT • Airflow / DAG orchestration • Medallion / Lakehouse Architecture • Data Governance / Data Stewardship • Experience with batch vs. CDC ingestion patterns ● Interested candidates can share their updated profile: • Email: • Call / WhatsApp: You can also connect with me on LinkedIn and share your updated profile. If I’m unavailable on call, please leave a WhatsApp message, and I’ll get back to you at the earliest.

📌 Data Modeler (Karnataka)
🏢 Ipivot
📍 Karnataka