Job title: Snowflake Developer :::: 100 % Remote
Company: SysMind
Job description: Position: Sr. Snowflake DeveloperLocation: 100 % RemoteDuration: 6-12+ MonthsMin overall IT experience required: 15+ YearsMust Have Skill:AWS RedshiftJob Description:
- In this role, Candidate will work closely with our Product, Engineering, IT, and Data Science teams to build best in class infrastructure supporting data across the company.
- Should have experience in AWS Redshift.
- 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.
Thanks and RegardsMohd Humza
Technical Recruiter at SYSMINDPhone 609-897-9670 x 2193EmailWebsiteIMPORTANT: The contents of this email and any attachments are confidential. They are intended for the named recipient(s) only. If you have received this email by mistake, please notify the sender immediately and do not disclose the contents to anyone or make copies thereof.
Expected salary:
Location: USA
Job date: Fri, 25 Oct 2024 01:47:25 GMT
Apply for the job now!