Snowflake Data Engineer | Yearly Renewable Contract
Salary: $6,000 – $6,900 per month
Responsibilities
Design, develop, and maintain data pipelines and data warehouse layers in Snowflake, including RAW, ODS, and DW schemas, tables, and views.
Implement data ingestion and orchestration using Snowflake 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 lookup structures.
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 for failed or incomplete data processing.
Work with AWS services such as S3 and IAM as part of secure cloud data integration.
Support SIT, UAT, deployment, documentation, and operational handover activities.
Collaborate with senior engineers and architects, follow agreed engineering standards, and contribute to code reviews and continuous improvement.
Essential Qualifications
Minimum 3+ years of experience in data engineering, data warehousing, or database development.
Hands-on experience with Snowflake, or practical experience with another cloud data warehouse and the ability to ramp up quickly on Snowflake.
Strong SQL skills, including joins, window functions, data transformations, and query troubleshooting.
Good understanding of dimensional modelling, including fact and dimension table design.
Experience developing or supporting ETL/ELT pipelines 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 pipeline components.
Hands-on experience with Snowpipe, Tasks, Streams, Stored Procedures, Stages, or Storage Integrations.
Oracle Data Warehouse or legacy data platform migration experience.
Experience handling semi-structured data such as XML, JSON, or Snowflake VARIANT.
AWS experience, particularly S3, IAM, encryption, and cloud integration patterns.
Experience with Git-based development, CI/CD, or automated deployment practices for data solutions.
Familiarity with Tableau or other BI tools and governed dataset publishing.
Interested candidates, please click on the following link to begin your job search journey and submit your curriculum vitae (CV) directly.
By sending us your personal data and curriculum vitae (CV), you are deemed to consent to PERSOL Singapore Pte Ltd (""PERSOL"") and its local and overseas subsidiaries and affiliates to collect, use and disclose your personal data to prospective employers/companies based in any country for purposes of evaluating suitability for employment, conducting reference checks, administering employment related services, complying with Government’s health advisories and such other purposes stated in our Privacy Policy.
We may use artificial intelligence (""AI"") and machine learning technologies to support our recruitment and placement services, including screening resumes, assessing qualifications and experience, and identifying skills and job matches. Where permitted by applicable law, we may also use such personal data to develop, train, test, improve and/or fine-tune AI and machine learning technologies that support our recruitment and business operations.
For more information on how we collect, use, disclose and protect your personal data, please refer to our Privacy Policy: https://www.persolsingapore.com/policies. If you wish to withdraw your consent, including consent relating to the use of your personal data for AI-enabled recruitment activities and AI development activities, please email us at sg.dataprotection@persolapac.com.
PERSOL Singapore Pte Ltd • RCB No. 200007268E • EA License No. 01C4394• Reg. R26159701 (Noor Eliza Chai Binti Ibrahim Essini Chai)