Job Description

Key Responsibilities:

Installation and Configuration:

• Install and configure Snowflake in alignment with best practices and organizational requirements.
• Set up and manage user accounts, roles, and security policies to control data access.

Performance Optimization:

• Monitor and optimize the performance of Snowflake, including query performance and data loading.
• Implement strategies to ensure efficient resource utilization and minimal latency in data processing.

Data Integration:

• Work closely with data engineers to integrate data from various sources into Snowflake.
• Design and manage ETL processes for data loading, transformation, and integration.

Security and Compliance:

• Implement and enforce security measures, including encryption, authentication, and authorization.
• Ensure compliance with data protection regulations and internal data security policies.

Backup and Recovery:

• Develop and maintain backup and recovery strategies to safeguard data against loss or corruption.
• Test and execute recovery procedures to minimize downtime in case of system failures.

Monitoring and Maintenance:

• Monitor system health and performance using monitoring tools and take proactive measures to address issues.
• Apply software updates, patches, and upgrades as necessary to keep the Snowflake environment up to date.

Capacity Planning:

• Estimate resource requirements and plan for scalability as data volumes and user demands grow.
• Scale up or down resources as needed to maintain optimal performance.

Documentation and Training:

• Document system configurations, procedures, and troubleshooting steps.
• Provide training and support to users, data analysts, and other stakeholders to enable effective use of Snowflake.

Collaboration:

• Collaborate with data teams to understand their requirements and assist in the design of data models and schemas.
• Provide technical guidance and expertise on Snowflake-related matters.

Qualifications and Skills:

• Bachelor\'s degree in Computer Science, Information Technology, or related field (or equivalent work experience).
• SnowPro Certified
• Proven experience as a database administrator or data engineer, with specific experience in managing Snowflake.
• Strong understanding of data warehousing concepts, ETL processes, and SQL.
• Proficiency in Snowflake architecture, administration, and performance tuning.
• Familiarity with cloud platforms (e.g., AWS, Azure, Google Cloud) and experience working with cloud-based data solutions.
• Solid understanding of data security and compliance best practices.
• Excellent problem-solving skills and the ability to troubleshoot complex technical issues.
• Strong communication skills to collaborate effectively with cross-functional teams.
• Relevant certifications in Snowflake administration or related areas are a plus.
• Python/C#/Java/Powershell
• Jenkins / Github Actions
• Github

Summary

As a Snowflake Administrator, you will play a pivotal role in managing the Snowflake data platform to ensure its reliability, performance, and security. Your expertise will contribute to the organization\'s data-driven initiatives and help drive business success through effective data management and analytics.

NICE Systems