Data Warehouse Architect 5

Title: Data Warehouse Architect 5 Location: Lansing, MI (Hybrid Only Locals) Duration: 12 Months Job Summary • We are seeking an experienced Data Modeler with strong expertise in Teradata and Erwin Data Modeler tools. • The ideal candidate will be responsible for designing, implementing, and maintaining enterprise data models that support analytical, operational, and reporting needs. • This role requires close collaboration with business analysts, data architects, ETL developers, and database administrators to ensure data integrity, scalability, and performance. 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.