Data Architect

GemPool Recruitment; Dublin; On-site; EUR 110,000 - 150,000; Full time

Job summary

GemPool Recruitment is seeking a client-facing Data Architect to lead end-to-end design and delivery of data architectures in complex environments at a Dublin city centre consultancy. You will translate business requirements into technical designs and data models, bridging vision and implementation.

The role requires consulting experience (ideally 5+ years) and hands-on work with SQL, data platforms, and integration tools, within Agile or hybrid delivery models.

Qualifications

• 5+ years of experience as a Data Architect in consultancy or large-scale industry.
• Strong SQL proficiency and hands-on with integration tools (ADF, SSIS, Kafka, Talend).
• Experience with data warehouses, lakehouses and platforms like Databricks or Snowflake.
• Ability to manage multiple projects in Agile or hybrid environments.

Responsibilities

• Lead the design of enterprise data architectures for AI, reporting, and analytics.
• Translate client requirements into specific tech stacks.
• Create conceptual, logical, and physical data models (relational and dimensional).
• Embed data governance, quality, and security controls into every design.
• Contribute to bids, tenders, and proposal development for new client offerings.
• Act as IC while mentoring junior teams and future managers.

Skills

Strategic design thinking

Client-facing communication

Mentoring

Tools

SQL

ADF

SSIS

Kafka

Talend

Databricks

Snowflake

Job description

This is a client facing, delivery focused role within a growing Data & AI practice with an established tech consultancy in Dublin city centre. You will lead the end-to-end design and delivery of data architectures in complex environments, ensuring solutions are scalable, secure, and analytics ready.

The ideal candidate is a strategic designer, not a data engineer. You must be able to translate business requirements into technical designs and data models that bridge the gap between vision and implementation.

NOTE: You MUST have consulting experience for this role. Ideally 5+ years working with clients on data architecture solutions.

Key Responsibilities

• Lead the design of enterprise data architectures for AI, reporting, and analytics.
• Work with clients to resolve technical data debt and translate their requirements into specific tech stacks.
• Create conceptual, logical, and physical data models, including relational and dimensional designs.
• Embed data governance, quality, and security controls into every design.
• Contribute to bids, tenders, and proposal development to help shape new client offerings.
• Act as an individual contributor while taking responsibility for career coaching, mentoring, and the technical development of junior teams and future managers.

Required Skills & Experience

• 5+ years of experience as a Data Architect. Background in consultancy or large-scale industry (ideally Financial Services) is preferred.
• Proficiency in SQL and hands-on experience with integration tools such as ADF, SSIS, Kafka, or Talend.
• Experience with data warehouses, lakehouses, and platforms like Databricks or Snowflake.
• Ability to manage multiple projects simultaneously within Agile or hybrid models.

The leadership style in this practice is open, collaborative, and non-micromanaging. You will be given high levels of autonomy within a vision led, structured framework that values honesty and a "big picture" approach to problem-solving.