Data Architect

Korn Ferry; Dublin; On-site; EUR 90,000 - 120,000; Full time

Job summary

Korn Ferry seeks an experienced Data Architect to join a large-scale enterprise data programme in financial services. This hands-on role focuses on designing and delivering enterprise data warehouse solutions, working with engineering, delivery, business and architecture teams.

You will translate business and technical requirements into pragmatic, scalable data architecture, performing detailed data analysis, SQL investigations and supporting delivery through build and testing.

Qualifications

• 5+ years in Data Architecture in enterprise environments.
• Hands-on Teradata in a data warehouse context.
• Strong SQL, data investigation and troubleshooting skills.
• Experience with financial services data models and regulatory needs.
• Knowledge of metadata, lineage, governance and auditability.

Responsibilities

• Own and support design for enterprise data warehouse delivery.
• Analyse source data, data flows and downstream needs.
• Hands-on SQL investigation and solution validation.
• Collaborate with engineers, testers, delivery leads and architects.
• Evaluate options and propose scalable, standards-aligned designs.
• Produce architecture docs: HLDs, decisions, risks, options.
• Present proposals to governance/architecture forums.
• Embed governance, metadata, lineage, controls, auditability, regulatory considerations.
• Support build, testing, implementation and issue resolution.
• Contribute to metadata-driven ingestion and delivery frameworks.

Skills

Data Architecture

Teradata

SQL

Data Modelling

ETL

Informatica

DataStage

Control-M

Stakeholder Mgmt

Inmon DW

Tools

Teradata Studio

SQL Developer

Job description

We are currently seeking an experienced Data Architect to join a large-scale enterprise data programme within the financial services sector.

This is a hands‑on architecture role, suited to someone who enjoys being close to the detail rather than operating purely at a strategic level. You will play a key role in the design and delivery of enterprise data warehouse solutions, working closely with engineering, delivery, business and architecture teams.

The Role

We are currently seeking an experienced Data Architect to join a large-scale enterprise data programme within the financial services sector.

This is a hands‑on architecture role, suited to someone who enjoys being close to the detail rather than operating purely at a strategic level. You will play a key role in the design and delivery of enterprise data warehouse solutions, working closely with engineering, delivery, business and architecture teams.

You will be responsible for supporting data architecture across complex enterprise data environments, translating business and technical requirements into pragmatic, scalable solutions.

The role will involve a significant hands‑on element, including detailed data analysis, SQL investigation, solution validation and supporting delivery teams through build, testing and implementation.

Key Responsibilities

• Own and support data architecture design for enterprise data warehouse delivery.
• Analyse source data, data flows, business requirements and downstream consumption needs.
• Perform hands‑on SQL investigation, technical analysis and solution validation.
• Work closely with business stakeholders, engineers, testers, delivery leads and fellow architects.
• Evaluate design options and recommend pragmatic, scalable and standards‑aligned solutions.
• Produce architecture documentation including High Level Designs, Architecture Design Decisions, solution options, assumptions, risks and design rationale.
• Present architecture proposals and recommendations to governance and architecture forums.
• Embed data governance, metadata, lineage, controls, reconciliation, auditability and regulatory considerations into solution design.
• Support delivery teams throughout build, testing, implementation and issue resolution.
• Contribute to metadata‑driven data ingestion, transformation and delivery frameworks where appropriate.

Essential Experience

• 5+ years' experience in Data Architecture, ideally operating as a Data Architect, or equivalent experience as a senior Data Engineering Lead with demonstrable architecture ownership.
• Strong hands‑on Teradata experience within an enterprise data warehouse environment.
• Excellent SQL, data investigation and technical troubleshooting capabilities.
• Experience with financial services data models, ideally including Teradata Financial Services Data Model (FS-DM) or an equivalent model.
• Strong understanding of enterprise data warehouse architecture, data marts, data integration and large‑scale data platforms.
• Previous experience within banking, financial services or regulatory data environments.
• Understanding of regulatory data requirements, including areas such as BCBS 239, RDARR, regulatory reporting, data traceability and auditability.
• Strong data modelling and analysis skills, including source analysis, relationship mapping and structure definition.
• Experience with ETL delivery processes and tools such as Informatica and/or DataStage.
• Experience designing or implementing metadata-driven ingestion, transformation, control, reconciliation or data delivery frameworks.
• Knowledge of Control-M or comparable batch scheduling/orchestration technologies.
• Strong stakeholder management and communication skills, including experience presenting to architecture or governance forums.
• Ability to produce high-quality architecture documentation and governance artefacts.
• Strong judgement and the confidence to challenge constructively while driving decisions through to resolution.
• Experience with, or a strong understanding of, Inmon‑style enterprise data warehouse architecture.

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