Data Warehouse Architect

Senior Data Warehouse Architect Location: Lansing, MI (Hybrid) Pay Rate: $75–$85/hour (W-2) No C2C or Third-Party Candidates Position Overview We are seeking an experienced Senior Data Warehouse Architect to support a large-scale enterprise Data Warehouse environment serving mission-critical business applications. This role is responsible for the architecture, administration, security, and operational support of complex data warehouse platforms, with a strong emphasis on Teradata, Linux, ETL processes, and enterprise data integration. The ideal candidate is a senior-level data professional who can provide technical leadership, troubleshoot complex production issues, improve data quality and performance, and collaborate with development teams to ensure the reliability and scalability of enterprise data solutions. Key Responsibilities Data Warehouse Architecture & Administration • Provide technical leadership for enterprise data warehouse architecture and platform administration. • Support enterprise batch processing frameworks and scheduling processes to ensure reliable delivery of critical business data. • Manage data warehouse change management processes, including code and database object promotions across development environments. • Lead migration efforts toward standardized data warehouse frameworks and processes. • Evaluate emerging technologies and recommend improvements that enhance performance, scalability, and reliability. Data Integration & ETL • Support enterprise ETL workflows and data integration across multiple source systems. • Assist development teams with troubleshooting batch processing and data loading issues. • Monitor and optimize ETL performance and data processing efficiency. • Ensure enterprise data is accurate, timely, and available for business reporting and analytics. Security & Compliance • Administer Linux security structures supporting ETL environments. • Manage Teradata security, user access, and permissions. • Perform elevated access reviews and user audits. • Identify and remediate audit findings related to security and compliance. • Support disaster recovery planning, backup strategies, and business continuity initiatives. Performance & Operations • Monitor system performance and resolve complex production issues. • Perform data profiling, cleansing, validation, and quality assessments. • Support system patching, upgrades, and ongoing platform maintenance. • Collaborate with vendors, infrastructure teams, developers, and business stakeholders to resolve technical challenges. Documentation & Collaboration • Maintain architecture documentation, technical standards, and operational procedures. • Conduct architecture reviews and ensure alignment with enterprise data standards. • Provide mentoring, technical guidance, and knowledge transfer to development teams. • Communicate technical concepts effectively to both technical and non-technical audiences. Required Qualifications • 8+ years of hands-on Teradata experience. • 5+ years of Linux administration or support experience. • Experience supporting enterprise data warehouse environments and ETL processes. • Strong understanding of data integration across multiple source systems. • Experience supporting production batch processing frameworks. • Strong analytical and troubleshooting skills. • Excellent communication and collaboration abilities. • Ability to work independently while contributing effectively within a team environment. Preferred Qualifications • Previous experience supporting large enterprise data warehouse environments. • Experience with cloud-based BI solutions. • Familiarity with AWS, Azure, or Google Cloud Platform. • Experience supporting enterprise-scale analytics platforms. • Knowledge of enterprise security, disaster recovery, and audit processes.