Quick overview
Job description
Teradata Architect
Location: Barrington, RI or Remote
Duration: Long Term
Visa: or EAD's
Skills:
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.
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.
Similar jobs
- TT
Senior Databricks Data ArchitectRecently posted
Tbright Technologies · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLGitApache Spark+9TechnologySalary not listed - CY

Lead Data Architect – Snowflake & Payments (BFSI) | Atlanta GA – 30326 (Hybrid)—Locals OnlyRecently posted
Cyberobotix · Atlanta, GA · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLAWSPCI DSS+5TechnologySalary not listed - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Schertz, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Converse, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · San Antonio, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Universal City, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · New Braunfels, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Seguin, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Mc Lean, Virginia · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Arlington, Virginia · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - AI

Data Platform Principal Architect, Seattle/San FranciscoRecently posted Auto Apply
Airwallex · US - Seattle · Hybrid · Posted 16 Nov 2026 🇺🇸
ComplianceDatabricksKafka+3Salary not listed - NG

Senior Data ArchitectRecently posted Auto Apply
Nimble Gravity · LATAM (Remote) · Remote · Posted 15 Nov 2026 🇺🇸
SQLApache SparkCompliance+7TechnologySalary not listed
