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

SFlUMENoaFlBcXU5cTZOWU50aXRYWnNKQ2c9PQ==
  • 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

Greywind

Barista Job at Greywind

GREYWIND, the Seasonal American restaurant from award-winning chef DAN KLUGER is seeking a full-time BARISTA to join our team at The Bakery at Greywind in Hudson Yards. The Bakery hoursare 8am-3pm; serving fresh baked pastries and breads, breakfast sandwiches ...

McInnis Inc.

Recruiting Coordinator Job at McInnis Inc.

 ...Acquisition Researcher, you will play a vital role in examining rsums, screening potential candidates, and coordinating interviews. Unlike other recruiting agencies, we have a small and friendly environment, where you will work directly under an executive recruiter... 

Wellspring

Program Manager - Crisis Stabilization Unit - Adult Mental Health Job at Wellspring

 ...apply! What employees say about Wellspring... Wellspring's Crisis Stabilization Program: The goal of Wellsprings Crisis...  ...region. Wellspring Crisis Stabilization Unit (CSU) Program Manager: Wellspring is seeking a full time Program Manager who will... 

Wise Coatings of New Hampshire

Experienced Resin Floor Coatings Installer Job at Wise Coatings of New Hampshire

 ...You are eager to learn and can take constructive criticism without getting offended. You will be trained on how to transform floors in garages, basements, warehouses, etc. Floor coatings experience is required for Lead positions. You will be trained in the art... 

Griswold Care Pairing for Miami-Dade

CNA/HHA/ Certified Nursing Assistant Job at Griswold Care Pairing for Miami-Dade

CNA/HHA Dependable Caregivers NeededDo you enjoy working with seniors? We give people the help they need to live in the place where they love! We are looking for CNA/HHAs to join our nurse registry. As an independent contractor, you may appreciate:* Flexible work shifts...