- Design and develop conceptual, logical, and physical data models for enterprise applications and data platforms.
- Analyze business requirements and translate them into effective data modeling solutions.
- Define data entities, relationships, attributes, and business rules.
- Develop and maintain data dictionaries, metadata repositories, and data lineage documentation.
- Collaborate with Data Architects, Data Engineers, Business Analysts, and application teams to ensure data consistency and quality.
- Support database design, optimization, and performance tuning initiatives.
- Implement data governance standards, naming conventions, and best practices.
- Conduct data profiling and impact analysis for system enhancements and migrations.
- Assist in data warehouse, data lake, and master data management initiatives.
- Participate in Agile/Scrum ceremonies and contribute to project planning and delivery.
Required Skills & Qualifications
- Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related field.
- Strong experience in data modeling and database design.
- Expertise in creating:
- Conceptual Data Models
- Logical Data Models
- Physical Data Models
- Robust understanding of:
- Data Modeling Principles
- Data Normalization and Denormalization
- Dimensional Modeling (Star Schema, Snowflake Schema)
- ER Modeling
- Data Warehousing Concepts
- Proficiency in SQL and relational database management systems.
- Experience with data modeling tools such as: