Snowflake DATABASE ANALYST

TROYTECH INTERNATIONAL CONSULTING PTE LTD; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

A leading consulting firm seeks a certified Snowflake Developer with extensive experience in data warehousing and cloud technologies. The candidate will manage cloud services, automation, CI/CD practices, and oversee the migration of OLAP systems to Snowflake, contributing to the full software development lifecycle in a collaborative environment.

Qualifications

• Minimum 5 years in Snowflake, 10 years in data warehousing.
• Experience in UNIX/LINUX and Windows environments.
• Strong knowledge of data warehouse performance tuning.

Skills

Analytical skills

Problem-solving

Cloud technologies knowledge

Data warehousing

OLAP and OLTP concepts

Continuous Integration and Continuous Delivery (CI/CD)

Education

Snowflake Developer Certification

Experience in Software Development Lifecycle (RUP)

Job description

Qualifications & Requirements:

• Be certified Developer on the Snowflake solution.
• Minimum 5 years of relevant experiences on the Snowflake solution and 10 years of experience in the data warehouse domain
• Extensive Understanding of architecture and design in server and cloud technologies.
• Well-versed in both cloud and on-premise enterprise data warehouse, configuration and administration.
• Hands-on experience in managing cloud services, scripting and automation and administration tools
• Hands-on experience on Continuous Integration and Continuous Delivery (CI/CD) practices;
• Been through at least one full software Development Lifecycle using RUP. Have experience in developing and producing Requirements Specification, Use Cases, Design Model and Domain / Data modelling.
• Experience on proposed UNIX / LINUX and Windows environment
• Extensive data warehouse design experience with knowledge on OLAP and OLTP concepts.
• Extensive experience and knowledge in data warehouse performance tuning & maintenance, backup methodologies
• Extensive experience in migrating from current OLAP Database system (DB2) to Snowflake.
• Strong analytical and problem-solving skills
• Good written and verbal communication skills in English