Senior EDW Data Architect✦ anywhere

We are looking for a Senior EDW Data 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.
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.

-
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

Requirements

-
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.

Technical Requirements
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

Nice to have

-
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

Highlights

If you are passionate about enterprise data warehousing, and banking, this role with our client offers an opportunity to shape critical data platforms in a highly regulated environment!

Originally posted on Himalayas