About the Role :

We are looking for a Data Modeller with strong hands-on experience in enterprise data modelling and data design. The ideal candidate should be proficient in conceptual, logical, and physical modelling, with experience across relational, dimensional, and NoSQL data models and a strong understanding of data warehouse and modern data platform architectures.

Key Responsibilities :

- Design and maintain conceptual, logical, and physical data models for enterprise-scale data environments.
- Develop relational and dimensional models, including Star and Snowflake schemas, based on business and analytical requirements.
- Apply appropriate NoSQL data modelling patterns where required.
- Design data structures for data warehouses, data marts, ODS, and data lakes.
- Work with SQL-based platforms such as SQL Server, Oracle, and PostgreSQL.
- Translate business and analytical requirements into scalable, reusable, and high-quality data models.
- Define data entities, relationships, attributes, keys, constraints, hierarchies, and business rules.
- Work closely with Data Engineering, Analytics, BI, Architecture, and business teams to ensure models support downstream data consumption.
- Apply knowledge of data integration, ETL/ELT, and analytics/BI requirements while designing data models.
- Use data modelling tools such as ER/Studio, Erwin, or equivalent.
- Review and optimize existing data models for scalability, performance, consistency, and reusability.
- Contribute to enterprise data modelling standards, governance, documentation, and best practices.
- Work effectively across global,



multi-team delivery environments and client-facing engagements.
- Prepare clear technical documentation and presentations for business and technical stakeholders.
- For Principal-level responsibilities, provide architecture leadership, modelling governance, and guidance across multiple programs.

Required Skills :

- 6 - 11 years of overall experience, with 5 years of hands-on data modelling and data design experience.
- Robust expertise in Conceptual, Logical, and Physical Data Modelling.
- Strong understanding of Relational and Dimensional Modelling, including Star and Snowflake schemas.
- Working knowledge of NoSQL data modelling patterns.
- Experience with Data Warehouses, Data Marts, ODS, and Data Lakes.
- Strong SQL knowledge with platforms such as SQL Server, Oracle, PostgreSQL, or equivalent.
- Good understanding of ETL/ELT, data integration patterns, and BI/analytics consumption requirements.
- Hands-on experience with ER/Studio, Erwin, or equivalent data modelling tools.
- Exposure to Azure, AWS, Snowflake, or Databricks is preferred.
- Experience working in enterprise-scale, multi-team data environments.
- Experience in Energy, Oil & Gas, Utilities, or large industrial domains is an advantage.
- Strong stakeholder communication, requirement articulation, documentation, and presentation skills.
- Consulting mindset with a focus on quality, standards, governance, and reusability.
- Ability to work independently and collaboratively in global delivery and client-facing environments.

Education :

- Bachelors or Masters degree in Computer Science, Data Science, Engineering, or a related technical discipline.

📌 Data Modeler - ETL/Data Warehousing (India)
🏢 Glauben Technologies
📍 India