Job Description
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.
Job Overview: We are looking for an experienced Snowflake Administrator to manage and optimize our Snowflake data warehouse environment. This individual will be responsible for implementing, maintaining, and enhancing Snowflake's features, ensuring optimal performance, security, and scalability for our data operations. 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. Skills and Qualifications: Proven experience as a Snowflake Administrator or in a similar role. Strong knowledge of Snowflake architecture, security, data loading, and query optimization. Hands-on experience with Snowflake's features such as Snowpipe, Streams & Tasks, and Snowflake Data Sharing. Experience in managing Snowflake in a multi-cloud environment (AWS, Azure, Google Cloud). Proficiency in SQL and other data management tools. Familiarity with ETL processes and tools. Strong problem-solving and troubleshooting skills. Ability to work well with cross-functional teams. Preferred Qualifications: Snowflake certification (e.g., Snowflake SnowPro Core Certification). Experience with scripting languages like Python or Shell. Familiarity with cloud platforms such as AWS, Azure, or Google Cloud. Must have good communication skills Must be open to shifting schedule arrangement. Minimum 3 year(s) of experience is required
