Data Warehouse Architect

Data Modeler (Teradata & Erwin) Location: Lansing, MI – Hybrid (2–3 Days Onsite Required) Local Candidates Only Rate: $75–$85/hr on W-2 ( No C2C ) ⏱ Duration: Long-term contract Position Overview We are seeking a highly skilled Data Modeler with deep experience in Teradata and Erwin Data Modeler / Erwin Model Mart to support enterprise data warehouse initiatives. This role is responsible for designing, optimizing, and maintaining logical and physical data models that support analytic, operational, and reporting needs across the organization. The ideal candidate brings strong data modeling expertise, a solid understanding of normalized/dimensional modeling, and hands-on experience building and maintaining complex Teradata environments. This role requires close collaboration with data architects, ETL developers, database administrators, and business stakeholders to ensure scalable, high-quality data solutions. Key Responsibilities Data Modeling & Architecture Design, develop, and maintain logical and physical data models within a Teradata-based enterprise data warehouse and dependent data marts. Use Erwin Data Modeler / Erwin Model Mart to create, version, and maintain data models, subject areas, metadata structures, and data dictionaries. Define and enforce data modeling standards, naming conventions, and best practices . Analysis & Design Analyze business and technical requirements and translate them into scalable and efficient database designs. Conduct data profiling, impact analysis, and gap analysis to validate source-to-target mapping and ensure data quality. Collaborate with data architects to ensure alignment between enterprise architecture and model designs. Integration & ETL Collaboration Partner with ETL developers to ensure data models are properly implemented and optimized for performance. Validate ETL designs against data models and support updates, enhancements, and troubleshooting when necessary. Support metadata management and data governance processes. Performance Optimization Optimize Teradata data structures for performance, scalability, and maintainability . Perform SQL and database performance tuning, index optimization, and structure refinement. Troubleshoot model-related issues across production and development environments. Documentation & Governance Maintain comprehensive model documentation , business definitions, lineage, and mapping specifications. Participate in design reviews, data quality assessments, and model validation. Support audit, compliance, and data governance initiatives through documentation and data standards enforcement. y and quality.