Senior EDW Data Architect
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior EDW Data Architect designing Teradata enterprise data warehouses for regulated banking clients. Leading governance, data modelling, SQL validation, and delivery support in a remote EU contract.
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, domains, engineers, testers, delivery leads, and peer architects
- Assess design options and recommend pragmatic, scalable, standards-aligned solutions
- Produce and maintain 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
- Embed data governance, metadata, lineage, controls, reconciliation, auditability, privacy, and regulatory compliance into solution design
- Support metadata-driven delivery frameworks
- Support delivery teams through build, testing, implementation, and issue resolution
- Work approximately 50% hands-on on SQL investigation, detailed data analysis, solution validation, and delivery support
Requirements:
- 8+ years' experience in data engineering and architecture
- 5+ years in data architecture, as a Data Architect or senior Data Engineering Lead with demonstrable architecture ownership
- Strong hands-on Teradata experience in an on-premises EDW environment
- Advanced Teradata SQL querying, data investigation, issue analysis, and technical validation
- Practical experience with the Teradata Financial Services Data Model or 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 BCBS 239, RDARR, regulatory reporting, data traceability, auditability, and evidence-based control design
- Strong data analysis and data modelling skills
- Proven ability to produce governance-ready HLDs and ADDs and present them to Architecture Boards
- Strong stakeholder management, independent ownership, constructive challenge, and decision-driving ability
- Mandatory: Teradata on-prem EDW and advanced SQL
- Mandatory: Teradata FSDM or equivalent financial services data model
- Mandatory: Inmon-style integrated EDW architecture
- Experience with ETL delivery processes and tools, ideally Informatica and/or DataStage
- Experience with metadata-driven ingestion, transformation, control, and reconciliation frameworks
- Experience with Control-M or comparable batch scheduling and orchestration tools
- Nice to have: Teradata Global Control Framework or similar control framework
- Nice to have: Cloudera or comparable big data platforms
- Nice to have: modern hybrid warehouse/lake architecture patterns
- Nice to have: data observability, operational resilience, and production support experience
- Nice to have: broader hands-on data engineering background
Benefits:
- Long-term contract-based role
- Contract through December 2026 with extension to 2027
- Remote-first work arrangement
- Occasional on-site participation in client workshops
Similar Jobs
Data Engineer – Mid-Level
Mid-level Data Engineer building AI/ML data systems for Ignite Digital’s national security and Navy IT clients. Designing pipelines, models, dashboards, and integrations using Python, SQL, and QLIK Advana.
Senior Data Platform Engineer
Senior Data Platform Engineer building DEFCON AI’s durable, explainable data platform for resilient optimization. Preserving provenance, uncertainty, source disagreements, and point-in-time entity histories.
Senior Data Engineer
Senior Data Engineer designing banking data pipelines across AWS, Oracle, Airflow, dbt, and SAP. Modernizing legacy systems through Data Mesh and Medallion architectures.
Senior Data Engineer
Senior Data Engineer building BigQuery and Dataform pipelines for Avenga, an AI-focused international engineering firm. Migrating ETL workflows and modernizing analytics across cloud and on-premises systems.
Senior Data Engineer – Clinical Platforms, Databricks
Senior Data Engineer building Databricks-based clinical trial platforms at Muttdata. Designing compliant lakehouse pipelines and integrations for regulated clinical data.
Senior Big Data Architect
Senior Big Data Architect designing Cloudera, Kafka, and AWS data platforms for banking clients. Leading enterprise-scale streaming, integration, governance, and architecture standards.
Data Architect – Microsoft Fabric
Microsoft Fabric Data Architect designing secure enterprise data platforms for Argano, a digital consultancy. Leading Fabric landing zones, analytics, governance, and generative AI architecture.
Senior Data Platform Engineer, Enterprise Merchant Integrations
Senior Data Platform Engineer building reliable AWS merchant integrations for Extend’s AI-driven post-purchase retail platform. Developing event-driven data systems, onboarding tooling, and error reporting.
Senior Data Engineer
Senior Data Engineer building ingestion, data quality, and graph infrastructure for Inflect’s digital infrastructure marketplace. Scaling InfraSpec and RouteFinder platforms across global teams.
Data Engineer – Reporting & Analytics
Data Engineer modernizing enterprise reporting and analytics for a global technology team. Building Tableau solutions, SQL datasets, pipelines, and cloud data platforms.
Software Engineer – Research Data Platform
Software Engineer building scalable data systems and APIs for Bioptimus’s universal biology AI foundation model. Optimizing storage, databases, and infrastructure for research and product teams.
Data Engineer, Snowflake
Senior Backend/Data Engineer building scalable Python, Django, and Snowflake data platforms. Supporting Addepto’s AI consulting and data engineering solutions for global enterprises and startups.
Master’s Scholarship Fellow, Data Engineering
Bolsista de mestrado pesquisando timelines inteligentes, eventos temporais e engenharia de dados para o Itaú. Desenvolvendo arquiteturas e protótipos de contexto para oportunidades baseadas em eventos.
Master’s Scholarship Researcher – Customer Timeline, Temporal Events, Data Engineering
Master’s researcher developing temporal data and event-driven architectures for Itaú’s intelligent customer timeline. Supporting prototypes for event-based opportunities and customer journeys.
Senior AI/Data Engineer, Data Platforms, Machine Learning, Applied AI
Senior AI/Data Engineer leading Azure data platforms, machine learning, and LLM applications. Delivering secure, governed solutions for federal agencies and other clients.
AI/Data Engineer, Mid-Level – Python, Azure Data, ML Pipelines
AI/Data Engineer building Python ETL workflows, Azure data services, and ML-ready infrastructure. Supporting federal and regulated clients with scalable, governed data platforms.
Software Developer, Data Engineer
Software Developer & Data Engineer building WISEcode’s food intelligence lakehouse. Designing ingestion, entity resolution, and data pipelines powering food decisions.
Data Engineer, AI & Analytics
Data Engineer building unified, AI-ready marketing data foundations for Power Digital, an AI-native growth firm. Owning ingestion, dbt modeling, semantic layers, and production pipelines.
Lead Data Engineer
Lead Data Engineer directing Microsoft Fabric, Python, and PySpark data engagements for CreateFuture, an AI-native consulting partner. Leading teams, architecture, pipelines, and client delivery.
Senior Data Operations Engineer
Senior Data Operations Engineer managing Snowflake health, performance, and costs for Anvilogic’s AI cybersecurity platform. Onboarding customers and supporting Snowflake and Databricks production environments.