Snowflake consultant

26 Mar 2024

Vacancy expired!

Certification:
  • Snowpro Core
  • Snowpro Advanced desirable

Essential
  • At least 3 years’ experience within Data & Analytics
  • A background in SQL and principles of data warehousing
  • Experience of ETL design and dev, including Test-Driven development.
  • Snowflake design and engineering experience and certification plus exposure to one of either Azure, AWS or Google Cloud Platform
  • Experience in end-to-end implementation of Snowflake cloud data warehouse and end to end data warehouse implementations on-premise
  • Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
  • At least 2 years experience using DBT
  • Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
  • Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)

Desirable
  • Experience of programming languages including Object-Oriented language (.Net. Java, C, Python)
  • GIT experience
  • Good knowledge of DevOps / DataOps principles with working knowledge of Docker and Linux
  • Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning
  • Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
  • Experience with data security and data access controls and design
  • Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
  • A track record of achievement and recognition within the IT industry as evidenced by significant promotion since leaving University.
  • A strong academic track record including the achievement of a good honours degree or equivalent.

  • ID: #49551274
  • State: New York Newyorkcity 10001 Newyorkcity USA
  • City: Newyorkcity
  • Salary: Depends on Experience
  • Job type: Permanent
  • Showed: 2023-03-26
  • Deadline: 2023-05-23
  • Category: Et cetera