Job description
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
Who can apply
The source lists worldwide eligibility. Accepted UTC offsets: UTC-11, UTC-10, UTC-9.5, UTC-9, UTC-8, UTC-7, UTC-6, UTC-5, UTC-4, UTC-3.5, UTC-3, UTC-2, UTC-1, UTC+0, UTC+1, UTC+2, UTC+3, UTC+3.5, UTC+4, UTC+4.5, UTC+5, UTC+5.5, UTC+5.75, UTC+6, UTC+6.5, UTC+7, UTC+8, UTC+8.75, UTC+9, UTC+9.5, UTC+10, UTC+10.5, UTC+11, UTC+12, UTC+12.75, UTC+13, UTC+14. Review the full description for employer-specific work authorization, residency and schedule requirements.