Senior Data Modeler

Key Responsibilities

• Collaborate with business stakeholders, product teams, and analysts to understand business requirements and translate them into data models and technical specifications.
• Design and implement conceptual, logical, and physical data models using EDW, Kimball, and Medallion Architecture principles.
• Develop reusable data models across Landing, Bronze, Silver, and Gold layers.
• Analyze enterprise datasets across domains such as Sales, Procurement, Finance, Supply Chain, Logistics, R&D, and SAP/Oracle systems.
• Ensure adherence to Data Governance, Data Quality, Data Observability, and Data Ops practices.
• Support Data Warehouse, Data Lake, migration, modernization, and cloud data platform initiatives.
• Optimize database designs through normalization, denormalization, and performance modelling techniques.

Required Skills & Experience

• 14-18 years of IT experience with strong exposure to Data Management, Data Warehousing, Analytics, and Enterprise Data Modelling.
• Strong experience in data modelling, database design, and dimensional modelling.
• Expertise in handling complex modelling scenarios such as SCDs, many-to-many relationships, late-arriving facts/dimensions, and data marts.
• Hands-on experience with data modelling tools such as Erwin, ER/Studio, Enterprise Architect, SQLDBM, or equivalent.
• Strong SQL skills with experience in data profiling, data analysis, and identifying data quality issues.
• Good understanding of Cloud Architecture, DevOps, Data Ops, Agile methodologies, metadata management, and data dictionaries.
• Strong knowledge of ETL/ELT patterns, Data Warehouse, Data Lake, and Lakehouse architectures.
• Excellent stakeholder management, communication, and problem-solving skills.