Data Modeler

Job Description

Hiring: Data Modeler – Midstream Oil & Gas

\n

Experience: 6–8 years

\n

Notice Period : Immediately to 15 days

\n

Location: India

\n

\n

Required Qualifications

\n

\n
• 6+ years of data modeling experience (conceptual, logical, physical), including dimensional modeling and normalized/3NF design.
\n
• 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).
\n
• Practical experience with dbt (or a comparable transformation framework) — understands how models translate into source()/ref() dependencies, tests, and documentation.
\n
• 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.
\n
• Experience with data modeling tools (erwin, ER/Studio, SqlDBM, dbdiagram, or similar) and producing clear ER diagrams for both technical and business audiences.
\n
• 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.
\n
• Understanding of data governance fundamentals: metadata management, data lineage, data quality rules, and stewardship.
\n

\n

\n

Preferred Qualifications

\n

\n
• 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.
\n
• Experience with Airflow or another orchestration platform, and how DAG design affects data freshness and dependency management for the models you own.
\n
• Exposure to medallion/lakehouse architecture (Bronze/Silver/Gold) and the tradeoffs of layering conformed business models vs. raw ingestion.
\n
• Prior experience in a data governance or data steward capacity.
\n

\n