Teradata Solution Architect

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)

Skills

ETL/ELT development
Teradata
TPT
BTEQ
enterprise data warehouse
Teradata architecture
query optimization
indexing
workload management

Job Details

Job Title: Teradata Solution Architect

Mode: Contract

Locations: San Francisco/Dallas (Day1 onsite)

Must have at least 15yrs plus as Solution Architect with Teradata experience

VISA independent candidates required

Job Summary:

We are seeking for skilled and experienced Teradata Solution Architect and with a strong background on ETL/ELT development. You will be responsible for playing a strategic role in designing, implementing and maintaining scalable, high-performance data solutions using Teradata technologies. This role involves working closely with business stakeholders, data engineers, and IT teams to architect data platforms that support analytics, reporting, and decision-making across the enterprise.

Must Have Experience:
1. Teradata experience as a Solution Architect
2. Strong background on ETL/ELT development
3. Experience in playing strategic role in designing, implementing and maintaining scalable, high-performance data solutions using Teradata technologies.
4. Experience in working closely with Business stakeholders, data engineers, and IT Teams to architect data platforms that support analytics, reporting, and decision-making across the enterprise.
5. Experience with TPT, BTEQ, FastLoad, MultiLoad, Teradata utilities

Key Responsibilities:

Solution Design & Architecture

  • Lead the design and architecture of enterprise data warehouse solutions using Teradata.
  • Define data models, integration strategies, and performance optimization techniques.
  • Translate business requirements into technical specifications and architecture blueprints.
  • Ensure solutions align with enterprise architecture standards and best practices
  • Deep expertise in Teradata architecture, utilities (TPT, BTEQ, FastLoad, MultiLoad), and SQL
  • Strong understanding of data warehousing concepts, dimensional modeling, and ETL/ELT processes.

Technical Leadership

  • Provide technical guidance to development and operations teams on Teradata technologies.
  • Evaluate emerging technologies and recommend adoption strategies.
  • Conduct architecture reviews and ensure adherence to design principles.

Stakeholder Collaboration

  • Work with business analysts, data scientists, and executives to understand data needs.
  • Present architectural solutions and roadmaps to stakeholders and leadership.
  • Collaborate with cross-functional teams to ensure seamless integration of data systems.

Performance & Scalability

  • Design solutions that ensure high availability, scalability, and performance.
  • Implement best practices for query optimization, indexing, and workload management.
  • Monitor system performance and recommend improvements.

Governance & Security

  • Define data governance frameworks and ensure compliance with regulatory requirements.
  • Architect secure data environments with appropriate access controls and encryption.
  • Support audit and compliance initiatives related to data architecture.

Project Management & Delivery

  • Lead architecture efforts in large-scale data projects and migrations.
  • Develop project plans, timelines, and resource estimates for architecture deliverables.
  • Ensure timely delivery of architectural components and documentation.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.