# 267-8 Data Warehouse Architect

**Company:** [Stafford Gray](http://jobs.workable.com/companies/ijubpNRZg1hKDHZC9ns8cE.md)
**Location:** Lansing, United States
**Workplace:** hybrid
**Employment type:** Contract

[Apply for this job](http://jobs.workable.com/view/6b49dbb5-feae-4a6c-bace-454c6d46c528)

## Description

Stafford Gray is seeking a senior-level **Data Warehouse Architect** to join an established, collaborative enterprise data warehouse team. This is a hands-on architecture and operations role for a Teradata expert who can step in and contribute immediately alongside a small, tenured team of internal staff and long-term contractors.

You'll own the technical backbone that keeps critical business data current and reliable: batch processing, change management, security, and data quality across the enterprise data warehouse.

### What You'll Do

-   Manage the complex Common Batch Framework and Common Scheduler to ensure current, reliable data is available for critical business processes and decision-making
-   Own Data Warehouse change management infrastructure, including all code and DDL promotions — performing build engineer tasks for both manual and automated promotion processes
-   Administer the Linux security model on DW ETL servers — authorizing user access to groups and sudo privileges (servers themselves are administered by a separate infrastructure team)
-   Manage Teradata security and access
-   Conduct data architecture reviews and audits to ensure alignment with enterprise standards
-   Create and maintain comprehensive documentation of data architecture, processes, and solutions
-   Provide escalated troubleshooting and resolution support for Data Warehouse issues
-   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 data integration processes, including ETL workflows across multiple systems
-   Collaborate with external vendors and third-party service providers as needed
-   Support patch management, system upgrades, and ongoing system maintenance
-   Monitor system performance and troubleshoot technical issues across data platforms
-   Perform data profiling and implement data quality rules for assessment and validation
-   Execute data cleansing and standardization using built-in and custom data rules
-   Develop and maintain disaster recovery and backup strategies for data systems
-   Lead migration of data warehouse processes to standardized/common frameworks
-   Conduct elevated access reviews and user audits to ensure compliance
-   Identify and remediate audit findings related to data systems and security

## Requirements

### Required Qualifications

-   **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 of 5 years of Linux experience**
-   Proven ability to work both independently and collaboratively within a team environment
-   Strong decision-making skills, with the ability to determine appropriate solutions while adhering to organizational and regulatory policies
-   Strong problem-solving and analytical thinking skills, particularly in troubleshooting complex data and system issues
-   Strong communication skills, with the ability to translate complex technical concepts to both technical and non-technical stakeholders

### Preferred Qualifications

-   Previous government or public-sector experience
-   Experience with cloud-based BI tools
-   Experience with cloud-native platforms (AWS, GCP, or Azure)