Teradata Architect

Jimmy Technologies; United States; Remote; USD 135,000 - 202,000; Full time

Job summary

Jimmy Technologies seeks a Senior Teradata Architect to lead enterprise data warehouse initiatives for a Fortune 500 client. The role blends solution architecture, governance, and hands-on delivery, with roughly 50% time spent on SQL investigation, data analysis and validation.

This remote-first contract position is based in the EU, with occasional on-site workshops. You will collaborate with business stakeholders, engineers and governance boards to design scalable, compliant data solutions and

Qualifications

• 8+ years in data engineering and architecture.
• 5+ years in data architecture ownership.
• Hands-on Teradata in on-prem EDW environments.
• Experience with banking/regulatory data environments.
• Strong SQL debugging and data analysis skills.
• Ability to produce governance artefacts (HLDs, ADDs).

Responsibilities

• Own and support data architecture for enterprise EDW delivery.
• Analyze source data, data flows and business requirements.
• Perform Teradata SQL investigation and technical validation.
• Create architecture artefacts and present to governance boards.
• Embed governance, metadata, lineage, controls, and compliance.
• Support delivery teams through build, testing, and deployment.

Skills

Teradata architecture

SQL investigation

Data analysis

Stakeholder management

Governance

EDW design

Data modelling

Data governance

Regulatory knowledge

Tools

Teradata on-prem

Informatica

DataStage

Control-M

GCFR

Cloudera

Job description

Описание

We are looking for a Senior Teradata Architect for our Fortune 500 client and their banking client. We're looking for a hands-on architect with deep experience designing and delivering enterprise data warehouse solutions on Teradata, ideally within the Teradata Financial Services Data Model and an Inmon-style integrated EDW. The role combines solution architecture, governance, and stakeholder alignment with real hands-on work. Roughly 50% of the role is hands-on: SQL investigation, detailed data analysis, solution validation, and delivery support. This is not a purely strategic architecture position. This is a long-term remote-first contract position in the EU with occasional on-site participation in client workshops.

Задачи

Own and support data architecture design for enterprise data warehouse delivery. Analyse source data, data flows, business requirements, and downstream consumption needs. Perform Teradata SQL investigation, detailed technical analysis, and solution validation. Work with business stakeholders, domains, engineers, testers, delivery leads, and peer architects to resolve queries and align on solution direction. Assess design options and recommend pragmatic, scalable, standards-aligned solutions. Produce and maintain architecture artefacts: High Level Designs, Architecture Design Decisions, solution options, design rationale, assumptions, risks, and governance-ready packs. Present designs and recommendations to Architecture Boards and governance forums to secure alignment and approval. Embed data governance, metadata, lineage, controls, reconciliation, auditability, privacy, and regulatory compliance into solution design, including metadata-driven delivery frameworks. Support delivery teams through build, testing, implementation, and issue resolution.

Work Conditions

Start Date: October Location: Remote in the EU Long-term contract-based role: PO till December 2026 with extension to 2027

Требования

8+ years' experience in data engineering and architecture, including 5+ years in data architecture (as a Data Architect, or as a senior Data Engineering Lead with demonstrable architecture ownership). Strong hands-on Teradata experience in an on-premises EDW environment: SQL querying, data investigation, issue analysis, and technical validation. Practical experience with the Teradata Financial Services Data Model or an equivalent financial services data model. Strong understanding of EDW design, data marts, data integration patterns, and large-scale data platform delivery. Experience in banking, financial services, or regulatory data environments. Knowledge of regulatory data requirements, including BCBS 239, RDARR, regulatory reporting, data traceability, auditability, and evidence-based control design. Strong data analysis and data modelling skills: source data analysis, relationship mapping, and structure definition. Proven ability to produce governance-ready artefacts (HLDs, ADDs) and to present them to Architecture Boards. Strong stakeholder management, independent ownership, and the ability to challenge constructively and drive decisions to resolution. Mandatory Teradata (on-prem EDW), advanced SQL Teradata FSDM or an equivalent financial services data model Inmon-style integrated EDW architecture ETL delivery processes and tools, ideally Informatica and/or DataStage Metadata-driven ingestion, transformation, control, and reconciliation frameworks Control-M or comparable batch scheduling and orchestration tools Teradata Global Control Framework (GCFR) or a similar control framework Cloudera or comparable big data platforms, especially integration with EDW or lake environments Modern hybrid warehouse/lake architecture patterns Data observability, operational resilience, and production support experience Broader hands-on data engineering background.