We are hiring a Enterprise Data modeller

Experience: 6+

Location: Bangalore ,hyderabad, Chennai, Kolkata, Mumbai, Noida, Gurugam

Notice Period: Immediate to 15 Days

Detailed JD:

About the Role

We're looking for a Data Modeler to design and govern the data models that power our midstream operations platforms. You'll translate how crude oil, NGLs, and natural gas actually move through gathering, processing, storage, and pipeline transportation into clean, well-documented data structures that support analytics, regulatory reporting, and downstream applications across the enterprise data platform (dbt/Snowflake, IDMC ingestion, Airflow orchestration).

This role sits at the intersection of data architecture and midstream domain expertise.

What You'll Do
- Design conceptual, logical, and physical data models (ER diagrams, dimensional/star schemas, Data Vault where applicable) for midstream data domains — pipeline scheduling and nominations, volumetric measurement and allocations, gathering and processing, terminal/storage inventory, tariffs and regulatory reporting,



and commercial contracts.
- Own the Bronze → Silver → Gold layering strategy in partnership with data engineering: define what belongs in raw/staging vs. conformed business entities vs. presentation-layer facts and dimensions.
- Build and maintain dimensional models (fact/dimension design, SCD Type 1/2 strategy, surrogate vs. natural keys, conformed dimensions across business units) for reporting and analytics consumption.
- Partner with data engineers to translate models into dbt sources, staging models, and marts, and review PRs for adherence to modeling and naming standards.
- Define and maintain the enterprise data dictionary, entity relationship documentation, and column-level metadata (business definitions, valid values, data lineage) for midstream subject areas.
- Evaluate source systems ingested via Informatica IDMC/CDIR and dbt, and model how they reconcile into a single conformed view.
- Lead

📌 Principal Data Design Engineer (Bengaluru)
🏢 Teamware Solutions
📍 Bengaluru