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.