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)
