Data Warehouse Architect in Lansing MI Hybrid

Data Warehouse Architect

We are seeking an experienced Data Warehouse Architect to support the Michigan Department. The ideal candidate will have extensive experience with Teradata, Linux, ETL, and enterprise data warehouse environments. This role is responsible for managing data warehouse architecture, security, batch processing, code deployments, ETL workflows, troubleshooting, and ensuring the availability, reliability, and quality of enterprise data supporting critical business operations.

• Design, maintain, and support enterprise Data Warehouse architecture and infrastructure.
• Manage Common Batch Framework and Common Scheduler to ensure reliable data availability.
• Support ETL processes and data loading from multiple source systems.
• Administer Data Warehouse change management, code promotions, and DDL deployments.
• Manage Teradata security, user access, and Linux security structures.
• Provide advanced troubleshooting and technical support for Data Warehouse production issues.
• Conduct data architecture reviews and ensure compliance with enterprise standards.
• Develop and maintain technical documentation for architecture, processes, and solutions.
• Monitor system performance and recommend improvements for scalability and reliability.
• Perform data profiling, validation, cleansing, and quality management activities.
• Support disaster recovery planning, backup strategies, system upgrades, and patch management.
• Collaborate with developers, business stakeholders, vendors, and technical teams.
• Conduct security audits, elevated access reviews, and remediate audit findings.
• Provide technical mentoring, training, and guidance to development teams.

• 8+ years of hands-on experience with Teradata (Required).
• Experience supporting data loading from multiple source systems.
• Strong experience with ETL processes and enterprise data integration.
• Minimum 5 years of Linux administration/support experience.
• Experience troubleshooting batch processing and enterprise data warehouse environments.
• Strong understanding of data architecture, security, and change management.
• Excellent analytical, problem-solving, and decision-making skills.
• Ability to work independently as well as collaboratively within cross-functional teams.
• Strong verbal and written communication skills.

• Previous State of Michigan or government experience.
• Experience with cloud-based BI tools.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Experience supporting enterprise-scale data warehouse modernization initiatives.