Data Engineer

ELLIOTT MOSS CONSULTING PTE. LTD.

Penarth, UK

4 days ago

Apply on www.collegerecruiter.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Working hours

Regular working hours

Job source

www.collegerecruiter.com

Tech stack

Sql Data Warehouse Artificial Intelligence Amazon Web Services Amazon S3 Code Review Continuous Integration Data Validation Information Engineering Extract Transform Load (ETL) Data Warehousing Database Development Database Queries

+22 more

Dimensional Modeling Identity and Access Management JSON Lookup Table Oracle Warehouse Builder Performance Tuning Query Optimization SQL Stored Procedures Systems Integration Tableau (Software) Extensible Markup Language (XML) Data Logging Freeform SQL Snowflake Git Semi-structured Data Deployment Automation Star Schema Data Management Cloud Integration Data Pipelines Legacy Systems

Job description

We are looking for a hands-on Snowflake Data Engineer to support the modernization of an enterprise data warehouse to a cloud-native analytics platform on AWS and Snowflake.
You will be responsible for building scalable data pipelines, developing dimensional data models, and delivering reliable ELT solutions while working closely with architects, senior engineers, QA teams, cloud engineers, and business stakeholders., * Design, develop, and maintain data pipelines and warehouse layers (RAW, ODS, DW) in Snowflake.
Build and support ELT/ETL pipelines using Snowflake features such as Snowpipe, Tasks, Streams, Stages, Storage Integrations, and Stored Procedures.
Develop dimensional data models including fact tables, dimension tables, aggregates, and lookup tables.
Write, optimize, and troubleshoot complex SQL queries for transformation, reconciliation, and performance tuning.
Implement data quality checks, validation, reconciliation, logging, and error-handling mechanisms.
Support rerun, recovery, and replay processes for failed data loads.
Integrate data securely using AWS services such as S3 and IAM.
Participate in SIT, UAT, deployment, documentation, and production support.
Collaborate with architects and engineering teams while following coding standards and best practices.
Contribute to code reviews and continuous improvement initiatives.

Requirements

3+ years of experience in Data Engineering, Data Warehousing, or Database Development.
Hands-on experience with Snowflake or another cloud data warehouse platform.
Strong SQL skills including joins, window functions, CTEs, query optimization, and troubleshooting.
Good understanding of dimensional modelling (Star Schema, Fact & Dimension tables).
Experience developing and maintaining ETL/ELT pipelines.
Knowledge of data quality, reconciliation, logging, monitoring, and production support.
Good analytical, communication, and problem-solving skills.
Ability to work independently and collaboratively in an Agile delivery environment.

Preferred Skills

Experience with Snowflake features: Snowpipe Tasks Streams Stages Storage Integrations Stored Procedures Experience migrating Oracle Data Warehouse or legacy platforms to Snowflake.
Experience handling semi-structured data (JSON, XML, VARIANT).
AWS knowledge, especially: Amazon S3 IAM Encryption Cloud integration Experience with Git, CI/CD, and deployment automation.
Exposure to Tableau or other BI reporting tools. Snowflake, AWS, Data Engineering, AI/ML, or GenAI certifications