Data Engineer (Snowflake)

Unison Consulting Pte Ltd; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

A leading consulting firm in Singapore is seeking a Data Engineer to design, develop, and maintain data transformation pipelines using DBT and Snowflake. The ideal candidate has over 3 years of experience, strong PL/SQL skills, and a solid understanding of data modeling concepts. This role offers an opportunity to collaborate with data analysts and ensure high data quality in a dynamic environment.

Qualifications

• 3+ years of experience in data engineering or a related field.
• Strong hands-on experience with DBT.
• Advanced knowledge of PL/SQL.

Responsibilities

• Design and implement scalable data models and transformation pipelines.
• Write efficient and maintainable PL/SQL code.
• Collaborate with stakeholders to understand data requirements.

Skills

DBT expertise

Snowflake

PL/SQL

Data modeling

Version control (Git)

Tools

Airflow

dbt Cloud

Prefect

Job description

Overview

Data Engineer with deep expertise in DBT (Data Build Tool), Snowflake, and PL/SQL to join our growing data team. Person will be responsible for designing, developing, and maintaining robust data transformation pipelines that support business intelligence, analytics, and data science initiatives.

Key Responsibilities

• Design and implement scalable data models and transformation pipelines using DBT on Snowflake.
• Write efficient and maintainable PL/SQL code for complex data processing and transformation tasks.
• Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality solutions.
• Optimize Snowflake performance through query tuning, clustering, and resource management.
• Ensure data quality, integrity, and governance through testing, documentation, and monitoring.
• Participate in code reviews, architecture discussions, and continuous improvement initiatives.
• Maintain and enhance CI/CD pipelines for DBT projects.

Required Qualifications

• 3+ years of experience in data engineering or a related field.
• Strong hands-on experience with DBT (modular SQL development, testing, documentation).
• Proficiency in Snowflake (data warehousing, performance tuning, security).
• Advanced knowledge of PL/SQL and experience with stored procedures, functions, and packages.
• Solid understanding of data modeling concepts (star/snowflake schemas, normalization).
• Experience with version control systems (e.g., Git) and CI/CD practices.
• Familiarity with orchestration tools (e.g., Airflow, dbt Cloud, Prefect) is a plus.