Junior Snowflake Data Engineer

Red Global; Greater London; On-site; GBP 40,000 - 70,000; Full time

Job summary

RED is seeking a Junior Snowflake Engineer for an on-site 12-month contract in Basildon, Essex. The role requires English writing and speaking skills and will be performed on a B2B contract.

You will design and optimize ETL/ELT pipelines, implement dbt models, and collaborate with data teams. Candidate should have 5 years of Snowflake experience and 5 years as a Data Engineer.

Qualifications

• Minimum 5 years experience with Snowflake.
• Minimum 5 years experience as Data Engineer.
• On-site 5 days/week in Basildon, Essex.
• 12 months B2B Contract.
• English writing and speaking proficiency.

Responsibilities

• Design and implement scalable ETL/ELT pipelines for data ingestion, transformation, and consolidation.
• Perform data mapping from source systems to Snowflake target models.
• Design, develop, and maintain conceptual, logical, and physical data models across staging, integration, and data mart layers.
• Build, test, and maintain dbt models following engineering best practices.
• Optimize Snowflake performance through efficient query design, materializations, and clustering strategies.
• Ensure data quality, consistency, lineage, and documentation standards are maintained.
• Collaborate with data engineering, analytics, and platform teams to establish and align data architecture patterns and standards.

Skills

Snowflake

Data Engineer

ETL/ELT pipelines

dbt models

SQL

Tools

Basildon, Essex

Job description

*** Junior Snowflake Engineer on-site 12 months contract opportunity ***

On behalf of one of our key partners, RED has a new opportunity for a Junior Snowflake Engineer to start ASAP on a B2B 12 months contract, on‑site project, English writing and speaking.

Qualifications

• 5 years experience with Snowflake
• 5 years of experience as Data Engineer
• To start ASAP
• On‑site 5 days/week in Basildon, Essex
• 12 months B2B Contract
• English writing and Speaker.
• Inside IR35

Key Responsibilities

• Design and implement scalable ETL/ELT pipelines for data ingestion, transformation, and consolidation.
• Perform data mapping from source systems to Snowflake target models.
• Design, develop, and maintain conceptual, logical, and physical data models across staging, integration, and data mart layers.
• Build, test, and maintain dbt models following engineering best practices.
• Optimize Snowflake performance through efficient query design, materializations, and clustering strategies.
• Ensure data quality, consistency, lineage, and documentation standards are maintained.
• Collaborate with data engineering, analytics, and platform teams to establish and align data architecture patterns and standards.

If you are interested, please contact Adriana Gomez on [e-mail] or apply here.