EDW Data Architect

Korn Ferry; Dublin; Hybrid; EUR 120,000 - 150,000; Full time

Job summary

Korn Ferry is partnering with a leading financial services organisation to recruit a Senior Data Architect in Dublin. This hands-on role combines solution design, data analysis, stakeholder engagement, and delivery support within a banking data environment.

You will own enterprise DW design, drive data governance and lineage initiatives, and collaborate with delivery teams to ensure scalable, secure data solutions across regulatory programs. Hybrid Dublin location.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or related field.
• 5+ years' experience in Data Architecture or senior Data Engineering Lead with architecture ownership.
• Track record delivering enterprise data warehouse and regulatory data solutions in financial services.

Responsibilities

• Own and lead data architecture design across enterprise data warehouse initiatives, ensuring scalable, secure, and compliant solutions.
• Analyse source systems, data flows, business requirements, and downstream consumption needs to define optimal data solutions.
• Perform hands-on SQL analysis, data investigation, solution validation, and issue resolution within a Teradata environment.
• Produce architecture artefacts including High Level Designs, Architecture Decision Records, solution options, risks, assumptions, and governance documentation.
• Collaborate with business stakeholders, engineers, testers, delivery teams, and architecture forums to drive solution delivery and alignment.
• Embed data governance, lineage, reconciliation, auditability, metadata management, and regulatory controls into solution design.
• Support delivery teams through build, testing, implementation, and production issue resolution.

Skills

Teradata experience

Advanced SQL

Data modeling

Regulatory data

ETL tools

Data governance

Data lineage

Stakeholder management

Architecture design

Banking/FS domain

Education

Bachelor's degree in Computer Science or related

5+ years Data Architecture

Experience delivering enterprise data warehouses in financial services

Tools

Informatica

DataStage

Control-M

Job description

We have partnered with our client, a leading financial services organisation, in their search for a Senior Data Architect to support enterprise data warehouse delivery across large-scale regulatory and business-critical data initiatives. This is a hands-on architecture role, combining solution design, data analysis, stakeholder engagement, and technical delivery support within a complex banking data environment.

Responsibilities

• Own and lead data architecture design across enterprise data warehouse initiatives, ensuring scalable, secure, and compliant solutions.
• Analyse source systems, data flows, business requirements, and downstream consumption needs to define optimal data solutions.
• Perform hands-on SQL analysis, data investigation, solution validation, and issue resolution within a Teradata environment.
• Produce architecture artefacts including High Level Designs, Architecture Decision Records, solution options, risks, assumptions, and governance documentation.
• Collaborate with business stakeholders, engineers, testers, delivery teams, and architecture forums to drive solution delivery and alignment.
• Embed data governance, lineage, reconciliation, auditability, metadata management, and regulatory controls into solution design.
• Support delivery teams through build, testing, implementation, and production issue resolution.

Skills Required

• Strong hands-on Teradata experience, including complex SQL querying, data investigation, technical validation, and enterprise data warehouse delivery.
• Proven experience designing enterprise data warehouses, data marts, data integration solutions, and large-scale data platforms.
• Strong data modelling, data analysis, source-to-target mapping, and data architecture expertise.
• Experience working within banking, financial services, or regulatory data environments.
• Knowledge of regulatory data requirements including BCBS239, RDARR, data traceability, auditability, controls, reconciliation, and regulatory reporting.
• Experience with financial services data models, including Teradata Financial Services Data Model or similar banking frameworks.
• Working knowledge of ETL tools such as Informatica and/or DataStage.
• Experience with metadata-driven ingestion, transformation, control, and reconciliation frameworks.
• Knowledge of Control‑M or similar scheduling and orchestration tools.
• Strong stakeholder management skills with experience presenting solutions to architecture boards, governance forums, and senior business stakeholders.
• Understanding of data governance, lineage, data quality, privacy, operational resilience, and data observability principles.

Education & Work Experience

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related discipline.
• 5+ years' experience in Data Architecture, or as a senior Data Engineering Lead with demonstrable architecture ownership and delivery accountability.
• Track record delivering enterprise data warehouse and regulatory data solutions within financial services environments.

Title: Senior Data Architect

Location: Dublin (Hybrid)

Ref ID

About Korn Ferry

Korn Ferry unleashes potential in people, teams, and organizations. We work with our clients to design optimal organization structures, roles, and responsibilities. We help them hire the right people and advise them on how to reward and motivate their workforce while developing professionals as they navigate and advance their careers. To learn more, please visit Korn Ferry at www.Kornferry.com