Data Modeler

iPivot · India

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

• 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, 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: shubham.saklani@ipivot.io

• Call / WhatsApp: +91-9667834493

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.