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

Fit for Work

Athletic Trainer Job at Fit for Work

 ...outcomes, so our clients can focus on what matters most: their business and those who keep it running. We are seeking an Athletic Trainer/Injury Prevention Specialist to join our team! This position is open to anyone with one of the following credentials:... 

Neater Pets

Senior Accountant Job at Neater Pets

 ...come from e-commerce channels, including Amazon, with wholesale distribution to retailers such as Tractor Supply, PetSmart, and TJ Maxx. We are seeking an experienced Senior Accountant who can bring structure, visibility, and insight to a complex, multi-location... 

jobgether

Executive Assistant - REMOTE Job at jobgether

 ...This position is posted by Jobgether on behalf of a partner company. We are currently looking for an Executive Assistant - REMOTE. This role plays a critical part in supporting executive leadership and driving efficiency in operations. The Executive Assistant will facilitate... 

Central Carolina Hospital

Emergency Medicine Physician in Sanford, North Carolina Job at Central Carolina Hospital

 ...coverage each day. California Applicant Privacy Act: Position Highlights: Flexible scheduling Independent contractor status Paid professional liability insurance with tail coverage Excellent compensation Sign-on bonus and relocation offered... 

FedEx Services

Package Handler - Part Time (Warehouse like) Job at FedEx Services

IMMEDIATE OPENINGS! Come for a job and stay for a career! Federal Express Corporation (FEC) is part of the rapidly growing warehouse and transportation sector that helps keep America, and our economy, moving. Be part of a winning team and workplace community that cares...