Snowflake Administrator

W2 Only

Job Summary:

• Experienced Snowflake Cloud Data Platform Administrator who will plan design develop and implement Snowflake cloud data platform that follows industry best practices.
• Snowflake administrator will be integral part of team that is responsible for technical deployments for Snowflake working with internal and external customers.
• Snowflake administrator with broad range of skills and experience ranging from security performance analysis observability automation.

What you will be doing:

• Work in a geographically distributed team to provide robust enterprise data platform in Snowflake
• Design optimize document and implement the operational aspects in supporting the snowflake cloud data platform. Including cost monitoring and optimizations user security auditing
• Implement/support automation for production deployment in Snowflake
• Implement Snowflake standards and methodologies for DB security both infrastructure and app level
• Implement/support automation for administering Snowflake Accounts/Databases and access roles
• Implement data sharing /replication cross cloud/cross region for internal/external clients
• Create Snowflake utilization and capacity plan
• Propose and implement DB / Snowflake query performance optimizations.
• Identify system bottlenecks and recommend solutions
• Implement Snowflake user /query log analysis and alerts
• Implement data encryption/decryption/masking policies to protect PII/PCI data and ensuring that the platform is SOX compliant
• Work as admin on Snowflake on Azure i.e. Configuration Data migration and security ensuring the configuration aligns with policies and standards
• responsible for ensuring that the platform is SOX compliant

What you bring:

• Technical expertise in all aspects of Snowflake
• Experience in implementing Snowflake external functions
• Experience securing sensitive data PII/PCI data in snowflake
• Handson experience in administering Snowflake in Azure.
• Experience with AWS CLI and Networking
• Knowledge of security (SAML SCIM OAuth OpenID Kerberos Policies entitlements etc.)
• Experience with architecting and maintaining high availability production systems
• Experience with developing monitoring architecture and implementing monitoring agents dashboards escalations and alerts
• Knowledge of security controls for the public cloud (encryption of data in motion/rest and key management)
• Demonstrated proficiency of index design query plan optimization and analysis required
• Handson experience in administration of relational Databases Data Warehouse and Data marts.
• Demonstrated knowledge and handson experience with Azure alerting/monitoring tools
• Experience with Agile and DevOps concepts
• Strong development skills in Python or other scripting language

Experience & Certifications:

• Minimum 3 years of related experience in Snowflake administration
• Minimum 5 years of Database administration and data engineering
• Experience using Azure services
• Extensive handson experience with SQL
• Snowflake Pro certification preferred
• Bachelors Degree and 5 years of work experience (or) Masters Degree and 3 years of work experience in Computer Science Information Systems or another related field.

Added bonus if you have:

• Azure Certification
• Spark Experience
• Airflow Experience

Remote Work :

No