Overview
On Site
Hybrid
USD 85.00 per hour
Full Time
Skills
Recruiting
MI
Marketing Intelligence
Computer Science
Information Systems
Dimensional Modeling
SQL
Database Performance Tuning
Communication
Cloud Computing
Amazon Web Services
Microsoft Azure
Google Cloud
Google Cloud Platform
Business Intelligence
Tableau
Microsoft Power BI
Business Objects
Agile
DevOps
Analytical Skill
Reporting
Data Integrity
Data Warehouse
Data Marts
ERwin
Database
Collaboration
Extract
Transform
Load
Data Profiling
Data Analysis
Impact Analysis
Data Modeling
Data Structure
Scalability
Teradata
Data Governance
Meta-data Management
Data Quality
Documentation
Job Details
Date Posted: 11/20/2025
Hiring Organization: Rose International
Position Number: 493682
Industry: Government/Staffing
Job Title: Data Warehouse Architect
Job Location: Lansing, MI, USA, 48933
Work Model: Hybrid
Work Model Details: Position will be hybrid, in office 2 days a week (
Shift: Regular
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 13
Min Hourly Rate($): 85.00
Max Hourly Rate($): 95.00
Must Have Skills/Attributes: Data Modeling, Data Warehouse, ERWIN, Teradata
Experience Desired: Experience in cloud data platforms (AWS, Azure, Google Cloud Platform) and integration with Teradata (2 yrs); Familiarity with BI/reporting tools (Tableau, Power BI, SAP Business Objects, etc.) (2 yrs); Exposure to Agile / DevOps methodologies (2 yrs)
Required Minimum Education: Bachelor's Degree
**C2C is not available**
Job Description
REQUIRED EDUCATION:
Bachelor's degree in Computer Science, Information Systems, or related field
REQUIRED SKILLS & EXPERIENCE:
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 SKILLS:
Experience in cloud data platforms (AWS, Azure, Google Cloud Platform) and integration with Teradata
Familiarity with BI/reporting tools (Tableau, Power BI, SAP Business Objects, etc.)
Exposure to Agile / DevOps methodologies
ABOUT THE ROLE/JOB DESCRIPTION:
The Client is 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
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Hiring Organization: Rose International
Position Number: 493682
Industry: Government/Staffing
Job Title: Data Warehouse Architect
Job Location: Lansing, MI, USA, 48933
Work Model: Hybrid
Work Model Details: Position will be hybrid, in office 2 days a week (
Shift: Regular
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 13
Min Hourly Rate($): 85.00
Max Hourly Rate($): 95.00
Must Have Skills/Attributes: Data Modeling, Data Warehouse, ERWIN, Teradata
Experience Desired: Experience in cloud data platforms (AWS, Azure, Google Cloud Platform) and integration with Teradata (2 yrs); Familiarity with BI/reporting tools (Tableau, Power BI, SAP Business Objects, etc.) (2 yrs); Exposure to Agile / DevOps methodologies (2 yrs)
Required Minimum Education: Bachelor's Degree
**C2C is not available**
Job Description
REQUIRED EDUCATION:
Bachelor's degree in Computer Science, Information Systems, or related field
REQUIRED SKILLS & EXPERIENCE:
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 SKILLS:
Experience in cloud data platforms (AWS, Azure, Google Cloud Platform) and integration with Teradata
Familiarity with BI/reporting tools (Tableau, Power BI, SAP Business Objects, etc.)
Exposure to Agile / DevOps methodologies
ABOUT THE ROLE/JOB DESCRIPTION:
The Client is 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
- **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.