Senior Data Warehouse Architect

SearchWorks; Dublin; On-site; EUR 120,000 - 150,000; Full time

Job summary

SearchWorks is seeking a Senior Data Warehouse Architect in Dublin to lead hands-on design and optimisation of modern data platforms. You will own enterprise data warehouse architectures, build Snowflake solutions and dbt models, and collaborate with engineering and analytics teams to set data standards.

We expect 7+ years in data engineering or warehousing, strong SQL/dbt/Snowflake skills, and experience with AWS data services, data modelling and performance tuning.

Qualifications

• 7+ years in Data Engineering, Data Warehousing or Data Architecture.
• Strong SQL, dbt and Snowflake experience.
• Strong data modelling and ELT experience.
• Good understanding of AWS data platforms.
• Experience with performance tuning and production troubleshooting.
• Strong communication and stakeholder management skills.

Responsibilities

• Design and deliver enterprise data warehouse and ELT architectures.
• Build and optimise dbt models, SQL pipelines and Snowflake solutions.
• Develop data models using Kimball, Inmon and/or Data Vault.
• Work across AWS data services including S3, EMR/PySpark, Lambda and MWAA.
• Improve data quality, governance, security, lineage and observability.
• Troubleshoot production issues and optimise platform performance.
• Collaborate with Engineering, Analytics and Platform teams on data architecture standards.

Skills

SQL

dbt

Snowflake

Data modelling

ELT

AWS

Stakeholder management

Communication

Tools

Snowflake

dbt

AWS

S3

EMR/PySpark

Lambda

MWAA

Job description

Contract: 12 months + potential extension

Region: EMEA

Our client is a global payments and fintech organisation looking for a Senior Data Warehouse Architect to join its growing Data Solutions team.

This is a hands-on architecture role focused on building and optimising modern data platforms using Snowflake, dbt and AWS.

Key Responsibilities

• Design and deliver enterprise data warehouse and ELT architectures.
• Build and optimise dbt models, SQL pipelines and Snowflake solutions.
• Develop data models using Kimball, Inmon and/or Data Vault.
• Work across AWS data services including S3, EMR/PySpark, Lambda and MWAA.
• Improve data quality, governance, security, lineage and observability.
• Troubleshoot production issues and optimise platform performance.
• Collaborate with Engineering, Analytics and Platform teams on data architecture standards.

Key Requirements

• 7+ years in Data Engineering, Data Warehousing or Data Architecture.
• Strong SQL, dbt and Snowflake experience.
• Strong data modelling and ELT experience.
• Good understanding of AWS data platforms.
• Experience with performance tuning and production troubleshooting.
• Strong communication and stakeholder management skills.

Nice to Have

Why Join?

• Global payments & fintech environment.
• Hands-on ownership across Snowflake, dbt and AWS.
• Opportunity to influence data architecture and modernisation.