What are the responsibilities and job description for the Data Warehouse Architect 5 position at Staffactory?
About the Role
We are seeking an experienced Data Warehouse Architect / Data Modeler to support the State of Michigan. This role focuses on designing, developing, and maintaining large-scale data warehouse models using Teradata and ERwin. The ideal candidate has strong technical expertise, excellent communication skills, and the ability to collaborate with cross-functional teams.
This is a hybrid role. Candidates must live within 2 hours of Lansing, MI and be able to report onsite two (2) days per week. Remote-only work is not permitted.
Work Authorization Requirement (Policy-Compliant)
Candidates must be authorized to work in the United States without sponsorship now or in the future (such as U.S. Citizens or Green Card holders).
We are unable to consider candidates requiring sponsorship.
Key Responsibilities
- Design, develop, and maintain logical and physical data models for Teradata data warehouses and data marts
- Use ERwin Data Modeler / ERwin Model Mart to build and update data models, metadata, and data dictionaries
- Translate business requirements into efficient database structures
- Ensure alignment between data models and ETL processes
- Perform data profiling, analysis, and impact assessments
- Optimize data structures for performance and scalability
- Support data governance and metadata standards
- Participate in design reviews and data quality assessments
- Provide documentation and assist production/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 hands-on experience with Teradata databases and architecture
- Expertise in ERwin Model Mart
- Strong SQL skills and understanding of database performance tuning
- Experience with data governance, metadata management, and ETL concepts
- Strong verbal and written communication skills
Preferred Qualifications
- Experience with cloud platforms (AWS, Azure, or GCP)
- Familiarity with BI/reporting tools (Power BI, Tableau, Business Objects, etc.)
- Exposure to Agile/DevOps methodologies
Additional Requirements
- Must be able to work hybrid onsite (2 days/week) in Lansing, MI
- Only resumes 4–5 pages maximum will be accepted
- Candidate photo screenshot may be required for interview identity verification
- Right to Represent and required cover sheet must be completed prior to submission
Pay: $60.00 - $70.00 per hour
Application Question(s):
- How many years of experience do you have in data modeling for large-scale data warehouse environments?
- Do you have experience working with cloud platforms (AWS, Azure, or GCP)?
Experience:
- Teradata databases and architecture: 5 years (Required)
- ERwin Data Modeler / ERwin Model Mart: 5 years (Preferred)
Location:
- Lansing, MI 48910 (Required)
Work Location: Hybrid remote in Lansing, MI 48910
Salary : $60 - $70
