Data Warehouse Architect

Title : Data Warehouse Architect 5

Location : Lansing, MI

Interview Process : Virtual Interview via MS Teams.

Duration : 1 year with possible extension.

Remote or On-site : Accepting local candidates within 2 hours of Lansing ONLY. Position will be hybrid, in office 2 days a week upon start and there is NO REMOTE ONLY option.

Full Job Description : We are seeking an experienced Data Modeler with strong expertise in Teradata and Erwin Data Modeler tools.

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

Preferred Qualifications