Snowflake Consultant[Hybrid]

Position : Snowflake

Location : Hybrid in Columbus, OH (local only)

Visa : USC/GC/GC-EAD/H4-EAD only (No fake Visa at all)

Interview : Video

Rate : $55-60 for 7-10 years and $65-70/hr for Architect level

Responsibilities

Job Description for the Snowflake positions -

• Provide Snowflake database technical support in developing reliable, efficient, and scalable solutions for various projects on Snowflake.
• Design and develop Snowpark features in Python, understand the requirements and iterate.
• Interface with the open-source community and contribute to Snowflake's open source libraries including Snowpark Python and the Snowflake Python Connector.
• Create, monitor, and maintain role-based access controls, Virtual warehouses, Tasks, Snowpipe, Streams on Snowflake databases to support different use cases.
• Performance tuning of Snowflake queries and procedures. Recommending and documenting the best practices of Snowflake.
• Explore the new capabilities of Snowflake, perform POC and implement them based on business requirements.
• Responsible for creating and maintaining the Snowflake technical documentation, ensuring compliance with data governance and security policies.
• Implement Snowflake user /query log analysis, History capture, and user email alert configuration.
• Enable data governance in Snowflake, including row/column-level data security using secure views and dynamic data masking features.
  
  

Required Technical Skills

• Proficiency in Data Warehousing, Data migration, and Snowflake is essential for this role.
• Strong Experience in the implementation, execution, and maintenance of Data Integration technology solutions.
• Minimum (4-6) years of hands-on experience with Cloud databases.
• Minimum (2-3) years of hands-on experience with the Snowflake platform along with Snowpipe and Snowpark.
• Strong experience with Snow SQL, PL/SQL, and expertise in writing snowflake procedures using SQL/python/Java.
• Experience with optimizing Snowflake database performance and real-time monitoring.
• Strong database architecture, critical thinking, and problem-solving abilities.
• Knowledge of Big data tools & technologies and platforms is preferred.
• Knowledge of distributed computing platforms like Spark, DASK preferred.
• Experience with the AWS platform Services.
• Strong networking skills with Snowflake technolgy
• Snowflake Certification is Highly desirable.
• Snowpark with Python programming languages is preferred to be used to build data pipelines.
  
  

Nice To Have Skills

• In addition, to overall Snowflake experience, a candidate should have experience in the development work in both the Snowpipe and Snowpark.
  
  

Experience with Data Migration using Snowflake

• Strong understanding of Snowflake capabilities like Snowpipe, STREAMS, TASKS etc.
• Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.).
• Has experience with System DRP for Snowflake systems