Data Modeler

Experience : 9+ Years

Location : Bangalore, Hyderabad, Chennai, Pune, Kolkata, Gurugram

Work Mode : Hybrid

Notice Period : Immediate Joiners (Only immediate joiners and candidates serving a notice period)

Job Summary :

We are looking for an experienced Data Modeler (L4) with 9 - 12 years of expertise in designing and implementing enterprise data models for large-scale data warehousing and analytics solutions. The ideal candidate should have strong experience with Erwin Data Modeler, SQL, and dimensional data modeling techniques such as Star Schema and Snowflake Schema. The role requires close collaboration with business stakeholders, data architects, ETL developers, and analytics teams to deliver scalable and high-performance data models.

Key Responsibilities :

- Design and develop conceptual, logical, and physical data models for enterprise data platforms.
- Build dimensional models using Star Schema and Snowflake Schema.
- Create and maintain data models using Erwin Data Modeler.
- Develop and optimize SQL queries for data validation, analysis, and performance tuning.
- Collaborate with data architects, ETL developers,



and business teams to understand data requirements.
- Ensure data models follow enterprise data governance and modeling standards.
- Perform impact analysis for schema changes and maintain data dictionaries and metadata.
- Support data warehouse initiatives and ensure data quality and consistency across systems.

Required Skills :

- Strong experience in Data Modeling (Conceptual, Logical, and Physical).
- Hands-on experience with Erwin Data Modeler.
- Excellent SQL coding and query optimization skills.
- Solid knowledge of Star Schema and Snowflake Schema.
- Experience in designing enterprise Data Warehouse solutions.
- Understanding of data governance, metadata management, and database design principles.
- Excellent analytical and problem-solving skills.

Preferred Skills :

- Experience with ETL/Data Integration tools.
- Exposure to cloud data platforms such as Azure, AWS, or GCP.
- Knowledge of BI and reporting tools is an advantage.
- Strong communication and stakeholder management skills.

📌 Data Modeler (India)
🏢 Techracers
📍 India