Snowflake Admin

The Snowflake DevOps Engineer will be responsible for designing, deploying, and maintaining the Snowflake environments, enhancing Python-based data pipelines, and ensuring adherence to governance, security standards, and best practices. This role involves collaborating with cross-functional teams to deliver high-performance, scalable, and reliable data solutions across the organization using modern data technologies.

Reporting to the DevOps Engineering Manager, you will be responsible for handling the implementation and maintenance of a multi-tenant and global Snowflake platform for the data pipeline, ELTs and Analytics. Deep hands-on technical knowledge with a strong track record of implementing python/Snowflake solution and the Snowflake Administration.

Roles and Responsibilities:

• Enhance and modify existing Python-based ELT processes within the Snowflake environment.
• Develop Python scripts to automate Snowflake administration tasks.
• Leverage AWS infrastructure, including S3, EC2, EKS, and implement Unix shell scripting and Python scripting for automation.
• Administer Snowflake in sub-prod, production, and global environments, including creating databases, schemas, tables, views, external stages, and storage integrations.
• Troubleshoot data issues, debug Python code, and optimize SQL queries and business logic.
• Manage Snowflake features such as Streams, Tasks, Cloning, Time Travel, multi-cluster warehouses, and ensure scalability for diverse workloads.
• Implement security best practices for role-based access, user privileges, and integrate with external tools as required.
• Proactively design and implement process improvements, such as automation of manual tasks, optimizing data flows, and ensuring cost-effectiveness and scalability.
• Utilize optimization techniques like materialized views, clustering, micro-partitioning, and caching to enhance query performance.
• Administer Snowflake SSO/Okta integration, AD Group setups, access control, encryption, and security policies (Network, Row Access, Masking).
• Support integration of Tableau, SAS, Python, and JDBC connections with Snowflake.
• Manage CI/CD pipelines within Snowflake, oversee schema changes, and ensure smooth deployment processes.
• Collaborate with Data Modelers, Engineers, Architects, and Information Security teams to ensure consistency, adherence to best practices, and regulatory compliance

Qualification:

• Bachelor’s degree in a relevant field.
• 10+ years of IT experience, including 5+ years in DevOps or Database Administration roles.
• 3+ years of hands-on experience with Snowflake administration, Python ELT, SQL, Unix, Shell scripting and AWS services like EC2 and S3.
• Preferred certifications in Snowflake, Python, or AWS.
• Previous experience in the financial industry is a plus.
• Strong communication and collaboration skills with attention to detail.
• Proven ability to design effective solutions, maintain consistency, and drive disciplined execution.

This role is ideal for an engineer who thrives in a fast-paced environment, enjoys solving complex data challenges, and is committed to operational excellence in Snowflake platform management.