Talent.com
Data Warehouse Architect 5

Data Warehouse Architect 5

HighCloud SolutionsLansing, MI, Michigan, USA
1 day ago
Job type
  • Full-time
Job description

Title : Data Warehouse Architect 5

Location : Lansing, MI (Hybrid Only Locals)

Duration : 12 Months

Job Summary

  • We are seeking an experienced Data Modeler with strong expertise in Teradata and Erwin Data Modeler tools.
  • The ideal candidate will be responsible for designing, implementing, and maintaining enterprise data models that support analytical, operational, and reporting needs.
  • This role requires close collaboration with business analysts, data architects, ETL developers, and database administrators to ensure data integrity, scalability, and performance.

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 maintain data models, metadata, and data dictionaries.
  • Analyze business requirements and translate them into effective database designs.
  • Define and implement data modeling standards, best practices, and naming conventions.
  • Collaborate with data architects and ETL teams to ensure consistency between data models and ETL processes.
  • Perform data profiling, data analysis, and impact analysis on data model changes.
  • Optimize data structures for performance, scalability, and maintainability in the Teradata environment.
  • Support data governance and metadata management initiatives.
  • Participate in code reviews, design sessions, and data quality assessments.
  • Provide documentation and support for production and development teams.

    • 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 experience with Teradata databases and architecture.
  • Expertise in Erwin Model Mart.
  • Strong understanding of normalized and dimensional modeling techniques.
  • Experience with ETL design concepts, data governance, and metadata management.
  • Solid understanding of SQL and database performance tuning.
  • Excellent analytical, communication, and documentation skills.

    • Preferred Qualifications

  • Experience in cloud data platforms (AWS, Azure, GCP) and integration with Teradata.
  • Familiarity with BI / reporting tools (Tableau, Power BI, SAP Business Objects, etc.).
  • Exposure to Agile / DevOps methodologies.
    • Create a job alert for this search

    Data Architect • Lansing, MI, Michigan, USA