Vacancy expired!
Job Title: Sr. Snowflake Developer (C2C/W2) Location: Remote till Pandemic Duration: Long Term Contract Description:
- 15 years' of experience needed.
- Client is looking for someone who has AWS Redshift & Snowflake experience and a bit of senior guy 15 years' experience.
- In this role, you will work closely with our Product, Engineering, IT, and Data Science teams to build best in class infrastructure supporting data across the company
- Design, Deploy & Monitor Multi-tenant Lakehouse environment.
- Design, Deploy the RBAC security Model in Multi-tenant Lakehouse environment.
- Design, build, and own the core data models and key infrastructure to manage data and usage across our Snowflake/Redshift account with an emphasis on Multi Tenancy and Security.
- Responsible to integrate Snowflake/Redshift Database with SAML or OpenID Provider for Authentication
- Create Snowflake/Redshift utilization and Capacity Plan for general housekeeping as well as for peak period.
- Implement Snowflake/Redshift best practices & considerations for managing load operations and performance which will aid in creating right size Snowflake/Redshift warehouses.
- Implement Data Masking policies to protect PII/PCI Data.
- Create and manage multiple accounts across the Organization.
- Good knowledge of Time Travel & Cloning
- Automate tenant onboarding to Multi-Tenant Snowflake/Redshift Platform.
- Automate RBAC Security model with Sailpoint Integration.
- Automate Internal/External Data catalog.
- Good Understanding of data replication for data sharing across accounts and for failover scenarios
- Good Understanding of Snowflake ODBC, JDBC drivers as well as SnowSQL in terms of usage as well as troubleshooting any issues
- Good Understanding of Snowflake Snowpark
- Collaborate closely with Engineering, Product Management, IT, Finance, and Compliance to inform product decision making with data and to identify opportunities for system improvements.
- Collaborate with the Engineering, IT, and Compliance team to meet data governance requirements.
- Build dashboards to help IT Leadership monitor performance and availability of our system.
- Think creatively to find optimal solutions to our complex, often unstructured problems.
- Design and implement a data quality monitoring system. The system should include source-to-target data validations as well as anomaly detection.
Vacancy expired!