Senior EDW Architect - Teradata & Financial Services

E-Solutions; Dublin; On-site; EUR 120,000 - 160,000; Full time

Job summary

E-Solutions in Ireland is seeking a hands-on Senior Data Architect to drive enterprise data warehouse delivery within a banking/financial services environment. You will lead Teradata SQL analysis, data modelling, and governance-focused design, working with stakeholders across IT and the business.

The role requires substantial hands-on architecture work, including developing HLDs/ADDs and presenting options to governance boards. Strong experience in regulatory data and BCBS 239 is essential.

Qualifications

• 5+ years of Data Architecture experience
• Teradata in an on-premises enterprise data warehouse environment
• Teradata SQL, data analysis, investigation, troubleshooting, and validation
• Experience with Teradata Financial Services Data Model (FSDFM) or equivalent financial services data model
• Understanding of Enterprise Data Warehouse, data marts, data integration, and large-scale data platforms
• Experience in Banking/Financial Services or Regulatory Data environments
• Knowledge of BCBS 239, RDARR, regulatory reporting, data traceability, and data controls
• Data modelling and source data analysis capabilities
• Working knowledge of ETL processes, preferably Informatica and/or DataStage
• Metadata-driven data ingestion, transformation, controls, reconciliation, or delivery frameworks
• Knowledge of Control-M or similar batch scheduling/orchestration tools
• Stakeholder management and governance presentation skills
• Experience producing HLDs, ADDs, and governance-ready architecture documentation
• Understanding of Inmon-style integrated enterprise data warehouse architecture

Responsibilities

• Design and support enterprise data warehouse architecture and solutions
• Analyse source data, data flows, business requirements, and downstream data consumption
• Perform hands-on Teradata SQL analysis, data investigation, and technical validation
• Develop High-Level Designs (HLDs), Architecture Decision Documents (ADDs), solution options, and design rationale
• Present architecture solutions to Architecture Boards and governance forums
• Work closely with business stakeholders, engineers, testers, delivery leads, and other architects
• Embed data governance, metadata, lineage, data quality, reconciliation, controls, auditability, and regulatory compliance into solution design
• Support engineering teams throughout build, testing, implementation, and issue resolution

Skills

Data Architecture

Teradata

Stakeholder Management

Regulatory Knowledge

Data Governance

Data Modelling

ETL Expertise

Solution Validation

Tools

Teradata

Informatica

DataStage

Control-M

Job description

E-Solutions in Ireland is seeking a hands-on Senior Data Architect to drive enterprise data warehouse delivery within a banking/financial services environment. You will lead Teradata SQL analysis, data modelling, and governance-focused design, working with stakeholders across IT and the business.

The role requires substantial hands-on architecture work, including developing HLDs/ADDs and presenting options to governance boards. Strong experience in regulatory data and BCBS 239 is essential.