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

Integration & ETL Collaboration

Performance Optimization

Documentation & Governance