Data Warehouse Architect (local to MI)

Data Warehouse Architect

Location

Lansing, Michigan (Hybrid)

Duration

3 Months Contract (Possible Extension)

Work Schedule

Hybrid Schedule (Non-Negotiable)

• Onsite: Wednesday & Thursday
• Remote: Monday, Tuesday & Friday

Candidates must be local to the Lansing, MI area within 90 miles at the time of submission.

Job Summary

We are seeking an experienced Data Warehouse Architect to support enterprise-level data warehouse operations, batch processing frameworks, data integration, and system security initiatives. The ideal candidate will have deep expertise in Teradata, Linux environments, ETL support, and enterprise data warehouse architecture.

This role requires a strong technical leader who can work independently, collaborate with cross-functional teams, and provide guidance on troubleshooting, batch support, data security, and system optimization.

Key Responsibilities

• Manage and support enterprise Data Warehouse environments and batch processing frameworks.
• Support data loading and integration from multiple source systems.
• Oversee code promotion processes, DDL deployments, and change management activities.
• Manage and maintain Linux-based ETL server security structures and user access controls.
• Administer and support Teradata security and access management.
• Troubleshoot and resolve escalated data warehouse and batch processing issues.
• Conduct data architecture reviews and ensure compliance with enterprise standards.
• Monitor system performance and recommend improvements for scalability and reliability.
• Support ETL workflows and enterprise data integration processes.
• Develop and maintain data quality validation and cleansing processes.
• Create and maintain technical documentation, architecture diagrams, and operational procedures.
• Participate in disaster recovery planning, backup strategies, and system maintenance activities.
• Support migration efforts toward standardized enterprise frameworks and processes.
• Collaborate with developers, leadership teams, stakeholders, and vendor partners.

Required Skills & Qualifications

• 8 years of Teradata experience (Required)
• Strong experience supporting data loading from multiple source systems
• Minimum 5 years of Linux experience
• Strong knowledge of ETL workflows, batch scheduling, and troubleshooting
• Experience with data warehouse architecture and enterprise data environments
• Strong understanding of security models, user access controls, and audit compliance
• Experience with code deployment, change management, and build support processes
• Excellent troubleshooting, analytical, and problem-solving skills
• Strong communication and collaboration abilities
• Ability to work independently and within team environments

Preferred Qualifications

• Previous government or public sector experience
• Experience with cloud-based BI and analytics tools
• Exposure to enterprise data governance and data quality initiatives

Desired Skills

• Teradata SQL
• Linux Administration Support
• ETL & Data Integration
• Batch Framework & Scheduling
• Data Quality & Profiling
• Security & Access Management
• Performance Monitoring & Optimization
• Disaster Recovery & Backup Strategies
• Cloud BI Tools

Interview Process

• 60-minute Virtual Interview via MS Teams
• Video participation required
• Candidates should join using a laptop and be prepared for screen sharing if requested

Additional Information

• Collaborative and established technical team environment
• Opportunity to work on large-scale enterprise data warehouse initiatives
• Long-term project potential based on performance and business needs