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 integration.

-      Support SIT, UAT, deployment, documentation, andoperational handover activities.

-      Collaborate with senior engineers and architects,follow agreed engineering standards, and contribute to code reviews andcontinuous improvement.

Qualifications Requirements (Must-Have)

-      3+ years of experience in data engineering, datawarehousing, or database development.

-      Hands-on experience with Snowflake, or practicalexperience with another cloud data warehouse and the ability to ramp up quicklyon Snowflake.

-      Strong SQL skills, including joins, windowfunctions, data transformations, and query troubleshooting.

-      Good understanding of dimensional modelling,including fact and dimension table design.

-      Experience developing or supporting ETL/ELTpipelines and production data workflows.

-      Basic understanding of data quality,reconciliation, logging, retry, and operational support practices.

-      Ability to work effectively in a delivery team,communicate clearly, and take ownership of assigned datasets or pipelinecomponents. Plus Points (Advantage)

-      Hands-on experience with Snowpipe, Tasks, Streams,Stored Procedures, Stages, or Storage Integrations.

-      Oracle Data Warehouse or legacy data platformmigration experience.

-      Experience handling semi-structured data such asXML, JSON, or Snowflake VARIANT.

-      AWS experience, particularly S3, IAM, encryption,and cloud integration patterns.

-      Experience with Git-based development, CI/CD, orautomated deployment practices for data solutions.

-      Familiarity with Tableau or other BI tools andgoverned dataset publishing.

-      Relevant Snowflake, cloud, data engineering, AI,ML, or GenAI certification(s).

What We Value

-      Strong engineering fundamentals and willingness tolearn. - Practical problem-solving and attention to data correctness.

-      Clean implementation, documentation discipline, andreliable delivery.

-      Ability to work in a fast-paced project environmentand collaborate with different technical teams.

-      Ownership of assigned tasks and openness totechnical guidance and feedback.

-      A good overall match is more important than meetingevery listed technology requirement.

-      Ability to join immediately or within 1–2 months ispreferred. Role Expectations

-      Able to independently deliver assigned pipelines,datasets, or data warehouse objects with guidance from senior team members.

-      Able to investigate data issues, explain findings,and implement appropriate fixes.

-      Comfortable supporting testing, deployment, andoperational readiness activities.

-      Able to learn Snowflake features andproject-specific patterns quickly.

CONSULTANTDETAILS

ConsultantName: Abinaya R Reg No: R1765546 Avensys Consulting Pte Ltd EA Licence 12C5759Privacy Statement: Data collected will be used for recruitment purposes only.Personal data provided will be used strictly in accordance with the relevantdata protection law and Avensys' privacy policy.