We are looking for an experienced Data Warehouse Modeler/Data Engineer with strong expertise in Snowflake and dbt to join a leading data transformation programme in EMEA.

You will play a key role in designing and implementing end-to-end data pipelines, data models, and scalable data solutions.

Key Responsibilities

• Design and build ETL/ELT pipelines for data ingestion and transformation
• Perform data mapping from source systems to Snowflake
• Develop conceptual, logical, and physical data models
• Build and maintain dbt models following best practices
• Optimize Snowflake performance (query tuning, clustering, materialization)
• Ensure data quality, governance, and lineage
• Collaborate with engineering and analytics teams

Required Skills

• Strong experience with Snowflake (MANDATORY)
• Hands-on experience with dbt (Core or Cloud)
• Strong SQL and data modelling expertise (Kimball/Data Vault/Inmon)
• Experience in ETL/ELT design and data mapping
• Experience with tools like Informatica/Talend/SSIS/ODI (any)

Nice to Have

• AWS Data Stack (S3, Glue, EMR, PySpark)
• Exposure to modern data architecture/lakehouse concepts

Work Model

• 3 days onsite (Basildon or Dublin)