Snowflake Admin
ConnectedX Inc - plano, TX
Apply NowJob Description
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.
Created: 2024-10-16