Senior Teradata Architect

About the role

We are looking for a Senior EDW Data Architect for our Fortune 500 client and their banking client. The role combines solution architecture, governance, and stakeholder alignment with hands‑on work, with roughly 50 % of the time spent on SQL investigation, data analysis and delivery support.

Key responsibilities

• 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.
• Collaborate with business stakeholders, engineers, testers, delivery leads and peer architects to resolve queries and align on solution direction.
• Produce and maintain architecture artefacts such as 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.
• Support delivery teams through build, testing, implementation and issue resolution.

Required profile

• 8+ years of experience in data engineering and architecture, including 5+ years in a data architect or senior data engineering lead role.
• Strong hands‑on experience with Teradata in an on‑premises EDW environment.
• Practical experience with the Teradata Financial Services Data Model or an equivalent financial services data model.
• Deep understanding of EDW design, data marts, data integration patterns and large‑scale data platform delivery.
• Experience in banking, financial services or regulatory data environments, with knowledge of BCBS 239, RDARR and related regulatory reporting requirements.

Required skills

• Teradata (on‑prem) with advanced SQL proficiency.
• Teradata Financial Services Data Model (FSDM) or equivalent.
• Inmon‑style integrated EDW architecture.
• ETL tools such as Informatica and/or DataStage.
• Metadata‑driven ingestion, transformation, control and reconciliation frameworks.
• Control‑M or comparable batch scheduling and orchestration tools.
• Cloudera or comparable big‑data platforms, especially integration with EDW or lake environments.