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
- Robust 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: [email protected]
- Call / WhatsApp: +91-(phone hidden)

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 (Vasanthanagar)
🏢 Ipivot
📍 Vasanthanagar