Quick overview
SeniorityMid Senior
Work modeHybrid
LocationUnited States
SQLShellAWSETLSnowflakeCapacity PlanningDatabricksGoogle CloudAzureLinux
Job description
Job Title: Teradata Architect (Data Warehousing)
Location: Remote
Primary skills: Teradata Architecture, Enterprise Data Warehousing, Data Modeling, Teradata SQL, Performance Tuning
skills: Teradata Vantage, BTEQ, TPT, Informatica / DataStage, Unix/Linux Shell Scripting, AWS, Azure, Google Cloud Platform, Snowflake / Databricks Migration
Experience: 12+ Years of Experience in Data Engineering, Data Modeling/Data Warehousing and 8+ years in Teradata.
About the job:
We are seeking a highly skilled Architect with deep expertise in Teradata Data Warehousing and Data Modeling. The successful candidate will own the architecture, design, and performance of Teradata-based enterprise data platforms, and guide teams on modernization and migration to cloud data platforms where required.
Responsibilities
- Define and own the architecture of Teradata enterprise data warehouses, including logical and physical data models, layered data architecture, and integration patterns.
- Lead performance tuning and optimization, including Primary Index and Partitioned Primary Index (PPI) design, join indexes, statistics collection, and query optimization.
- Design and govern ETL/ELT frameworks using BTEQ, TPT, FastLoad, MultiLoad, and tools such as Informatica or DataStage.
- Manage workload management, capacity planning, space management, security, and role-based access on Teradata systems.
- Assess existing Teradata workloads and define modernization and migration strategies to cloud platforms such as Snowflake, Databricks, and Teradata Vantage on cloud.
- Establish development standards, code reviews, and best practices, and mentor Teradata developers.
- Collaborate with business and technology stakeholders to translate requirements into scalable data solutions.
Requirements - Must Have
- 12+ years of experience in Data Modeling/Data Warehousing.
- 8+ years of experience in Teradata architecture and design, including PI/PPI design, indexing strategies, and workload management.
- Expert in Teradata SQL, query tuning, and Teradata utilities (BTEQ, TPT, FastLoad, MultiLoad, FastExport).
- Hands-on experience with ETL/ELT tools such as Informatica or DataStage, and Unix/Linux shell scripting.
- Experience with cloud platforms like AWS, Azure, and Google Cloud Platform, and migrating Teradata workloads to cloud data platforms.
- Knowledge of Teradata security, capacity planning, and system monitoring using Viewpoint.
Similar jobs
- BO
Aerospace Systems Safety Engineer (Associate, Experienced, Senio with Security ClearanceRecently posted
Boeing · Hazelwood, MO · Hybrid · Posted 17 Nov 2026 🇺🇸
Technology$88.4k - $119.6k/yr - BO
Software Engineer, Missile Defense National Team, C2BMC (Associa with Security ClearanceRecently posted
Boeing · Colorado Springs, CO · On-site · Posted 17 Nov 2026 🇺🇸
MicroservicesOracleSQL+5Technology$99.5k - $134.6k/yr - BO
Lead Software Integration Engineer with Security ClearanceRecently posted
Boeing · Berkeley, MO · Hybrid · Posted 17 Nov 2026 🇺🇸
Technology$198.1k - $267.9k/yr - AS
Business Systems AnalystRecently posted
Apex Systems · San Antonio, TX · Hybrid · Posted 17 Nov 2026 🇺🇸
Stakeholder ManagementSQLMicrosoft Office+9TechnologySalary not listed - AS
Technical Architect - Architecture & Technology Governance (ATG)Recently posted
Apex Systems · Southlake, TX · On-site · Posted 17 Nov 2026 🇺🇸
Continuous ImprovementPortfolio ManagementTechnologySalary not listed - MW
Service Now DeveloperRecently posted
Mind Ware Inc · Minneapolis, MN · Hybrid · Posted 17 Nov 2026 🇺🇸
OAuthActive DirectoryCSS+5TechnologySalary not listed - AS
Data Center Deployment LeadRecently posted
Apex Systems · Pryor, OK · On-site · Posted 17 Nov 2026 🇺🇸
Project ManagementTechnologySalary not listed - BO
Mission Systems Software Chief Architect with Security ClearanceRecently posted
Boeing · Berkeley, MO · On-site · Posted 17 Nov 2026 🇺🇸
C#C++Java+3Technology$177.7k - $240.3k/yr - BO
Senior Systems Engineer - Seeker Testing - Patriot Advanced Capa with Security ClearanceRecently posted
Boeing · Huntsville, AL · Hybrid · Posted 17 Nov 2026 🇺🇸
Technology$136.8k - $185.2k/yr - BO
Optical Systems Engineer (Mid-Career) - Millennium Space Systems with Security ClearanceRecently posted
Boeing · El Segundo, CA · Hybrid · Posted 17 Nov 2026 🇺🇸
AgileTechnology$99k - $177k/yr - TE

Wireless Software EngineerRecently posted
Tata Elxsi Limited · Austin, TX · Hybrid · Posted 17 Nov 2026 🇺🇸
AWS5GC+++2Technology$70/hr - QT

AI EngineerRecently posted
QUANTUM TECHNOLOGIES LLC · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
MicroservicesNLPC#+11Technology$80 - $90/hr