What are the responsibilities and job description for the Data Warehouse Architect 5 position at Aroha Technologies, Inc?
Job Title: Data Warehouse Architect 5
Location: Lansing, MI (Hybrid Onsite Wednesdays & Thursdays)
No. of Positions: 1
Job Description
Data Warehouse Architect 5
Important Information
Location: Lansing, MI (Hybrid Onsite Wednesdays & Thursdays)
No. of Positions: 1
Job Description
Data Warehouse Architect 5
Important Information
- Resumes should be 4 5 pages.
- Repost of 158705 (Backfill).
- Vendor submissions close on 07/27/2026 at 10:00 AM ET. Late submissions will not be accepted.
- Reason for opening: Backfill; team requires additional support.
- Interview Process: 60-minute Virtual Interview via Microsoft Teams (Video Required).
- Assignment Duration: Ongoing long-term contract with the possibility of extension based on performance and business needs.
- Hybrid Work Schedule (Non-Negotiable):
- Onsite: Wednesdays & Thursdays
- Remote: Mondays, Tuesdays & Fridays
- Candidates must be local to the Lansing, MI area (within 90 miles) at the time of submission.
- 8 years of Teradata experience (Top requirement)
- Experience supporting the loading of data from multiple source systems
- Ability to provide targeted training and technical guidance to development teams for troubleshooting and batch support
- Minimum 5 years of Linux experience
- Proven ability to work independently and collaboratively within a team environment
- Strong decision-making skills while adhering to organizational policies
- Previous Government or State experience
- Experience with cloud-based BI tools
- Experience with cloud platforms such as AWS, Azure, or GCP
- Support complex Common Batch Framework and Common Scheduler to ensure reliable data availability for critical business processes.
- Manage Data Warehouse change management infrastructure and code/DDL promotion processes.
- Maintain Linux security structure on Data Warehouse ETL servers.
- Manage Teradata security and user access.
- Conduct data architecture reviews and audits.
- Create and maintain comprehensive documentation for data architecture and processes.
- Provide support for escalated Data Warehouse issue troubleshooting and resolution.
- Evaluate and recommend new data technologies and tools to improve performance and scalability.
- Ensure data quality, accuracy, and effective use of enterprise data assets.
- Manage and support ETL and data integration across multiple systems.
- Collaborate with external vendors and third-party service providers.
- Support patch management, system upgrades, and maintenance.
- Monitor system performance and troubleshoot technical issues.
- Perform data profiling and implement data quality validation rules.
- Execute data cleansing and standardization activities.
- Develop and maintain disaster recovery and backup strategies.
- Lead migration of Data Warehouse processes to standardized frameworks.
- Conduct elevated access reviews and security audits.
- Identify and remediate audit findings related to data systems and security.
- 8 years of Teradata experience.
- Experience supporting data loading from multiple source systems.
- Ability to provide technical guidance and troubleshooting support.
- Minimum 5 years of Linux experience.
- Strong analytical and problem-solving skills.
- Excellent written and verbal communication skills.
- Ability to explain technical concepts to both technical and non-technical stakeholders.
- Government or State experience.
- Experience with cloud-based BI tools.
- Experience with AWS, Azure, or GCP.
- Team consists of State employees and long-term contractors in a collaborative environment.
- Work closely with developers, leadership, stakeholders, and vendor teams.
- Support enterprise Data Warehouse projects covering Child Support, Child Welfare, Eligibility, and Health Services programs.