Data Warehouse Modeler/Engineer

Randstad Technologies Recruitment; Basildon; On-site; GBP 90,000 - 120,000; Full time

Job summary

Randstad Technologies Recruitment is seeking a highly skilled Data Warehouse Modeler/Engineer to design and implement end-to-end data integration on Snowflake. You will work on ETL/ELT architecture, data mapping, and dbt development in a fast-paced environment within the EMEA Data Solutions domain.

The role emphasizes data quality, governance, and collaboration with analytics and platform teams to establish robust data standards. On-site in Basildon or Dublin with full-time employment.

Qualifications

• Degree in Computer Science, Data Engineering or related field.

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 query design, materialization, and clustering.
• Uphold data quality, lineage, and documentation standards.
• Partner with analytics, engineering, and platform teams to align data standards.

Skills

SQL proficiency

dbt

Snowflake

Data modeling

ETL/ELT design

Education

Bachelor's or Master's in CS / Data Eng

Tools

Informatica

Talend

ODI

SSIS

TOAD Data Modeler

Job description

Role

Data Warehouse Modeler/Engineer

Location Mode

On-site 5 days a week (Basildon or Dublin)

Employment Type

Full-Time Employment (FTE)

Job Overview

We are seeking a highly skilled Data Warehouse Modeler & Engineer (dbt & Snowflake) to join our EMEA Data Solutions domain. In this role, you will be key to designing and implementing robust, end-to-end data integration and transformation solutions on Snowflake. This position blends ETL/ELT architecture, data modeling, data mapping, and hands-on dbt development.

Key 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 (covering staging, integration layers, and 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.

Technical Qualifications

• Bachelor's or Master's degree in Computer Science, Data Engineering, or a related technical field.
• 7+ years of experience in data engineering or modeling within a fast-paced, enterprise-scale environment.
• Strong mastery of SQL alongside practical experience with dbt (Core/Cloud) or traditional ETL tools (Informatica, Talend, ODI, SSIS, etc.).
• Hands-on expertise in Snowflake data engineering.
• Solid background in SQL-based data modeling methodologies (Kimball, Inmon, Data Vault) and full ETL/ELT pipeline design.
• Deep comprehension of modern end-to-end data ingestion and transformation patterns.
• Proficiency in data quality assurance, data governance, and query optimization.
• Nice to have: Familiarity with the AWS data ecosystem (S3, Glue, EMR/PySpark, Apache Iceberg).

Non-Technical Skills & Competencies

• Proven sense of ownership, commitment, and personal accountability.
• Meticulous attention to detail with a proactive problem-solving mindset.
• Keen interest in novel data technologies and continuous innovation.
• Clear, effective verbal and written communication abilities.
• Experience leveraging AI-powered tools and workflows.

Skills Breakdown

Mandatory Skills: TOAD Data Modeler

Good to Have Skills: Data Modeling