Epicareer Might not Working Properly
Learn More

Snowflake Data Specialist

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

About Genzeon

Delivering excellence in IT services and solutions for the retail and healthcare sectors. Genzeon is a leading provider of intelligent automation, security, compliance, cloud, and managed services. Our healthcare capabilities integrate data systems, facilitate information flow, and leverage interoperability to improve clinical and operational outcomes. Genzeon empowers retail enterprises with multichannel IT solutions that deliver a personalized experience for consumers.

Genzeon has an exciting opening for Snowflake Data Specialist to join our team.

Position: Snowflake Data Specialist Location: Remote

Summery

We are hiring a dynamic Snowflake Data Specialist who will perform mission critical duties in our data Service Delivery strategy, contributing to the maturity and governance of our Core Data Services Platform. A passionate professional who can blend the ever-evolving technology landscape of Cloud and Advanced Analytics with responsibilities to provide input on implementation and administration methodologies to Technology stakeholders.

The Snowflake Data Specialist will mainly be responsible to develop, optimize and oversee company s logical, conceptual, and physical data model and provide recommendations.

Responsibilities

  • Experience with data security and data access controls and design in Snowflake.
  • Proficiency in complex SQL, Unix Shell/Python Scripting, performance tuning and database optimization techniques.
  • Must have expertise in Azure Platform as a Service (PAAS) model and its integration with Snowflake to load/unload data.
  • Implement/Maintain cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake environment to build data movement strategy.
  • Lead in highlighting technical debt and gaps for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.
  • Recommend necessary updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment.
  • Act as Data domain expert for Snowflake in a collaborative environment to provide demonstrated understanding of data management best practices and patterns.
  • Candidate will be responsible to attend on-call after office hours including weekend to support High and Critical production issues.
  • Actively contribute to the supportability of the applications as well as continuous service improvement projects.
  • Develop understanding of client s systems and products utilizing reference materials and support procedures.

Required Skills and Level of Experience

  • 8+ years of experience implementing/maintaining data management solutions
  • Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, time travel and automating them.
  • Experience in handling semi-structured data (JSON, XML),
  • Experience in in re-clustering of the data in Snowflake with good understanding on Micro-Partitions.
  • Well versed with Snowflake DevOps procedures, grants, privileges with snowflake costing optimization background.
  • Experience in Migration processes to Snowflake from on-premises database environment and cloud based.
  • Experience in designing and building manual or auto ingestion data pipeline using Snowpipes.
  • Az-900 Certification will be an added benefit
  • Design and develop automated monitoring processes on Snowflake using combination of Python, PySpark, Bash with SnowSQL.
  • Snow SQL Experience in developing stored Procedures writing Queries to analyze and transform data.
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