What are the responsibilities and job description for the Data Warehouse Architect position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Rose International, is seeking the following. Apply via Dice today!
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
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.).
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
- **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.**
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.).
Data Warehouse Architect 5
Global Information Technology -
Lansing, MI
Data Warehouse Architect(Teradata
US IT Solutions Inc -
Lansing, MI
Data Warehouse Architect 5
Staffactory -
Lansing, MI