Snowflake developer

$83,200 - $83,200/Yr

IPEM SOLUTIONS INC - Sacramento, CA

Full-time - Mid Level

Remote - Sacramento, CA

About the position

The Snowflake Developer at IPEM Solutions Inc. is responsible for designing, developing, and implementing efficient and scalable data storage solutions using Snowflake. This role involves optimizing SQL queries, integrating Snowflake with various data sources, ensuring data security, and collaborating with cross-functional teams to achieve data-driven business objectives.

Responsibilities

• Design, develop, and implement efficient and scalable data storage solutions using Snowflake.
• Write, optimize, and troubleshoot SQL queries within the Snowflake and SQL Server environments.
• Integrate Snowflake with various data sources and third-party tools such as Salesforce, AWS S3, and SQL Server.
• Ensure data security and compliance with industry standards, including data encryption.
• Collaborate with cross-functional teams to meet data-driven business objectives.
• Stay updated with the latest Snowflake features and best practices.

Requirements

• Bachelor's degree in Computer Science, Computer Engineering, or a related field, or equivalent work experience.
• Mastery of SQL and familiarity with ETL processes.
• Experience with data modeling and cloud computing environments.
• Hands-on experience with Snowflake features like Time Travel and Zero-Copy Cloning.
• Understanding of data compliance and security best practices.
• Experience with Snowflake utilities, SnowSQL, and SnowPipe.
• Ability to handle large and complex sets of XML, JSON, and CSV from various sources and databases.
• Experience with scripting languages, preferably Python.

Nice-to-haves

• 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.

Benefits

• Flexible work from home options.