Data Engineer (Snowflake).

Avensys is a reputed global IT professional services companyheadquartered in Singapore. Our service spectrum includes enterprise solutionconsulting, business intelligence, business process automation and managedservices.

Given our decade of success we have evolved to become one of the toptrusted providers in Singapore and service a client base across banking andfinancial services, insurance, information technology, healthcare, retail, andsupply chain. We are currently looking to hire Data Engineer (Snowflake).

This is an exciting opportunity to expand your skill set, achieve jobsatisfaction and work-life balance. More details as below. Job Role: JobDescription Role Overview We are modernising an enterprise data warehouse to acloud-native analytics platform on AWS and Snowflake.

We are looking for ahands-on Snowflake Data Engineer to build and support reliable ingestion andELT pipelines, dimensional data models, and production-ready data solutions.

The role will work closely with senior engineers, architects, QA,cloud/platform teams, and BI users through design, development, testing,deployment, and operational handover.

Key Responsibilities

- Design, develop, and maintain data pipelines anddata warehouse layers in Snowflake, including RAW, ODS, and DW schemas, tables,and views.

- Implement data ingestion and orchestration usingSnowflake features such as Stages, Storage Integrations, Snowpipe, Tasks,Streams, and Stored Procedures, or equivalent approved patterns.

- Develop and maintain dimensional data models,including fact and dimension tables, transformations, aggregates, and lookupstructures. - 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 forfailed or incomplete data processing. - Work with AWS services such as S3 and IAM as partof secure cloud data integrati