Snowflake Data Engineer: Cloud DW & ELT Specialist

ELLIOTT MOSS CONSULTING PTE. LTD.; High Street, Penarth; On-site; GBP 70,000 - 95,000; Full time

Job summary

Elliott Moss Consulting Pte. Ltd. is seeking a hands-on Snowflake Data Engineer to modernize an enterprise data warehouse into a cloud-native analytics platform on AWS.

You will build scalable data pipelines, model data in a dimensional schema, and deliver reliable ELT solutions while collaborating with architects, QA, cloud engineers, and business stakeholders. The role requires 3+ years in data engineering, Snowflake experience, and strong SQL skills.

Qualifications

• 3+ years experience in Data Engineering or Data Warehousing.
• Hands-on Snowflake experience or with another cloud data warehouse.
• Strong SQL skills and query optimization.
• Knowledge of dimensional modelling (Star Schema).
• Experience developing ETL/ELT pipelines.
• Knowledge of data quality, logging, monitoring and production support.
• Analytical, communication and problem-solving skills.
• Ability to work independently and in Agile delivery environments.

Responsibilities

• Design, develop and maintain data pipelines and warehouse layers (RAW, ODS, DW) in Snowflake.
• Build and support ELT/ETL pipelines using Snowflake features (Snowpipe, Tasks, Streams, Stages, Storage Integrations, SP).
• Develop dimensional data models including fact and dimension tables.
• Write, optimize, and troubleshoot complex SQL queries for transformation and performance.
• Implement data quality checks, validation, logging and error handling.
• Support rerun, recovery and replay of failed data loads.
• Integrate data securely using AWS services such as S3 and IAM.
• Participate in SIT, UAT, deployment and production support.
• Collaborate with architects and engineers, following coding standards.
• Contribute to code reviews and continuous improvement.

Skills

Data engineering

SQL

Dimensional modelling

ETL/ELT pipelines

Data quality & monitoring

Agile delivery

Communication

Problem-solving

Independent & collaborative work

Tools

Snowflake

AWS (S3, IAM)

Job description

Elliott Moss Consulting Pte. Ltd. is seeking a hands-on Snowflake Data Engineer to modernize an enterprise data warehouse into a cloud-native analytics platform on AWS.

You will build scalable data pipelines, model data in a dimensional schema, and deliver reliable ELT solutions while collaborating with architects, QA, cloud engineers, and business stakeholders. The role requires 3+ years in data engineering, Snowflake experience, and strong SQL skills.