Data Modeler/Teradata consultant

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

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 5 years of experience in data modeling for large-scale data warehouse environments.
• Strong experience with Teradata databases and architecture.
• Expertise in Erwin Model Mart.
• Strong understanding of normalized and dimensional modeling techniques.
• Experience with ETL design concepts, data governance, and metadata management.
• Solid understanding of SQL and database performance tuning.
• Excellent analytical, communication, and documentation skills.

Preferred Qualifications

• Experience in cloud data platforms (AWS, Azure, GCP) and integration with Teradata.
• Familiarity with BI/reporting tools (Tableau, Power BI, SAP Business Objects, etc.).
• Exposure to Agile / DevOps methodologies.