Snowflake developer

IPEM SOLUTIONS INC

Snowflake developer

Sacramento, CA
Full Time
Paid
  • Responsibilities

    Responsibilities and Duties:

    · Candidate must be able to design, develop and implement efficient and scalable data storage solutions using Snowflake.

    · Must be able to Write, optimize, and troubleshoot SQL queries within the Snowflake and SQL Server environments.

    · Integrate Snowflake with various data sources and third-party tools: for example: Salesfore, AWS S3, SQL Server.

    · Ensure data security (data encryption) and compliance with industry standards.

    · Collaborate with cross-functional (internal and client) teams to meet data-driven business objectives.

    · Stay updated with the latest Snowflake features and best practices.

    Required skills and experience:

    · Candidate must possess a Bachelor's degree in Computer Science, Computer Engineering, or a software-related discipline or similar work experience in relevant field.

    · Mastery skills in SQL and familiar with ETL (extraction, transformation, and Load) processes

    · Experience with data modeling and cloud computing environments

    · Must possess hands-on experience with Snowflake features like Time Travel and Zero-Copy Cloning

    · Understanding of data compliance and security best practices

    · Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe,Able to administer and monitor Snowflake computing platform

    · Handling large and complex sets of XML, JSON, and CSV from various sources and databases

    · Experience with any scripting languages, preferably Python

    Preferred skills and experience:

    · SnowPro Certification

    · Familiarity with BI tools integration, such as Tableau or Looker

    · Proven track record of data migration and optimization within Snowflake

    · Ability to translate business needs into technical specifications

    Experience in performance tuning and cost optimization in a cloud data platform

    Flexible work from home options available.