Hiring: Data Warehouse Architect (Teradata + Erwin) - Michigan Local Only

Overview

Hybrid
Depends on Experience
Contract - Independent
Contract - W2
Contract - 24 Month(s)
50% Travel
Able to Provide Sponsorship

Skills

Agile
Amazon Web Services
Analytical Skill
Business Intelligence
Business Objects
Cloud Computing
Collaboration
Communication
Computer Science
Data Analysis
Data Governance
Data Integrity
Data Marts
Data Modeling
Data Profiling
Data Quality
Data Structure
Data Warehouse
Database
Database Performance Tuning
DevOps
Documentation
ERwin
Extract, Transform, Load
Google Cloud
Google Cloud Platform
Information Systems
Management
Meta-data Management
Microsoft Azure
Microsoft Power BI
Modeling
Recruiting
Reporting
SQL
Scalability
Tableau
Teradata

Job Details

We are seeking an experienced Data Warehouse Architect / Data Modeler with strong hands-on expertise in Teradata and Erwin Data Modeler. The ideal candidate will design, implement, and maintain enterprise data models that support analytical, reporting, and operational needs for large-scale environments.

This role involves close collaboration with business analysts, data architects, ETL teams, and DBAs to ensure data integrity, consistency, and high performance.

Key Responsibilities

Design, develop, and maintain logical and physical data models for Teradata data warehouses and data marts.

Use Erwin Data Modeler to create, modify, and manage data models, metadata, and data dictionaries.

Analyze business requirements and convert them into scalable database designs.

Define and enforce data modeling standards, best practices, and naming conventions.

Partner with data architects and ETL developers to ensure alignment between models and ETL processes.

Perform data profiling, data analysis, and impact assessment for model changes.

Optimize data structures for performance, scalability, and maintainability in Teradata environments.

Support data governance and metadata management initiatives.

Participate in design sessions, code reviews, and data quality evaluations.

Provide documentation and production/development support.

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 expertise in Teradata databases and architecture.

Advanced proficiency with Erwin Model Mart.

Deep understanding of normalized, dimensional, and hybrid modeling techniques.

Experience in ETL concepts, data governance, and metadata management.

Strong SQL skills and experience with database performance tuning.

Excellent analytical, communication, and documentation abilities.

Preferred Qualifications

Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform integrated with Teradata.

Familiarity with BI/reporting tools like Tableau, Power BI, or Business Objects.

Exposure to Agile / DevOps environments.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.