What are the responsibilities and job description for the Urgent Hybrid Opening Snowflake Consultant - Columbus, OH - (local will be the priority). position at SmartIPlace?
Responsibilities
- 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.
- 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.
- 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
