Job ID: MI-151381 (913691125)10A
Hybrid/Local (Lansing ONLY) Teradata Data Warehouse Architect (15+) with Erwin Model Mart, ETL, data governance, metadata management, AWS/Azure/GCP, BI/Tableau/Power BI/SAP BO, Agile, DevOps experience
Location: Lansing, MI (DTMB)
Duration: 12 Months
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.
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.
Top Skills & Years of Experience:
• 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.
• Experience in cloud data platforms (AWS, Azure, GCP) and integration with Teradata.
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.
SOMI – Candidate Cover Sheet – Updated 11.2025.docx