Quick overview
Job description
Title: Teradata Architect
Remote Role
Roles & 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.
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 with migrating Teradata workloads to cloud data platforms.
- Knowledge of Teradata security, capacity planning, and system monitoring using Viewpoint.
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- GI
Databricks ArchitectRecently posted
Georgia IT · United States · Hybrid · Posted 19 Nov 2026 🇺🇸
GitApache SparkAWS+16Salary not listed - TC
Teradata ArchitectRecently posted
Techwave Consulting Inc · United States · On-site · Posted 19 Nov 2026 🇺🇸
SQLShellAWS+7TechnologySalary not listed - BT
Principal Information Architect/Data ArchitectRecently posted
Balin Technologies LLC · United States · Remote · Posted 19 Nov 2026 🇺🇸
OracleSQLETL+6TechnologySalary not listed - TE

Data ModelerRecently posted
TekDallas · San Antonio, TX · On-site · Posted 19 Nov 2026 🇺🇸
Azure$50/hr - IF

Database ArchitectRecently posted
iFusion Inc. · United States · Hybrid · Posted 19 Nov 2026 🇺🇸
WorkdaySalary not listed - TE

Data ArchitectRecently posted
TekDallas · New York, NY · On-site · Posted 18 Nov 2026 🇺🇸
MicroservicesAPI GatewaySnowflake+4TechnologySalary not listed - AV
Data warehouse ArchitectRecently posted
Avacend, Inc. · United States · On-site · Posted 18 Nov 2026 🇺🇸
TechnologySalary not listed - TE

Database ArchitectRecently posted
TechNix LLC · United States · Remote · Posted 18 Nov 2026 🇺🇸
WorkdayCAMERPSalary not listed - SN

Database ArchitectRecently posted
SnapCode Inc · United States · On-site · Posted 18 Nov 2026 🇺🇸
WorkdayERPSalary not listed - NS

Sr Data ArchitectRecently posted
Nava Software Solutions · Dallas, TX · On-site · Posted 18 Nov 2026 🇺🇸
Stakeholder ManagementMongoDBOracle+4TechnologySalary not listed - B&

Senior Database Architect with Security Clearance
Bart & Associates · Washington, DC · On-site · Posted 10 Nov 2026 🇺🇸
AdministrativeSalary not listed - TC

VP, DataRecently posted Auto Apply
Thyme Care · Remote · Remote · Posted 18 Nov 2026 🇺🇸
RecruitingLookerCompliance+6$250.8k - $295k/yr