Epicareer Might not Working Properly
Learn More
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