Snowflake Data Warehouse Engineer & dbt Architect

Randstad Technologies Recruitment; Essex; On-site; GBP 70,000 - 95,000; Full time

Job summary

Randstad Technologies Recruitment in Basildon (Essex) or Dublin is seeking an experienced Data Warehouse Modeler/Engineer to design and implement end-to-end data integration on Snowflake, using dbt and traditional ETL tools.

You will model staging, integration layers and data marts, optimize queries, ensure data quality and governance, and collaborate with analytics and platform teams to drive data standards.

Qualifications

• 7+ years of data engineering or modeling experience in an enterprise-scale environment.
• Strong SQL skills and practical dbt or ETL tool experience.
• Hands-on Snowflake data engineering expertise.
• Knowledge of Kimball, Inmon, Data Vault modeling.
• Experience with data quality, governance, and query optimization.
• Familiarity with AWS data services (S3, Glue) is a plus.

Responsibilities

• Architect and build ETL/ELT pipelines to support data ingestion, transformation, and consolidation.
• Map source system data into target Snowflake structures effectively.
• Design and maintain conceptual, logical, and physical data models (staging, integration layers, data marts).
• Develop, test, and manage production-ready dbt models adhering to industry best practices.
• Fine‑tune Snowflake performance through efficient query design, materialization strategies and clustering.
• Uphold high standards of data quality, consistency, data lineage, and documentation.
• Partner with analytics, engineering, and platform teams to establish and align on data standards.

Skills

TOAD Data Modeler

Data Modeling

Education

Bachelor's or Master's degree in Computer Science, Data Engineering, or a related technical field

Tools

Snowflake

dbt

Informatica

Talend

ODI

SSIS

Job description

Randstad Technologies Recruitment in Basildon (Essex) or Dublin is seeking an experienced Data Warehouse Modeler/Engineer to design and implement end-to-end data integration on Snowflake, using dbt and traditional ETL tools.

You will model staging, integration layers and data marts, optimize queries, ensure data quality and governance, and collaborate with analytics and platform teams to drive data standards.