Snowflake Developer

Snowflake Developer

Location: Remote (USC only)

Job Type: Contract

Experience: Min 8 years (USC only)

Job Description:

We are seeking an experienced Snowflake Developer to join our team for an exciting project with our client. The ideal candidate will have at least 8 years of experience in data warehousing, ETL processes, and Snowflake platform development. As a Snowflake Developer, you will be responsible for designing, developing, and maintaining data pipelines, optimizing the Snowflake environment, and working with large datasets to support business intelligence initiatives.

Key Responsibilities:
• Design, develop, and implement data solutions in Snowflake, ensuring scalability and optimization.
• Collaborate with cross-functional teams to gather requirements and ensure alignment with business needs.
• Develop and optimize SQL queries, stored procedures, and other Snowflake objects.
• Build ETL pipelines for data integration from various sources into Snowflake.
• Implement data transformations and aggregation techniques to improve performance and data quality.
• Work with data architects to design and optimize data models in Snowflake.
• Troubleshoot and resolve data issues, performance bottlenecks, and production incidents.
• Participate in code reviews, ensuring adherence to best practices in development and security standards.
• Ensure the Snowflake environment is properly configured and maintained for security, availability, and performance.

Requirements:
• Minimum of 8 years of experience in data engineering, with at least 3-5 years of hands-on experience working with Snowflake.
• Strong proficiency in SQL, data modeling, and ETL processes.
• Expertise in Snowflake platform and its core components such as Snowflake schema, virtual warehouses, and Snowflake data sharing.
• Experience with cloud technologies, particularly AWS, Azure, or GCP.
• Proficient in data transformation and integration using tools like dbt, Informatica, Talend, or Matillion.
• Familiarity with data warehousing concepts and design.
• Excellent problem-solving skills and the ability to work independently as well as part of a team.
• Strong communication skills and experience in client-facing roles.

Additional Requirements:
• U.S. Citizen (USC only).
• Experience with other tools and technologies such as Python, Spark, or Tableau is a plus.