C
Snowflake Administrator
Salary undisclosed
Apply on
Availability Status
This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.
Original
Simplified
Job Description
Job Description
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job Similar Jobs