Jobs via Dice
Data Warehouse Architect
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Warehouse Architect with a contract length of unspecified duration, located in Lansing, Michigan, offering a hybrid work arrangement. Key skills include Teradata expertise, Erwin Data Modeler proficiency, and 5+ years in data modeling for large-scale environments.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
November 21, 2025
🕒 - Duration
Unknown
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Lansing, MI
-
🧠 - Skills detailed
#GCP (Google Cloud Platform) #Data Profiling #Computer Science #Data Mart #"ETL (Extract #Transform #Load)" #Physical Data Model #AWS (Amazon Web Services) #ERWin #Data Warehouse #Data Governance #Documentation #Tableau #Metadata #Data Architecture #Cloud #Agile #Database Performance #Microsoft Power BI #Azure #SQL (Structured Query Language) #Scala #DevOps #Databases #Data Modeling #Database Design #Data Management #Teradata #BI (Business Intelligence)
Role description
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Stellar Professionals LLC, is seeking the following. Apply via Dice today!
• Location: Lansing, Michigan
• Work Arrangement: Hybrid
• Contract: This is a Contract position.
• Mode of Interview: Virtual Interview via MS Teams.
Key Responsibilities
• Design, develop, and maintain both logical and physical data models for Teradata-based data warehouses and data marts.
• Utilize Erwin Data Modeler (including Model Mart) to create, update, and manage data models, metadata, and data dictionaries.
• Translate complex business requirements into effective and scalable database designs.
• Define and enforce data modeling standards, best practices, and naming conventions.
• Collaborate with ETL teams to ensure seamless data flow and process consistency.
• Conduct data profiling, analysis, and impact assessments for data model changes.
• Optimize data structures and SQL for superior performance and maintainability within the Teradata architecture.
• Support data governance and metadata management initiatives.
Required Qualifications
• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 5+ years of dedicated experience in data modeling for large-scale data warehouse environments.
• Strong experience with Teradata databases and architecture.
• Expertise in Erwin Data Modeler and Erwin Model Mart.
• Strong foundational understanding of both normalized (3NF) and dimensional modeling (Kimball) techniques.
• Experience with ETL design concepts, data governance, and metadata management.
• Solid command of SQL and practical knowledge of database performance tuning.
• Excellent analytical, communication, and technical documentation skills.
Preferred Qualifications
• Experience with cloud data platforms (e.g., AWS, Azure, Google Cloud Platform) and their integration with Teradata.
• Familiarity with major BI/reporting tools (e.g., Tableau, Power BI).
• Exposure to Agile / DevOps methodologies.
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Stellar Professionals LLC, is seeking the following. Apply via Dice today!
• Location: Lansing, Michigan
• Work Arrangement: Hybrid
• Contract: This is a Contract position.
• Mode of Interview: Virtual Interview via MS Teams.
Key Responsibilities
• Design, develop, and maintain both logical and physical data models for Teradata-based data warehouses and data marts.
• Utilize Erwin Data Modeler (including Model Mart) to create, update, and manage data models, metadata, and data dictionaries.
• Translate complex business requirements into effective and scalable database designs.
• Define and enforce data modeling standards, best practices, and naming conventions.
• Collaborate with ETL teams to ensure seamless data flow and process consistency.
• Conduct data profiling, analysis, and impact assessments for data model changes.
• Optimize data structures and SQL for superior performance and maintainability within the Teradata architecture.
• Support data governance and metadata management initiatives.
Required Qualifications
• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 5+ years of dedicated experience in data modeling for large-scale data warehouse environments.
• Strong experience with Teradata databases and architecture.
• Expertise in Erwin Data Modeler and Erwin Model Mart.
• Strong foundational understanding of both normalized (3NF) and dimensional modeling (Kimball) techniques.
• Experience with ETL design concepts, data governance, and metadata management.
• Solid command of SQL and practical knowledge of database performance tuning.
• Excellent analytical, communication, and technical documentation skills.
Preferred Qualifications
• Experience with cloud data platforms (e.g., AWS, Azure, Google Cloud Platform) and their integration with Teradata.
• Familiarity with major BI/reporting tools (e.g., Tableau, Power BI).
• Exposure to Agile / DevOps methodologies.
