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.
