Senior Data Architect

SearchWorks; Dublin; On-site; EUR 110,000 - 140,000; Full time

Job summary

SearchWorks in Ireland is seeking a Senior Data Warehouse Architect to join the Data Solutions team on a 12-month contract with possible extension. You will design, build and optimise end-to-end data warehouse and ELT solutions across Snowflake, AWS and DBT, collaborating with engineering, analytics and platform teams.

The role suits an experienced Data Engineer / Data Warehouse Engineer who thrives on solving complex data challenges and working with modern data architectures at enterprise scale.

Qualifications

• 7+ years in enterprise data engineering or data warehouse environments.
• Strong hands-on SQL experience.
• Strong hands-on DBT experience, or modernising traditional ETL.
• Strong Snowflake experience, including performance and query optimisation.
• Solid end-to-end data ingestion, ELT and transformation knowledge.
• Knowledge of Kimball, Inmon and/or Data Vault modelling.
• Experience with AWS data platforms.
• Understanding of data quality, governance and security.
• Ability to work with both technical and non-technical stakeholders.

Responsibilities

• Design and implement data warehouse and ELT architectures, including data flows, ingestion and transformation patterns.
• Build, maintain and optimise scalable data pipelines across warehouse layers.
• Develop, test and document DBT models across staging, intermediate and marts.
• Design and implement data models using Kimball, Inmon and/or Data Vault methodologies.
• Work with Snowflake, including query optimisation and performance tuning.
• Build and support cloud data solutions across AWS (S3, EMR/PySpark, Lambda, MWAA).
• Improve data quality, governance, security, lineage and reliability across the lifecycle.
• Troubleshoot production issues and ensure observability and platform performance.
• Collaborate with analytics, engineering and platform teams to set data warehouse best practices.
• Contribute to CI/CD and Infrastructure-as-Code initiatives.

Skills

7+ years

SQL

DBT

Snowflake

AWS

Data modelling

ELT/ETL

Data governance

Stakeholders

Tools

Snowflake

AWS

Job description

12 months contract with possible extension

Our client is a leading global payments and financial technology company, looking for a Senior Data Warehouse Architect to join a growing Data Solutions team, working on modern enterprise data platforms across DBT, Snowflake and AWS.

This is a hands‑on opportunity to design, build and optimize end‑to‑end data warehouse and ELT solutions, working closely with engineering, analytics and platform teams.

The role would suit an experienced Data Engineer / Data Warehouse Engineer who enjoys solving complex data challenges and wants to work with modern data architecture at enterprise scale.

What You'll Be Doing

• Design and implement data warehouse and ELT architectures, including data flows, ingestion and transformation patterns.
• Build, maintain and optimise scalable data pipelines across warehouse layers.
• Develop, test and document DBT models across staging, intermediate and marts.
• Design and implement data models using Kimball, Inmon and/or Data Vault methodologies.
• Work extensively with Snowflake, including query optimisation, performance tuning and warehouse/resource optimisation.
• Build and support cloud data solutions across AWS, including services such as S3, EMR/PySpark, Lambda and MWAA.
• Improve data quality, governance, security, lineage and reliability across the data lifecycle.
• Troubleshoot production issues and ensure strong observability and platform performance.
• Work with analytics, engineering and platform teams to establish data warehouse and transformation best practices.
• Contribute to CI/CD, Infrastructure-as-Code and continuous improvement initiatives.

What We're Looking For

• 7+ years' experience in enterprise data engineering / data warehouse environments.
• Strong hands‑on SQL experience.
• Strong hands‑on DBT experience, or significant experience with modernising traditional ETL environments.
• Strong Snowflake experience, ideally including performance and query optimisation.
• Solid understanding of end‑to‑end data ingestion, ELT and transformation.
• Strong knowledge of data modelling – Kimball, Inmon and/or Data Vault.
• Good experience working with AWS data platforms.
• Strong understanding of data quality, governance and security.
• Comfortable working across technical and non‑technical stakeholders.

Nice to Have

• PySpark / EMR
• Kafka / real‑time streaming
• StreamSets
• Terraform / Infrastructure-as-Code
• CI/CD
• Application Performance Monitoring
• AI-empowered development

Why Join?

• Deepen your expertise across DBT, Snowflake and AWS.
• Take ownership of data architecture, modelling and transformation rather than just individual pipelines.
• Work alongside engineering, analytics and platform specialists.
• Exposure to modern data technologies and AI-enabled ways of working.
• Opportunity to make a tangible impact on data quality, performance and reliability across the organization.

Ideal Candidate

• Is genuinely hands‑on with DBT, SQL and Snowflake.
• Can explain a data warehouse architecture they have personally designed and delivered.
• Understands how data moves from ingestion transformation modelling warehouse consumption.
• Can troubleshoot and optimise production data platforms, not just design them.
• Enjoys working in a fast‑moving environment and taking ownership of complex technical problems.

What's in it for you:

Opportunity to Join a global payments & fintech leader & make a difference across a large-scale data transformation programme.