Senior Data Engineer

NCS PTE. LTD.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

NCS PTE. LTD. in Singapore is seeking a seasoned Data Architect/Engineer to design and implement scalable data storage and pipeline solutions in Snowflake, spanning staging, serving and transformed layers.

You will model data, optimize SQL performance, and establish CI/CD between AWS CodeCommit and Snowflake while ensuring data security and governance. You will collaborate with stakeholders to ensure timely delivery.

Qualifications

• Strong proficiency in SQL, including complex query development and optimization.
• At least 5 years of proven experience in ETL and data pipeline implementation on cloud data warehouse platforms.
• Hands-on experience in data modelling and performance tuning.
• Strong communication and collaboration skills across technical and non-technical stakeholders.
• A results-oriented, proactive, and assertive mindset with a strong drive for delivery.

Responsibilities

• Data Architecture & Data Modelling across staging, serving, and transformed layers.
• Build and maintain end-to-end ETL pipelines within Snowflake.
• Set up CI/CD pipelines between AWS CodeCommit and Snowflake, including environment promotion.
• Configure secure integrations between Snowflake and AWS services and enforce governance.
• Write and optimize complex SQL queries to meet performance targets.
• Collaborate with leads, developers, vendors, and management to drive delivery.

Skills

SQL proficiency

ETL pipelines

Data modelling

Communication

Delivery mindset

Education

SnowPro - Associate certification

Tools

Snowflake

AWS CodeCommit

Job description

What will you do?

Data Architecture & Data Modelling

Design and implement scalable data storage solutions using Snowflake architecture

Support structured and unstructured data across staging, serving, and transformed layers

Implement data modelling patterns including slowly changing dimensions and surrogate key strategies

Define and implement data quality checks, validation rules, and data masking using Snowflake DMF functions and data masking rules

ETL / ELT & Data Pipeline Engineering

Build and maintain end-to-end ETL pipelines within the Snowflake environment

Set up CI/CD pipelines and deployment automation between AWS CodeCommit and Snowflake, including environment promotion

Ensure reliable, maintainable, and well-documented data pipelines

Cloud Integration & Security

Configure and optimize secure integrations between Snowflake and AWS services, including S3

Ensure data access, storage, and movement comply with security and governance requirements

SQL Performance & Optimization

Write, optimize, and troubleshoot complex SQL queries

Tune performance to meet scalability, reliability, and business performance requirements

Delivery & Stakeholder Collaboration

Work closely with functional leads, developers, partner vendors, and management to gather requirements and provide technical guidance

Take a proactive and assertive role in chasing dependencies, mitigating risks, and driving projects to on-time completion

Qualifications

• Strong proficiency in SQL, including complex query development and optimization
• At least 5 years of proven experience in ETL and data pipeline implementation on cloud data warehouse platforms
• Hands-on experience in data modelling and performance tuning
• Strong communication and collaboration skills across technical and non-technical stakeholders
• A results-oriented, proactive, and assertive mindset with a strong drive for delivery

Preferred qualifications:

• SnowPro - Associate certification