Data Modeler

Job not on LinkedIn

🔥 0 minutes ago

🇮🇳 India – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

✨ Data Modeler

👻 Ghost score 15%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Elfonze Technologies

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 2020

💼 Consulting

📦 Logistics

🏭 Manufacturing

Consulting • Logistics • Manufacturing

Elfonze Technologies is a technology services and solutions company that builds and manages enterprise IT systems, specializing in Oracle ERP, supply chain and logistics platforms, and cloud-native infrastructure (IaaS/PaaS). The company provides digital transformation, enterprise applications, master data management, AI-enabled platforms, and niche supply chain planning products and services for B2B customers, along with advisory and build-operate-transfer engagements.

📋 Description

• Design conceptual, logical, and physical data models for midstream data domains, including 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 with data engineering • Build and maintain dimensional models, including fact/dimension design, SCD Type 1/2 strategy, surrogate versus natural keys, and conformed dimensions • Partner with data engineers to translate models into dbt sources, staging models, and marts, and review pull requests for modeling and naming standards • Define and maintain the enterprise data dictionary, entity relationship documentation, and column-level metadata • Evaluate source systems ingested via Informatica IDMC/CDIR and dbt and model their reconciliation into a single conformed view • Lead data model reviews with commercial, scheduling, accounting, and regulatory stakeholders • Support master data management for assets, meters/measurement points, contracts, counterparties, and tariff schedules • Contribute to data governance, including naming conventions, modeling standards, data quality rules, and stewardship processes • Assess the impact of new data sources and business changes on existing models and propose schema evolution strategies that avoid breaking downstream consumers

🎯 Requirements

• 5+ years of data modeling experience (conceptual, logical, physical), including dimensional modeling and normalized/3NF design • Direct experience in midstream oil & gas, with 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, including source()/ref() dependencies, tests, and documentation • Solid grasp of Kimball-style dimensional modeling, including star schema, slowly changing dimensions, conformed dimensions, and factless facts, and when to use Data Vault or 3NF • Experience with data modeling tools such as erwin, ER/Studio, SqlDBM, dbdiagram, or similar • Ability to produce clear ER diagrams for technical and business audiences • Ability to work directly with business SMEs to extract and formalize business rules into a data model • Understanding of data governance fundamentals: metadata management, data lineage, data quality rules, and stewardship • Preferred: Experience with Informatica IDMC or similar ETL/ELT and CDC replication tooling • Preferred: Experience with Airflow or another orchestration platform • Preferred: Exposure to medallion/lakehouse architecture (Bronze/Silver/Gold) • Preferred: Prior experience in a data governance or data steward capacity

🏖️ Benefits

• Remote work arrangement