Assignment Description
- Create and maintain conceptual, logical, and physical data models for databases and data warehouses.
- Optimize data structures for performance, scalability, and reliability.
- Work closely with business analysts, data architects, and software developers to understand data needs.
- Collaborate with stakeholders to gather and analyze requirements for data-related projects.
- Define database structures to support business operations and analytics.
- Develop and maintain data dictionaries and metadata.
- Provide guidance on data storage solutions (e.g., hive or cloud-based databases).
- Ensure data models align with organizational standards and governance policies.
- Identify and resolve data inconsistencies and redundancy.
- Document all data models and ensure they are up to date.
- Develop and enforce data modeling best practices and standards.
- Use data modeling tools such as Erwin or IBM Data Architect to create models.
- Implement data solutions on platforms like Hadoop or Hive tables.
- Analyze data models for performance bottlenecks and recommend optimizations.
Required Skills
- Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Science, or a related field.
- Proven experience in data modeling, database design, or related roles.
Technical Skills
- Proficiency in data modeling tools (e.g., Erwin, IBM Data Architect).
- Expertise in Big data database systems (e.g., Hive, Impala).
- Expertise in Relational database systems (e.g., Oracle).
- Familiarity with ETL processes, data warehousing, and cloud technologies.
- Data governance frameworks and best practices.
- Advanced knowledge of normalization, denormalization, and schema design patterns.
- Understanding of modern data architectures, such as data lakes and lakehouses.
