Snowflake Administrator

Design, develop and maintain data solutions for data generation, collection, and processing. Create data pipelines, ensure data quality, and implement ETL (extract, transform and load) processes to migrate and deploy data across systems.

Key Responsibilities:

Database Management:

• Administer Snowflake's cloud data warehouse, including monitoring, performance tuning, troubleshooting, and issue resolution.
• Create and manage Snowflake accounts, users, roles, and permissions.
• Optimize the performance of Snowflake instances by configuring query and data storage settings.
• Perform regular database backups and recovery operations.
• Data Security and Compliance:
• Manage security best practices by implementing role-based access controls (RBAC).
• Ensure compliance with organizational data security policies.
• Implement encryption protocols for data in transit and at rest.

Cost Management:

• Monitor Snowflake usage and optimize costs by adjusting compute resources, storage, and scaling policies.
• Provide cost reports and suggest strategies for cost optimization.

Data Integration and ETL:

• Work with data engineers and analysts to integrate Snowflake with other data sources and tools.
• Manage ETL (Extract, Transform, Load) processes and monitor data pipelines to ensure smooth data flow into Snowflake.

Performance Tuning:

• Monitor query performance and implement strategies for improving performance (e.g., clustering keys, materialized views, partitioning).
• Ensure minimal downtime and maintain high availability of the platform.

Troubleshooting and Support:

• Provide technical support for Snowflake-related issues and escalate to vendors if necessary.
• Troubleshoot and resolve issues related to Snowflake queries, storage, and networking.

Collaboration and Reporting:

• Work with data architects and business stakeholders to ensure the Snowflake environment supports data needs.
• Provide periodic reports on system health, usage statistics, and performance metrics.