Snowflake Data Engineer: Cloud ELT & Data Warehouse

U3 INFOTECH PTE. LTD.; Singapore; On-site; SGD 110,000 - 170,000; Full time

Job summary

U3 INFOTECH PTE. LTD. is modernizing an enterprise data warehouse to a cloud-native analytics platform on AWS and Snowflake. We seek a hands-on Snowflake Data Engineer to build and support reliable ingestion and ELT pipelines, dimensional data models, and production‑ready data solutions.

You will collaborate with senior engineers, architects, QA, cloud/platform teams, and BI users through design, development, testing, deployment, and handover phases.

Qualifications

• Hands-on experience building data pipelines in Snowflake.
• Design dimensional models and data warehouse layers.
• Strong SQL for data transformation, validation and troubleshooting.

Responsibilities

• Design, develop, and maintain data pipelines and data warehouse layers in Snowflake, including RAW, ODS, and DW schemas, tables, and views.
• Implement data ingestion and orchestration using Snowflake features such as Stages, Storage Integrations, Snowpipe, Tasks, Streams, and Stored Procedures, or equivalent patterns.
• Develop and maintain dimensional data models, including fact and dimension tables, transformations, aggregates, and lookup structures.
• Write and optimise SQL for data transformation, reconciliation, troubleshooting, and performance improvement.
• Implement data quality checks, validation, reconciliation, logging, and error‑handling controls.
• Support rerun, recovery, and replay activities for failed or incomplete data processing.
• Work with AWS services such as S3 and IAM as part of secure cloud data integration.
• Support SIT, UAT, deployment, documentation, and operational handover.

Skills

Snowflake data modeling

SQL

ETL/ELT design

Tools

Snowflake

Snowpipe

Stages

Streams

Stored Procedures

AWS S3

IAM

Job description

U3 INFOTECH PTE. LTD. is modernizing an enterprise data warehouse to a cloud-native analytics platform on AWS and Snowflake. We seek a hands-on Snowflake Data Engineer to build and support reliable ingestion and ELT pipelines, dimensional data models, and production‑ready data solutions.

You will collaborate with senior engineers, architects, QA, cloud/platform teams, and BI users through design, development, testing, deployment, and handover phases.