Data Warehouse Architect 5

Roles / Responsibilities :

• Design, develop, and maintain logical and physical data models for Teradata-based data warehouses and data marts.
• Use Erwin Data Modeler to create, update, and maintain data models, metadata, and data dictionaries.
• Analyze business requirements and translate them into effective database designs.
• Define and implement data modeling standards, best practices, and naming conventions.
• Collaborate with data architects and ETL teams to ensure consistency between data models and ETL processes.
• Perform data profiling, data analysis, and impact analysis on data model changes.
• Optimize data structures for performance, scalability, and maintainability in the Teradata environment.
• Support data governance and metadata management initiatives.
• Participate in code reviews, design sessions, and data quality assessments.
• Provide documentation and support for production and development teams.

Mandatory Skills :

Desirable Skills :