Data Warehouse Architect 5

Job Title: Data Warehouse Architect 5
Location: Lansing, MI (Hybrid Onsite Wednesdays & Thursdays)

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.

Top Skills & Years of Experience

• 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

Preferred Skills

• Previous Government or State experience
• Experience with cloud-based BI tools
• Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform

Job Responsibilities

• 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.

Required Qualifications

• 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.

Preferred Qualifications

• Government or State experience.
• Experience with cloud-based BI tools.
• Experience with AWS, Azure, or Google Cloud Platform.

Additional Notes

• 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.