Data Modeler

Teamware Solutions Inc.; India; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Teamware Solutions Inc. in India seeks an experienced Data Modeler to design and optimize enterprise data models across conceptual, logical, and physical layers. You will partner with business SMEs to capture rules and translate them into robust schemas that support analytics and reporting.

The ideal candidate has 6–8 years of data modeling experience in the oil and gas domain, strong SQL, and hands-on work with cloud data warehouses and modeling tools such as Erwin or ER/Studio.

Qualifications

• 6+ years of data modeling experience across conceptual, logical, and physical models.
• Direct experience in midstream oil & gas with pipeline scheduling, volumetric measurement, or regulatory reporting.
• Strong SQL skills and data modeling for cloud data warehouses (Snowflake/Redshift/BigQuery).
• Practical experience with dbt or similar transformation framework.
• Solid Kimball-style dimensional modeling knowledge and guidance between 3NF/Data Vault.
• Experience with data modeling tools (Erwin, ER/Studio, SqlDBM, dbdiagram) and creating clear ER diagrams.
• Ability to translate business rules from SMEs into structured schemas and understand data governance basics like metadata, lineage, data quality, stewardship.

Skills

Data modeling

SQL

dbt

Dimensional modeling

Kimball methodology

Data governance

Data lineage

Metadata management

Stakeholder collaboration

Tools

Erwin

ER/Studio

SqlDBM

dbdiagram

Snowflake

Redshift

BigQuery

Job description

Experience: 6-8 years

Notice Period: Immediately to 15 days

Location: India

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.