Snowflake Data Engineer: ETL & Data Platform Builder

Zenith Infotech Pte Ltd.; Singapore; On-site; SGD 90,000 - 140,000; Full time

Job summary

Zenith Infotech Pte Ltd. is seeking a Data Engineer with strong Snowflake expertise to design, build, and maintain pipelines and data models for analytics teams.

You will transform raw data from multiple sources into trusted datasets and help shape our data platform as it scales. The role requires hands-on experience with Snowflake, SQL, Python, and cloud services, plus orchestration tools like Airflow or Prefect.

Qualifications

• 3–7 years of data engineering experience.
• Strong Snowflake experience including loading, tuning, and cost management.
• Advanced SQL skills with complex joins, window functions, CTEs, and query optimization.
• Proficiency in Python for data processing and automation.
• Solid understanding of data warehousing concepts, ETL/ELT patterns, and data modelling.
• Experience with orchestration tools such as Apache Airflow, Prefect, or Dagster.
• Experience with cloud platforms (AWS, Azure, or GCP) and their storage/compute services.
• Familiarity with Git and CI/CD workflows.
• Strong problem-solving skills and attention to detail.
• Good communication and ability to work in a cross-functional team.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines ingesting data from databases, APIs, files, and streaming sources into Snowflake.
• Develop and optimize data models (dimensional, star/snowflake, data vault where relevant) to support analytics and reporting.
• Write efficient, well-tested SQL and Python code for transformation and orchestration.
• Leverage Snowflake features like Snowpipe, Streams and Tasks, Time Travel, and Stored Procedures to build robust workflows.
• Monitor and tune Snowflake performance and cost, including warehouse sizing, clustering, and resource monitors.
• Implement data quality checks, monitoring, alerting, and lineage for trusted data.
• Apply data security and governance best practices, including RBAC, masking policies, and privacy compliance.
• Orchestrate and schedule workflows using Airflow, dbt, or equivalents.
• Collaborate with analysts, data scientists, product managers, and engineers to deliver solutions.
• Contribute to documentation, code reviews, CI/CD practices, and continuous platform improvement.

Job description

Zenith Infotech Pte Ltd. is seeking a Data Engineer with strong Snowflake expertise to design, build, and maintain pipelines and data models for analytics teams.

You will transform raw data from multiple sources into trusted datasets and help shape our data platform as it scales. The role requires hands-on experience with Snowflake, SQL, Python, and cloud services, plus orchestration tools like Airflow or Prefect.