Data Warehouse Architect 5 Job at HK Tech, Lansing, MI

VnJrZkdHN1phN1lyRk40TTJHWjBoSmZnTXc9PQ==
  • HK Tech
  • Lansing, MI

Job Description

Overview

We are looking for an experienced Data Modeler with deep expertise in Teradata and Erwin Data Modeler . In this role, you will design, implement, and maintain enterprise-level data models that support analytical, operational, and reporting needs. You will work closely with business analysts, data architects, ETL developers, and database administrators to ensure data integrity, scalability, and high performance across the data ecosystem.

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 manage data models, metadata, and data dictionaries.

  • Translate business requirements into scalable, high-quality database designs.

  • Establish and enforce data modeling standards , best practices, and naming conventions.

  • Partner with data architects and ETL teams to ensure alignment between data models and data integration processes.

  • Conduct data profiling , data analysis, and impact assessments for model changes.

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

  • Contribute to data governance and metadata management initiatives.

  • Participate in design reviews, code reviews, and data quality assessments.

  • Produce clear documentation and provide support to development and production teams.

Required Qualifications

  • Bachelor's degree in Computer Science, Information Systems, or a related field.

  • 5+ years of data modeling experience in large-scale data warehouse environments.

  • Strong hands-on experience with Teradata databases and architecture .

  • Proficiency with Erwin Model Mart .

  • Solid understanding of normalized and dimensional data modeling techniques.

  • Experience with ETL concepts , data governance, and metadata management.

  • Strong SQL skills and familiarity with database performance tuning .

  • Excellent analytical, communication, and documentation abilities.

Preferred Qualifications

  • Experience with cloud data platforms ( AWS, Azure, GCP ) and their integration with Teradata.

  • Familiarity with BI/reporting tools such as Tableau , Power BI , or SAP Business Objects .

  • Exposure to Agile or DevOps methodologies.

Job Tags

Full time,

Similar Jobs

Advocate Construction

Outside Sales Representative Job at Advocate Construction

 ...criminal background and MVR checks Ability to travel to Annual Sales Training Ability to carry 50 lbs. Ability to thrive in the outdoors in various weather conditions Willingness to work non-traditional hours when needed The Qualifications Our values of... 

University of California, Berkeley

Student Advocate 3 (4020U) University Health Services 83698 Job at University of California, Berkeley

 ...Student Advocate 3 (4020U) University Health Services 83698 About Berkeley At the University of California, Berkeley, we are dedicated to fostering a community where everyone feels welcome and can thrive. Our culture of openness, freedom and belonging make it a special... 

One City Schools, Inc.

Middle School Math Teacher Job at One City Schools, Inc.

 ...Middle School Math Teacher One City Schools | Madison, Wisconsin Full-Time | School-Year Position Salary Range: $50k - $80k depending on qualifications and experience Reports to: Middle School Principal Posted: December 2025 Application Deadline: Open... 

Cross Country Healthcare

Respiratory Therapist Job at Cross Country Healthcare

 ...community-focused hospital in Keene, New Hampshire , supported by a major regional health system. We are hiring a full-time Respiratory Therapist to deliver essential care in a collaborative setting. This role offers a unique opportunity for diverse experience,... 

Spectrum Solutions, Inc.

Project Manager Job at Spectrum Solutions, Inc.

Project Manager will oversee projects from bidding to execution and closeout. Projects will have an emphasis on Building Automation System installation. The ideal candidate will have experience managing field installation of BAS systems and overall project management of...