Live opening · Posted 3 days ago
Data Modeler
iPivot · Bengaluru, Karnataka, India (Hybrid)
You are 3 days behind. JobBeeper subscribers saw this role while it was still new.
At a glance
The key details from the original listing.
CompanyiPivot
LocationBengaluru, Karnataka, India (Hybrid)
Work modeHybrid
Source
Linkedin
Listed3 days ago
Your early-applicant advantage
Live timing from JobBeeper.
13 min
from Linkedin publishing this role to us finding it
6 min
median time from a role going live to a subscriber being told
6 hours
subscribers had this role before this page existed
49,672
roles found in the last 24 hours — the newest are not on this site yet
About the role
Description supplied by the original job listing.
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.
Work arrangement
Hybrid
More openings worth a look
Recently tracked roles with full details and direct application links.
Good roles move before most people even see them.
Tell JobBeeper what you want and get fresh matches delivered in minutes.
Start your free trial →