Data Modeller

Job Role - Data Modeler

Location: PAN India
Experience: 7 to 16 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 & allocation
• 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: [email protected]
• 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.