Senior Data Architect (Enterprise Data Warehouse)

Softest Consulting Services Ltd; Dublin; On-site; EUR 95,000 - 120,000; Full time

Job summary

Softest Consulting Services Ltd is seeking a senior Data Architect / Data Engineering Lead to own enterprise data warehouse design for a financial services environment. You will analyse source data, data flows and business requirements, guiding architecture decisions with stakeholders and governance boards.

Practical Teradata, data modelling, and regulatory compliance experience are essential. You will drive design rationales, create high-level design artefacts, and ensure data governance and

Qualifications

• Experience designing enterprise data warehouse architectures.
• Hands-on Teradata capability in on-premises data warehouse environments.
• Experience with financial services data models and regulatory data requirements.
• Strong data governance, lineage, and auditability skills.
• Experience engaging with Architecture Boards and governance forums.

Responsibilities

• Own and support enterprise data warehouse architecture design.
• Analyze source data, data flows, and downstream consumption needs.
• Support Teradata SQL investigation and validation.
• Collaborate with stakeholders to align on solution direction.
• Produce governance-ready architecture artefacts and design decisions.
• Present designs to governance forums for alignment and approval.
• Embed governance, metadata, lineage, and regulatory compliance into designs.
• Support delivery teams through build, testing, and deployment.

Skills

Data architecture

Teradata expertise

Data modelling

Governance

Stakeholder management

Inmon DW approach

Regulatory awareness

Tools

Teradata tools

Informatica

DataStage

Control-M

Cloudera

Job description

• Minimum 12+ years of overall experience and 5+ years of relevant data architecture experience, preferably as a Data Architect, or equivalent experience as a senior Data Engineering Lead with demonstrable architecture ownership.
• Strong hands-on Teradata capability within an on-premises enterprise data warehouse environment, including 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 enterprise data warehouse design, data marts, data integration patterns, and large-scale data platform delivery.
• Experience working in banking, financial services, or regulatory data environments.
• Knowledge of regulatory data requirements and compliance expectations, including BCBS239, RDARR, regulatory reporting, data traceability, auditability, and evidence-based control design.
• Strong data analysis and data modelling capability, including source data analysis, relationship mapping, and structure definition.
• Working knowledge of ETL delivery processes and tools, ideally including Informatica and/or DataStage.
• Experience designing or implementing metadata-driven ingestion, transformation, control, reconciliation, or data delivery frameworks.
• Working knowledge of Control-M or comparable batch scheduling and orchestration tools.
• Strong stakeholder management and governance presentation experience across business stakeholders, Architecture Boards, governance forums, delivery leads, and peer architecture teams.
• Proven ability to produce governance-ready architecture artefacts, including High Level Design documents and Architecture Design Decisions.
• Strong judgement, independent ownership, and the ability to challenge constructively while driving pragmatic decisions through to resolution.
• Experience or strong appreciation of an Inmon-style integrated enterprise data warehouse architecture approach.

Additional Industry-Relevant Capabilities

• Data governance by design, including data quality, lineage, controls, reconciliation, auditability, and evidence capture.
• Awareness of operational resilience, data observability, and production support considerations.
• Appreciation of modern data architecture patterns where relevant to hybrid warehouse and lake environments.
• Experience with the Teradata Global Control Framework (GCFR) or similar control framework is an added advantage.
• Appreciation of Cloudera or comparable big data platforms is an added advantage, particularly where integration with enterprise warehouse or lake environments is required.
• Broader hands-on data engineering background, particularly where it supports pragmatic architecture and delivery decision‑making.

What you will do:

• Own and support data architecture design for enterprise data warehouse delivery.
• Analyse source data, data flows, business requirements, and downstream consumption needs.
• Support Teradata SQL investigation, detailed technical analysis, and solution validation where required.
• Work with business stakeholders, domains, engineers, testers, delivery leads, and peer architects to resolve queries and align on solution direction.
• Assess design options rationally and recommend pragmatic, scalable, and standards‑aligned solutions.
• Produce and maintain architecture artefacts such as High Level Design documents, Architecture Design Decisions, solution options, design rationale, assumptions, risks, and governance‑ready packs.
• Present architecture designs, options, and recommendations to Architecture Boards or 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 where appropriate.
• Support delivery teams through build, testing, implementation, and issue resolution.