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

Arhaus

Graphic Designer - Catalog Job at Arhaus

Since 1986, our mission at Arhaus has been simple. We design and build heirloom quality products while holding true to our commitment to use earth-friendly materials and to give back whenever possible. We are looking for someone who shares our love of story-telling and...

Pyramid Consulting, Inc

Microsoft Dynamic 365 Job at Pyramid Consulting, Inc

 ...Immediate need for a talented Microsoft Dynamic 365. This is a 12+ months contract opportunity with long-term potential and is located in Indianapolis, IN(Hybrid) . Please review the job description below and contact me ASAP if you are interested. Job ID: 25-93... 

Valvoline Inc.

Business Consultant Job at Valvoline Inc.

 ...Careers for the Driven Valvoline has a rewarding opportunity as a Business Advisor and Trainer, Express Care . We whole-heartedly adopt a never idle' mindset. We also know that outstanding service begins and ends with our employees. So, were looking for good people... 

ABB

Sales Proposal Engineer Job at ABB

 ...candidate will also provide support in early stages of project sales cycles, resolve contractual issues, and support negotiations through...  ...for the role Bachelor of Science in Electrical Engineering or equivalent. 10+ years business experience in related areas;... 

Compunnel Inc.

Laboratory Technician Job at Compunnel Inc.

CORE FUNCTIONS Perform preparation of reagents and controls Perform daily and weekly maintenance of equipment per SOPs (standard operating procedures) and any other applicable documentation Maintain laboratory and equipment clean and functional (On-the-job...