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