Apply Now

Job Summary:
We are seeking an experienced Data Modeler to design and implement high-quality analytical data models that support enterprise reporting, analytics, and data science use cases. The ideal candidate will have hands-on expertise in Silver and Gold layer modeling, dimensional data warehouse design, and Python automation to streamline data modeling, validation, and documentation processes.

Key Responsibilities:
       Experience with database modeling tools such as LucidChart"
       Experience with standard data models such as S-95
       Design and develop Silver and Gold layer data models following medallion architecture principles.
       Create and maintain dimensional models (Star and Snowflake schemas) for enterprise data warehouses.
       Define fact and dimension tables aligned with business KPIs and analytical requirements.
       Apply best practices for slowly changing dimensions (SCDs) and historical data tracking.
       Lead end-to-end data warehouse design and modeling initiatives.
       Translate business requirements into scalable, performant data models.
       Optimize models for query performance, usability, and extensibility.
       Partner with data engineers to ensure accurate implementation of models.
       Develop Python-based automation for data model validation, reconciliation and documentation.
       Automate metadata extraction, schema comparison, and impact analysis.
       Support automated testing of data models and transformations.
       Build reusable Python utilities to improve modeling efficiency.
       Collaborate with data engineers, analysts and architects.
       Participate in design reviews and ensure alignment with enterprise data standards.
       Support data governance initiatives including data definitions, lineage, and documentation.
       Ensure consistency in naming conventions, data types, and modeling standards.

Required Skills and Qualifications:
8–12+ years of experience in data modeling and data warehousing.
Strong hands-on experience with Silver & Gold layer modeling
Dimensional modeling (Star / Snowflake schemas) and Data warehouse design
Python automation. Deep understanding of fact/dimension design, grain definition, and KPI modeling.
Experience with large-scale analytical datasets.

Good to Have:
Microsoft Certified: Azure Data Engineer Associate or Azure Enterprise Data Analyst Associate.
Experience with cloud data platforms (Azure).Exposure to CI/CD and version control for data models.
Knowledge of metadata management and data governance tools.
Wast management or oil and gas domain knowledge