Data Architect

Realtime Recruitment; Dublin; On-site; EUR 129,000 - 203,000; Part time

Job summary

Realtime Recruitment in Ireland seeks an experienced Data Architect to lead the design and governance of a large-scale EDW (Teradata) in a highly regulated financial services environment.

The role involves collaborating with business stakeholders and engineering teams, delivering scalable data architectures, and ensuring regulatory compliance, metadata management, and strong analytics support.

Qualifications

• Minimum 5+ years' experience in Data Architecture, or equivalent experience as a Senior Data Engineering Lead with architecture ownership.
• Strong hands-on experience with Teradata in an on-premises Enterprise Data Warehouse environment.
• Advanced SQL skills with data investigation, issue analysis, and technical validation.
• Practical experience using the Teradata Financial Services Data Model (FSDM) or a comparable financial services data model.
• Knowledge of Enterprise Data Warehousing, Data Integration patterns, and highly regulated environments (Banking/FS).
• Understanding regulatory data requirements BCBS239, RDARR, Regulatory Reporting, Auditability, and control frameworks.
• Strong data analysis and data modelling capability with source-to-target analysis.
• Experience with ETL processes and Informatica / IBM DataStage.
• Metadata-driven ingestion, transformation, reconciliation, control, or data delivery frameworks.

Responsibilities

• Own and support the architecture and design of Enterprise Data Warehouse solutions.
• Analyse source systems, data flows, business requirements, and downstream consumption needs.
• Perform Teradata SQL investigations, technical analysis, and solution validation.
• Collaborate with stakeholders to define and validate solution designs.
• Evaluate architectural options and recommend scalable, governance-aligned solutions.
• Produce architecture deliverables including HLD, design rationale, and governance docs.
• Present proposals to Architecture Boards and governance forums.
• Embed data governance principles including metadata management and regulatory controls.
• Support delivery teams through build, testing, and production resolution.
• Maintain governance-ready architecture documentation.

Skills

Teradata

SQL

Data Architecture

Data Modelling

Data Governance

ETL patterns

Inmon DW

Stakeholder Management

Regulatory Compliance

Architecture Governance

Tools

Informatica

IBM DataStage

Control-M

Job description

Data Architect – Enterprise Data Warehouse (Teradata) Day Rate Contract

We are seeking an experienced Data Architect to join our enterprise data team, supporting the design, delivery, and evolution of a large-scale Enterprise Data Warehouse (EDW) within a highly regulated financial services environment.

This is an excellent opportunity for an experienced Data Architect—or a Senior Data Engineering Lead with demonstrable architecture ownership—to play a key role in shaping enterprise data solutions, driving architectural best practice, and supporting strategic regulatory and business initiatives.

Working closely with business stakeholders, engineering teams, architects, and governance forums, you will be responsible for delivering scalable, pragmatic, and well-governed data architecture solutions.

Key Responsibilities

• Own and support the architecture and design of Enterprise Data Warehouse solutions.
• Analyse source systems, data flows, business requirements, and downstream consumption needs.
• Perform Teradata SQL investigations, technical analysis, and solution validation where required.
• Collaborate with business stakeholders, engineers, testers, delivery leads, and peer architects to define and validate solution designs.
• Evaluate architectural options and recommend pragmatic, scalable, and standards-aligned solutions.
• Produce and maintain architecture deliverables including:
• High Level Design (HLD) documents
• Solution options and design rationale
• Assumptions, risks, and governance documentation
• Present architecture proposals and recommendations to Architecture Boards and governance forums.
• Embed data governance principles including metadata management, lineage, reconciliation, auditability, privacy, regulatory compliance, and controls into solution designs.
• Support delivery teams throughout build, testing, implementation, and production issue resolution.
• Minimum 5+ years' experience in Data Architecture, or equivalent experience as a Senior Data Engineering Lead with architecture ownership.
• Strong hands-on experience working with Teradata in an on-premises Enterprise Data Warehouse environment.
• Advanced SQL skills with proven experience in data investigation, issue analysis, and technical validation.
• Practical experience using the Teradata Financial Services Data Model (FSDM) or a comparable financial services data model.
• Strong knowledge of:
• Enterprise Data Warehousing
• Data Integration patterns
• Previous experience within Banking, Financial Services, or other highly regulated environments.
• Understanding of regulatory data requirements including:
• BCBS239
• RDARR
• Regulatory Reporting
• Auditability
• Evidence-based control frameworks
• Strong data analysis and data modelling capability, including source-to-target analysis and relationship modelling.
• Working knowledge of ETL processes and technologies, ideally Informatica and/or IBM DataStage.
• Experience designing or implementing metadata-driven ingestion, transformation, reconciliation, control, or data delivery frameworks.
• Knowledge of Control-M or similar enterprise scheduling and orchestration tools.
• Excellent stakeholder management skills with experience presenting solutions to senior business stakeholders, Architecture Boards, governance forums, and peer architecture teams.
• Demonstrated ability to produce high-quality governance-ready architecture documentation.
• Strong analytical thinking, sound judgement, and the confidence to challenge constructively while driving decisions to successful outcomes.
• Experience with, or strong appreciation of, an Inmon-style integrated Enterprise Data Warehouse architecture.