Data Architect Enterprise Data Warehouse

HCLTech; Dublin; On-site; EUR 120,000 - 180,000; Full time

Job summary

HCLTech is seeking a hands-on Senior Data Architect to support enterprise data warehouse delivery in a banking/financial services environment, with strong Teradata and regulatory data capabilities.

The role requires ownership of architecture artefacts, collaboration with multiple stakeholder groups, and delivery accountability. 50% hands-on architecture and 50% leadership across project governance and design decisions.

Qualifications

• Minimum 5+ years of relevant data architecture experience.
• Hands-on Teradata capability in an on-premises enterprise data warehouse environment.
• Experience with Teradata Financial Services Data Model or equivalent.
• Knowledge of enterprise data warehouse design, data marts, data integration patterns.
• Experience in banking/financial services or regulatory data environments.
• Knowledge of regulatory data requirements and compliance (BCBS239, RDARR, governance).
• Strong data analysis and data modelling, including source data analysis and relationship mapping.
• Experience with ETL delivery processes and tools (Informatica/DataStage).
• Experience designing metadata-driven ingestion and data delivery frameworks.
• Experience with batch scheduling/orchestration tools (Control-M).
• Strong governance presentation experience across boards and stakeholders.

Responsibilities

• Own and support data architecture design for enterprise data warehousing delivery.
• Analyse source data, data flows, business requirements and downstream consumption needs.
• Support Teradata SQL investigation, technical analysis, and solution validation.
• Collaborate with stakeholders, engineers, testers, and architects to align on direction.
• Assess design options and recommend pragmatic, scalable solutions.
• Produce and maintain architecture artefacts (HLD, ADDs, design decisions).
• Present designs to Architecture Boards or governance forums for alignment and approval.
• Embed data governance, lineage, controls, reconciliation, and regulatory compliance.
• Support delivery teams through build, testing, and issue resolution.

Skills

Data architecture

Teradata

Data modeling

Stakeholder management

Governance

ETL knowledge

Regulatory data

Inmon modeling

Tools

Informatica

DataStage

Control-M

GCFR

Cloudera

Job description

HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered on digital, engineering and cloud, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of $13+ billion.

For more information on how we process your personal data, please refer to HCLTech' s Candidate Data Privacy Notice.

Candidates who demonstrate hands-on Teradata experience, financial services data knowledge, architecture delivery capability, regulatory awareness, and strong stakeholder engagement.

Senior Data Architect -

Role Purpose

We require a hands-on Senior Data Architect to support enterprise data warehouse delivery within a banking or financial services environment, with strong Teradata, regulatory data, stakeholder management, and solution design capability.

Candidate Profile

The preferred candidate will currently operate as a Data Architect. However, strong Data Engineering Leads may also be considered where they can demonstrate practical architecture ownership, delivery accountability, and successful transition into architecture responsibilities. This is not a purely strategic architecture role; candidates must be comfortable remaining hands-on for approximately 50% of the role, particularly where detailed data analysis, SQL investigation, solution validation, issue resolution, or delivery support is required.

Key Responsibilities

• 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.

Mandatory Requirements

• Minimum 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.