Senior Data Warehouse Architect (Local to Lansing, MI - Hybrid)

Position: Data Warehouse Architect 5

Location: Lansing, MI (Hybrid)

Duration: Long-Term Contract (Potential Extension)

Interview: Virtual (MS Teams)

Work Schedule: Hybrid (Onsite Wednesdays & Thursdays; Remote Mondays, Tuesdays & Fridays)

Job Summary

We are seeking an experienced Data Warehouse Architect to support enterprise data warehouse operations, data integration, security, and infrastructure. The ideal candidate will have extensive experience with Teradata, Linux, ETL processes, and enterprise data warehouse environments. This role involves maintaining data warehouse platforms, supporting complex batch processing, ensuring data quality and security, troubleshooting production issues, and collaborating with development teams to deliver reliable data solutions.

Key Responsibilities

• Support and maintain enterprise data warehouse environments and batch processing frameworks.
• Manage data warehouse code promotions, deployments, and change management activities.
• Administer data warehouse security, user access, and Linux security structures.
• Support data integration and ETL processes across multiple source systems.
• Troubleshoot and resolve complex production and batch processing issues.
• Conduct data architecture reviews to ensure compliance with enterprise standards.
• Create and maintain technical documentation for data architecture and processes.
• Monitor system performance and recommend improvements for scalability and reliability.
• Implement data quality, profiling, cleansing, and validation processes.
• Support disaster recovery planning, backup strategies, and system maintenance.
• Lead migration efforts to standardized data warehouse frameworks.
• Perform user access reviews and address audit findings related to security and compliance.
• Evaluate and recommend new technologies, cloud platforms, and BI solutions.
• Collaborate with developers, technical teams, stakeholders, and third-party vendors.
• Provide technical guidance and mentoring to development teams.

Required Skills & Qualifications

• 8 years of Teradata experience.
• Strong experience with enterprise Data Warehouse environments.
• Experience loading data from multiple source systems.
• Hands-on ETL and data integration experience.
• Minimum 5 years of Linux experience.
• Experience supporting batch processing and scheduling frameworks.
• Strong SQL skills.
• Experience with data warehouse security and user access management.
• Strong troubleshooting and production support experience.
• Knowledge of data profiling, data quality, and data cleansing techniques.
• Excellent analytical and problem-solving skills.
• Strong written and verbal communication skills.
• Ability to work independently and within a collaborative team environment.

Preferred Skills

• Previous government/public sector experience.
• Experience with cloud-based BI tools.
• Experience with cloud platforms such as AWS, Azure, or GCP.

Additional Information

• Long-term opportunity with potential extensions.
• Hybrid work schedule.
• Candidates should be local to the work location and available to work onsite as required.
• Collaborative team environment supporting enterprise data warehouse initiatives.
• Opportunity to work on large-scale data integration and analytics projects.