Enterprise Data modeller

Teamware Solutions Inc.; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Teamware Solutions Inc. is seeking an Enterprise Data Modeller to design and govern data models powering midstream platforms.

You will translate crude oil, NGLs, and natural gas movements into clean data structures for analytics and regulatory reporting across the enterprise data platform. Role sits at the intersection of data architecture and midstream domain expertise, collaborating with data engineering to implement dbt sources, staging, and marts.

Qualifications

• 6+ years of data modeling experience across conceptual, logical and physical layers.
• Midstream oil & gas domain exposure and hands-on modeling for analytics.
• Strong SQL skills and experience with cloud data warehouses (Snowflake/Redshift/BigQuery).
• Experience with dbt or similar transformation frameworks and lineage/tests.
• Solid knowledge of Kimball dimensional modeling and Data Vault suitability.

Responsibilities

• Design conceptual, logical, and physical data models (ER diagrams, star schemas, Data Vault).
• Own Bronze–Silver–Gold layering strategy with raw/staging vs conformed entities.
• Build and maintain dimensional models for reporting and analytics.
• Translate models into dbt sources, staging models, and marts with governance.
• Define enterprise data dictionary, metadata, and data lineage.
• Assess ingestion from Informatica IDMC/CDIR and dbt for conformed view.
• Lead data model reviews with business stakeholders (commercial, scheduling, accounting).
• Support master data management for assets, meters, contracts, counterparties, tariff schedules.
• Contribute to data governance: naming conventions, data quality rules, stewardship.
• Propose schema evolution to accommodate new data sources without breaking downstreams.

Skills

Data modeling

Dimensional modeling

SQL proficiency

dbt

Cloud data warehouses

Kimball modeling

ER/Studio/Erwin

Tools

dbdiagram

ER/Studio

SqlDBM

Job description

We are hiring a Enterprise Data modeller

Experience: 6+

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 to Silver to 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 data model reviews with business stakeholders (commercial, scheduling, accounting, regulatory) to validate that models correctly represent contracts, allocations, and volumetric relationships.
• Support master data management for core midstream reference entities (assets, meters/measurement points, contracts, counterparties, tariff schedules).
• Contribute to data governance: naming conventions, modeling standards, data quality rules, and stewardship processes.
• Assess the impact of new data sources or business changes (new pipeline systems, acquisitions, regulatory changes) on existing models and propose schema evolution strategies that avoid breaking downstream consumers.

Required Qualifications

• 6+ years of data modeling experience (conceptual, logical, physical), including dimensional modeling and normalized/3NF design.
• Direct experience in midstream oil & gas - hands-on exposure to at least one of: pipeline scheduling/nominations, volumetric measurement and allocations, gas/liquids balancing, terminal or storage operations, or regulatory reporting Strong SQL skills and experience modeling for a cloud data warehouse (Snowflake, Redshift, BigQuery, or similar).
• Practical experience with dbt (or a comparable transformation framework) - understands how models translate into source()/ref() dependencies, tests, and documentation.
• Solid grasp of Kimball-style dimensional modeling (star schema, slowly changing dimensions, conformed dimensions, factless facts) and when to use Data Vault or 3NF instead.
• Experience with data modeling tools (erwin, ER/Studio, SqlDBM, dbdiagram, or similar) and producing clear ER diagrams for both technical and business audiences.
• Comfortable working directly with business SMEs to extract and formalize business rules into a data model - this role requires translating ambiguous operational knowledge into structured schemas, not just implementing a spec handed to you.
• Understanding of data governance fundamentals: metadata management, data lineage, data quality rules, and stewardship.

Preferred Qualifications

• Experience with Informatica IDMC (or similar ETL/ELT and CDC replication tooling) and understanding of how ingestion patterns (batch vs. CDC) affect downstream model design.
• Experience with Airflow or another orchestration platform, and how DAG design affects data freshness and dependency management for the models you own.
• Exposure to medallion/lakehouse architecture (Bronze/Silver/Gold) and the tradeoffs of layering conformed business models vs. raw ingestion.
• Prior experience in a data governance or data steward capacity.