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 robust 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.

📌 Senior Data Modeler (Bengaluru)
🏢 Tredence
📍 Bengaluru